.ora-code.com

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
SLES 9 Oracle 10g Instance Crash opteron

SLES 9 Oracle 10g Instance Crash opteron

2005-07-11       - By Seah Hong Yee
Reply:     1     2     3     4     5     6     7     8     9  

Hi,

I am currently testing Oracle 10g on two machine, the 32 bit machine runs on

SLES9
1 gig RAM
2 X Pentium III 866Mhz
ext3 on scsi

The above machine runs without problems for one month.

Last weekend I set up another machine with the same application  but this time
is the 64bit version of Oracle 10g.


The specification is like this

SLES9
2 gig RAM
2 X Opteron 244
ADAPTEC ZCR  2015 (I2O) RAID, I configure as raid 10.
ext 3

I am also using ORARUN on both machine, both of them is the script as of June
9 2005 downloaded from suse's site.

The installation method was the documentation provided by SUse on oracle 10g
and SLES 9 installation. The only modification I did to the orarun script was
to comment out dbsnmp portion which does not apply to 10g.

The problem is my oracle instance tend to crash ( become unavailable) at least
once a day. And I have notice once it was during starting up of  emctl start
dbconsole.  The machine itself was quite stable with no crashes on Jboss.
When access http://192.168.1.102:5500/em/ I get a message database
unavailable.  Individual client was not able to connect to the database, I
have to either  do "rcoracle restart" or manually run "dbstart " to restart
the database. However, I was not able to do "emctl stop dbconsole."    

Thanks.

Regards,

Hong Yee

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