Links
• Home
• Oracle DBA Forum
Frequent Oracle Errors
•TNS:could not resolve the connect identifier specified
•Backtrace message unwound by exceptions
•invalid identifier
•PL/SQL compilation error
•internal error
•missing expression
•table or view does not exist
•end-of-file on communication channel
•TNS:listener unknown in connect descriptor
•insufficient privileges
•PL/SQL: numeric or value error string
•TNS:protocol adapter error
•ORACLE not available
•target host or object does not exist
•invalid number
•unable to allocate string bytes of shared memory
•resource busy and acquire with NOWAIT specified
•error occurred at recursive SQL level string
•ORACLE initialization or shutdown in progress
•archiver error. Connect internal only, until freed
•snapshot too old
•unable to extend temp segment by string in tablespace
•Credential retrieval failed
•missing or invalid option
•invalid username/password; logon denied
•unable to create INITIAL extent for segment
•out of process memory when trying to allocate string bytes
•shared memory realm does not exist
•cannot insert NULL
•TNS:unable to connect to destination
•remote database not found'>ora-02019
•exception encountered: core dump
•inconsistent datatypes
•no data found
•TNS:operation timed out
•PL/SQL: could not find program
•existing state of packages has been discarded
•maximum number of processes exceeded
•error signaled in parallel query server
•ORACLE instance terminated. Disconnection forced
•TNS:packet writer failure
•see ORA-12699
•missing right parenthesis
•name is already used by an existing object
•cannot identify/lock data file
•invalid file operation
•quoted string not properly terminated
RE: questions for the document "Oracle 9i R2 (9 .2.0.6) SUSE L

RE: questions for the document "Oracle 9i R2 (9 .2.0.6) SUSE L

2005-08-10       - By michael.d.taylor@(protected)


Johnny,

1) Skip all of step 7 since that refers to 32 bit Oracle on 64 bit Linux

2a) Use p3423540_9204_LINUX64.zip for AMD64/EMT64 - fixes __libc_wait errors

2b) Asynch i/o is not required, from my testing, it only appears to reduce
CPU utilization at the expense of runtime...

3) You need the OS provided gcc 3.3.3 in order to compile 64 bit Oracle.
gcc 9.2.5 is only required for 32 bit Oracle

4) Set kernel parameters via orarun, then increase shmall to shmmax

Cannot startup instance get ORA-27102 (See ORA-27102.ora-code.com): out of memory Linux-X86_64 Error: 28
No space left on device
http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_datab
ase_id=NOT&p_id=301830.1

You will not want to increase the SGA to the point where your cause
excessive paging, which will depend on the number and type of client
connections.

Start with SLES9 plus SP1 or SP2.  The base SLES9 will likely have VM and
performance issues with Oracle.  My systems generally have a mixture of 32
bit and 64 bit Oracle code, so I set the following environment variables to
avoid linking problems on 64 bit SUSE:

export LD_ASSUME_KERNEL=2.4.19
export LD_PRELOAD_32=/usr/lib/libInternalSymbols.so
export LDEMULATION=elf_i386

Regards,
-Michael Taylor

-- --Original Message-- --
From: Zhang, Johnny Y. [mailto:JZhang@(protected)]
Sent: Wednesday, August 10, 2005 4:45 PM
To: suse-oracle@(protected)
Subject: [suse-oracle] RE: questions for the document "Oracle 9i R2
(9.2.0.6) SUSE LINUX Enterprise Server 9 (How to Install)" by Arun Singh



Hi,

I am going to install Oracle 9i R2 (9.2.0.6) for Linux x86-64 (start
from 9.2.0.4 using 3 CDs B14882-01, B14883-01, B14884-01) to SUSE LINUX
Enterprise Server 9 on Dell PowerEdge 2850 64-bit (4 processors).

Question 1:

   I do not understand the meaning of the whole step 7 under
Installation Steps that reads "7 EM64T(32 bit mode:) Installing Oracle
9iR2 (x86)  on SLES9 (x86)." Does it mean the whole instruction for
installing 32-bit oracle on SLES9 (32-bit)? I was attempting to
interpret x86 alone refers to 32-bit, and x86-64 refers to 64bit. If
this understanding is correct, I can totally ignore the whole step 7.

Question 2:

  --A. In the step 6 under Installation Steps, it is mentioned to apply
patch 3238244. I did not see that patch in Oracle for LINUX.
  --B. Is 'enable async io' required for 9.2.0.6?


Question 3:

   If I start with 9.2.0.4, if the gcc 3.3.3 is the right version? Do I
need to get gcc_old (2.95)?

Question 4:

   We have 8GB physical memory on the server. Is it allowed for us to
allocate more than 4GB (say, 6GB) used for oracle database (SGA+PGA)
with the default SLES9 installation?

ipcs -lm returns

-- --- Shared Memory Limits -- -----
max number of segments = 4096
max seg size (kbytes) = 32768
max total shared memory (kbytes) = 8388608
min seg size (bytes) = 1

Is there any docs for recommendation of setting SHMMAX, Semaphores?

Regards

Johnny

--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting