Oracle ASM Or ZFS In Solaris 11

Nov 27, 2011

What kind of storage technology is recommended in order to implement an Oracle 11gr2 database in a Solaris 11 OS?

-Oracle ASM or the Solaris 11 ZFS filesystem.

Its any difference between the performance of both storage technologies?

View 1 Replies


ADVERTISEMENT

Oracle DB 11g For 32 Bit Solaris 10

Jan 17, 2013

I want to teach myself Oracle DB 11g so I've created an Oracle Solaris 10 VM (under Oracle Virtual Box, see a theme here?) and when I went to look for the 11g installer I could only find the x86_64 packages but not the x86 packages.

View 1 Replies View Related

Installation :: Oracle 11g 11.2.0.3 On Solaris 11.1

Nov 8, 2012

I'm trying to install the Oracle Database 11g release 11.2.0.3 on to Solaris 11.1. I've place the command below and the results of the command. See below:

./runInstaller -executePrereqs
Starting Oracle Universal Installer...

Checking Temp space: must be greater than 180 MB. Actual 2971 MB Passed
Checking swap space: must be greater than 150 MB. Actual 3554 MB Passed
Checking monitor: must be configured to display at least 256 colors. Actual 16777216 Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2012-11-08_04-50-43PM. Please wait ...louis@Solaris_T510:~/Downloads/Oracle_Database-11g_11.2.0.3/database$ Warning: Cannot convert string "-monotype-arial-regular-r-normal--*-140-*-*-p-*-iso8859-1" to type FontStruct
Warning: Cannot convert string "-monotype-arial-regular-r-normal--*-140-*-*-p-*-iso8859-2" to type FontStruct
[code]........

It appears to me that I'm missing a Font

View 13 Replies View Related

Installation :: Oracle 9i On Solaris 9

Aug 7, 2012

Share the document for 9i installation on solaris9. i got some document for 9i on solaris8 and 10 . if this is same for 9 ?

View 3 Replies View Related

Solaris 11 / Oracle Database Performance

Sep 16, 2013

We've been battling with very slow performance for some time. Herewith a detail description of the problem:

Solaris-11/ZFS/Oracle problem

We purchased Oracle T4-2 servers, and are experiencing some weird performance problems.

Hardware:
T4-2
2 x 600GB HDD per server
128GB memory per server
2 x dual port QLE2562 FO HBAs
IBM V7000 StorWyse data array
2 x CISCO MDS 9148 fibre optic fabric switches
Software:
Solaris 11.1
MPXIO
Solaris 10 branded local zones
ORACLE 10g Enterprise edition
Project for the oracle user:
user.oracle:100::oracle::process.max-file-descriptor=(basic,8192,deny);process.max-stack-size=(priv,32768,deny);project.max-shm-memory=(priv,21474836480,deny)

We received the first server and wanted to migrate our APPB application system and Oracle 10g Standard Edition database from our SUN T5240 to the T4-2.

T4-2 setup � Disk 0:
Global zone: Solaris 11.1 ( ZFS - whole disk for the root pool)
Local zones: On the Solaris 11 environment we built two branded Solaris 10 zones using an Oracle template provided on the Oracle website - solaris-10u11-sparc.bin.

Our complete database resides on the IBM data array, in UFS LUNs.The UFS LUNs were mounted onto ZFS mount-points in the root partition (/), and then LOFS mounted into the zones.

We started with the Solaris 11.1 environment.

1)After a day or two the performance of the database starts deteriorating rapidly. We then stop the database and reboot the machine. After the reboot the performance level is restored.
2)Another huge deterioration in performance happens when we unmount the V7000 LUNs, and reboot to the alternate Solaris, and re-mount the LUNs.
3)What further compounds the issue is that when we start another the database in the second zone, we see another huge performance degradation.
4)We have logged a call with ORACLE. They requested us to gather information which was analysed by them. They did not find anything wrong with the way ORACLE was installed and the setup of the instances.

On Disk 1 we did a Solaris 10 8/11 (Update 10) installation, which we patched with the April 2013 CPU patchset. In this Solaris 10 global zone we built two native Solaris 10 local zones. The Oracle 10g databases were built in the zones (same configurations settings) not in the global zone, onto UFS LUNs. The database in its entirety lives on the IBM V7000 data array. This works fine.

We then received our next T4-2 server.Loaded it again with Solaris 11.1, and upgraded to ORACLE 12c SE Release 12.1.0.1.0 - 64bit12xxx seeing that Oracle 10 is not certified on Solaris 11. To keep things simple, we built two small databases in the ZFS root pool. The complete system now resides on one disk no UFS LUNs to consider, no Fibre Optic fabric, no CISCO switches, no IBM data array, BUT we get the same problem. The system will run for some time and then slow down drastically. Starting the second database slows the system down abnormally.

View 1 Replies View Related

Performance Tuning :: Oracle 10.2.0.3 On Solaris 5.9 OS?

Aug 28, 2012

I am running an Oracle 10.2.0.3 on Solaris 5.9 OS. Front end appplication is PeopleSoft v8.8.From my AWR report I have found below SQL which needs to be tuned:

SELECT TO_CHAR (TO_DATE (TO_CHAR (B.ASOFDATE, 'YYYY-MM-DD'), 'yyyy-mm-dd'),
'dd/mm/yyyy'),
B.EMPLID,
B.PWCUK_LEGACY_ID,
B.NAME,

[code]...

View 6 Replies View Related

Server Administration :: Migration Of Oracle From AIX To Solaris

Jan 4, 2013

We have to migrate our database from current OS (AIX 5.3) to Solaris 10. We'll do it through expdp / impdp. Is there any other way to do it as well?

Also, we have dataguard configured at current setup. So is there any way we can take backup of existing database at DR & restore it at new server (Solaris) or we'll have to take a fresh backup from DC (after migration) & ship it to DR & create a new standby?

View 8 Replies View Related

SQL & PL/SQL :: Oracle 10.2.0.4 On Solaris 10 - Recursive Query Using Hierarchy

Nov 9, 2011

We are on oracle 10.2.0.4 on solaris 10. My question is on a sql query. Is it possible to rewrite a query to avoid the connect by and prior constructs and use joins? For example i have the following query:

SELECT empno,
ename,
job,
mgr,
hiredate
FROM emp
START WITH empno in (7566,7698)
CONNECT BY PRIOR empno = mgr

How can it be rewritten using a two table join (self join)? I am not sure if it can be done and whether it is possible.

View 4 Replies View Related

Reported When Migrating Oracle 11g From Solaris To Linux?

Oct 25, 2013

What are reported issues when migratin Oracle 11g from Solairs to Linux? 

View 1 Replies View Related

RAC/ASM Clusterware Installation :: Adding New Oracle 11g R2 Rac Node On Solaris 10

Feb 18, 2013

While adding new oracle 11g R2 rac node on solaris 10, getting below error.

Checking user equivalence...
PRVF-4007 : User equivalence check failed for user "grid"
Check failed on nodes:
sr3
[code]...

View 4 Replies View Related

Server Utilities :: Error During Expdp On Oracle 11gR2 On Solaris?

Dec 2, 2010

From some day I have this error during export data pump:

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-31626: job does not exist
ORA-31687: error creating worker process with worker id 1
ORA-31687: error creating worker process with worker id 1
ORA-31688: Worker process failed during startup.

This error is random, if I retry after few minutes the expdp work correctly.

View 8 Replies View Related

Oracle Solaris 11 Database Control Failed To Start Set ORACLE_UNQNAME

Apr 20, 2013

Oracle Solaris 11
Oracle Database 11.2.0.3

Create a new database using dbca and at the end dbca reports it could not start database control.

The dbca warning window asks to set ORACLE_UNQNAME and to start database control again.

su - oracle
$ . oraenv
rcat
export ORACLE_UNQNAME=rcat
emctl stop dbconsole
emctl start dbconsole
failed...

I tried that and dbconsole still cannot start.

View 3 Replies View Related

Server Administration :: Creating / Running Jobs In Oracle 9i For Solaris

Sep 5, 2005

How to

1) to define a job in oracle9i for solaris
2) to schedule this job

Remember i have prior experience deploying jobs at windows platform but when i try it on (9i for ) solaris, the script does not work as it does not accept a submit job request.

View 4 Replies View Related

Security :: Active Directory Authentication For Oracle 10g Database Running On Solaris?

Jul 25, 2011

I have oracle 10g up and running on Solaris 10, from windows I would like to connect to sql plus through windows authentication, for that I have already made sure that remote_auth = true and have created user in oracle with OPS$. But still I cannot connect.

I have the same setup but with oracle on windows server, the os authentication from windows clients works just fine.

does oracle 10g on solaris 10 supports windows os authentication?

View 4 Replies View Related

Installation :: Install Latest Release Of Oracle Database On A Solaris 11 Zone

May 11, 2013

which is really a HA zone clustered in VCS(not important for installation of the database).

What parameters do I need to set or change in the Solaris zone, there seems to be no /etc/system file.

View 3 Replies View Related

Export/Import/SQL Loader :: Selective Export Failing - Solaris Sparc - Oracle 10g

May 11, 2013

I am trying to export selective data from one of my prod database tables. But not succeeding. I was keep on trying for the past 2 hours.

OS : SOLARIS SPARC
ORACLE - 10G
Query --> WHERE E3RECV_DT LIKE '201305%' (I need to export this query data)

Below Script i am using
===============
exp E3USER@SGEBAPU2 statistics=none consistent=n buffer=100000000 file=exp_pipe_file TABLES=IFDATA query="WHERE E3RECV_DT LIKE '201305\%'" log=PGTB_IFDATA_conditional.log

View 1 Replies View Related

Linux X86 To Solaris SPARC

Sep 16, 2011

After querying the view v$db_transportable_platform, I can not see any information about Solaris SPARC, but only about Solaris x86. Can I migrate database to Solaris SPARC? What can I do to performing RMAN CONVERT?

View 1 Replies View Related

Secure Backup :: OSB On Solaris 11.1

Dec 20, 2012

Two questions.

1. Both Oracle Secure Backup and Oracle Secure Backup Express for x86 Solaris download the same file.
Is there no difference on Solaris?

2. Have installed and configured sgen driver and tapes can be labelled OK and the first backup works

BUT appending the next backup to the tape I get the following.

Space to EOD.
BSR
Device says it is offline

Transcript below
8231: 2012/12/21.10:16:28 (pvfw) previous state is invalid
8232: 2012/12/21.10:16:28 (alv) backup image label is valid, file 1, section 1
8233: 2012/12/21.10:16:28 (pvfw) invalidating tape position in mount db
8234: 2012/12/21.10:16:28 (ial) invalidate backup image label (was valid)
8235: 2012/12/21.10:16:28 ***0 wst__exec: op=16 (eod), buf=0x0, count=1 (0x1), parm=0x0
[code]........

View 3 Replies View Related

Two-node RAC Database Running On Solaris 5.8

Jun 1, 2013

We have an Oracle 9i (9.2.0.7) two-node RAC database running on Solaris 5.8. Recently we have switched our production database from no archive log mode to archive log. We changed the parameter CLUSTER_DATABASE=FALSE on one of the instances before converting and reverted back.why this parameter needs to be changed to false?

View 2 Replies View Related

How To Determine Number Of TPS Supported On Solaris

Mar 24, 2013

How to calculate the number of TPS supported by any solaris server for example one server with below configuration .

Sun Blade X6270 with two 4-core processors
2 x 300 GB internal disk drives

View 1 Replies View Related

Migrate Database From Linux To Solaris?

Sep 12, 2011

We are planning to migate Oracle database from Linux 10gR2 (non-ASM) to Solaris (ASM) and then Oracle upgrade that database from 10gR2 to 11gR2 on Solaris.

View 4 Replies View Related

Exception Error ORA - 7445 On Solaris X64

Jul 22, 2010

I am getting following error in my alert log file of my database

ORA-07445: exception encountered [kduget () +1032][sigbus]

as i can perform some of my database activity but from some of the users i cannot login.

i tried to search out and found that some Memory needs to be flushed out so restarting of database is only action to be taken?

View 6 Replies View Related

Server Administration :: Upgrade 10.2.0.4 To 11.2.0.2 On Solaris?

Aug 28, 2011

I tried to upgrade oracle 10.2.0.4 to 11.2.0.2 on the Solaris 10 server, but after 40 minutes it hangs bei oracle XML Database.

View 5 Replies View Related

Forms :: Webutil Not Working In Solaris

May 9, 2011

i have insert image using webutil (oracle forms 10g) to database in windows o.s. it was successful. but when i have tried it in solaris o.s. . It is not working in linux how to do it in solaris o.s. when i am clicking on the browse button it is showing pl/sql error how to solve it.

View 3 Replies View Related

RAC/ASM Clusterware Installation :: Can Use 64 Bit OS (Solaris X86) In PC With VMware

Mar 22, 2013

Can I use 64 bit OS (Solaris x86) in my PC with VMware. As many software available in 64 bit but not in 32bit.

If I install 64 bit OS , Oracle DB whether it can crash the system or not

View 4 Replies View Related

Cross Platform Restore - Solaris - Linux?

Aug 4, 2011

In my present env, Oracle runs in Solaris 10 and I am planning to restore it to Linux5. I have read thro oracle docs, metalink that cross platform restore with different endian can be done by TTS. But it says that tablespace shud be in read-only until we plug in it in the dest server.

Also My db size will be 800-1000GB

View 3 Replies View Related

RAC & Failsafe :: 11G Release 2 Grid And RAC Installation On Solaris 10

Nov 24, 2010

Share 11g Release 2 Grid infrastructure and RAC installation experience on Sun SPARC. Any documentation which provide complete information from server setup to database setup.

View 2 Replies View Related

Server Administration :: Move Database From 10.2.0.4 (Solaris 9) To 11.2.0.2

Sep 17, 2011

I have to move a database from 10.2.0.4(solaris 9) to a 11.2.0.2(Solaris 10) . 11g shell database is ready .Its a 400GB database.

View 7 Replies View Related

Precompilers, OCI & OCCI :: PCC-S-02014 Error While Compiling Within Sun Solaris?

Dec 18, 2008

We are porting our application from HP-UX to Sun Solaris and as part of that I am trying the compile a Pro*C program in Sun Solaris using SUNWspro C++ compiler. Precompiling is failing with following error.

PRECOMP set: /u01/app/oracle/product/10.2.0/bin/proc dbms=native code=cpp mode=ansi include=/u01/app/oracle/product/10.2.0/precomp
ireclen=255 oreclen=255
define=__sparc define=__SUNPRO_C include=/usr/include include=.

[code]...

System default option values taken from: /u01/app/oracle/product/10.2.0/precomp/admin/pcscfg.cfg

Syntax error at line 44, column 30, file /u01/app/SUNWspro/prod/include/CC/stlport4/algorithm:
Error at line 44, column 30 in file /u01/app/SUNWspro/prod/include/CC/stlport4/a
lgorithm
# include _STLP_NATIVE_HEADER(algorithm)
.............................1
PCC-S-02014, Encountered the symbol "(" when expecting one of the following:

[code]...

Normal C++ files are getting compiled with out eny issues. This particular file is having functions written in C fashion.

View 1 Replies View Related

Server Administration :: Changing Time Zone On Solaris?

Jun 19, 2012

our system admin is changing the time zone on solaris system, how can it effect my DB or as DBA what should i check before he do that and after he change the time zone. he is changing the time zone because of an issue with the DST (Daylightsaving time).

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved