topic Re: Problem with database( Oracle 9i ) starting in Operating System - HP-UX

Problem with database( Oracle 9i ) starting

Pankaj_18 — Thu, 01 Sep 2005 23:13:26 GMT

Hi

I have recently installed Oracle 9.2.0.0.0 on Solaris 9 Operating System. I am facing some problems with my database startup.

I am able to start the listener

bash-2.05$ lsnrctl start

LSNRCTL for Solaris: Version 9.2.0.1.0 - Production on 01-SEP-2005 20:07:34

Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.

Starting /u01/OracleData//bin/tnslsnr: please wait...

TNSLSNR for Solaris: Version 9.2.0.1.0 - Production
System parameter file is /u01/OracleData/network/admin/listener.ora
Log messages written to /u01/OracleData/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=lancia)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Solaris: Version 9.2.0.1.0 - Production
Start Date 01-SEP-2005 20:07:34
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File /u01/OracleData/network/admin/listener.ora
Listener Log File /u01/OracleData/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=lancia)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

TNS Ping does not work..

bash-2.05$ tnsping PLSExtProc

TNS Ping Utility for Solaris: Version 9.2.0.1.0 - Production on 01-SEP-2005 20:12:50

Copyright (c) 1997 Oracle Corporation. All rights reserved.

Used parameter files:
/u01/OracleData/network/admin/sqlnet.ora

TNS-03505: Failed to resolve name

----
This is what happens when i try to start the database

bash-2.05$ cd ../bin/
bash-2.05$ ./sqlplus /nolog

SQL*Plus: Release 9.2.0.1.0 - Production on Thu Sep 1 20:13:27 2005

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

SQL> connect / as sysdba
Connected to an idle instance.
SQL> startup
ORA-27302: failure occurred at: skgpwreset1
ORA-27303: additional information: invalid shared ctx
ORA-27146: post/wait initialization failed
ORA-27300: OS system dependent operation:semget failed with status: 28
ORA-27301: OS failure message: No space left on device
ORA-27302: failure occurred at: sskgpcreates
SQL>

Have set the following environment variable..
ORACLE_HOME=/u01/OracleData/

can anyone please help..

Re: Problem with database( Oracle 9i ) starting

Yogeeraj_1 — Thu, 01 Sep 2005 23:20:40 GMT

hi pankaj!

seem like your kernel parameters are have not been properly tuned!

can you download the Installprep.sh utility from metalink and verify your environment?

btw. this an HP forum so not too sure we can help you much on the Solaris platform.

kind regards
yogeeraj

Re: Problem with database( Oracle 9i ) starting

Pankaj_18 — Thu, 01 Sep 2005 23:26:54 GMT

Hi yogeeraj,,

Thanks for that quick reply. I am new to this forum and infact this is my first request to forum. Would appreciate if you could send me the link from where i can download the Installprep.sh utility

regards
pankaj

Re: Problem with database( Oracle 9i ) starting

Pankaj_18 — Thu, 01 Sep 2005 23:49:08 GMT

Hi yogeeraj

now i am at this stage after correcting my kernel parameters

SQL> startup
ORACLE instance started.

Total System Global Area 43164544 bytes
Fixed Size 729984 bytes
Variable Size 41943040 bytes
Database Buffers 204800 bytes
Redo Buffers 286720 bytes
ORA-00205: error in identifying controlfile, check alert log for more info

SQL> connect scott/tiger
ERROR:
ORA-01033: ORACLE initialization or shutdown in progress

Warning: You are no longer connected to ORACLE.
SQL>
ORA-00205: error in identifying controlfile, check alert log for more info

Re: Problem with database( Oracle 9i ) starting

Indira Aramandla — Fri, 02 Sep 2005 00:41:37 GMT

Hi Pankaj,

ORA-00205: "error in identifying controlfile", means that the controlfiles specified in the init.ora file of the databse that you were starting up cannot be located in the directory.

Check if you have all the control files listed in your init.ora file or config.ora file in the corressponding location.

And also check that you had set your ORACLE_SID to the one that you are startingup. You can specify the pfile path and name in the start commnad.

SQL>startup pfile = /path/init.ora

May be it is looking in the wrong pfile or the link in the $$ORACLE_HOME/dbs directory pointing to the init.ora file is not defined.

What are the other associated error messages in the alert log.

Re: Problem with database( Oracle 9i ) starting

Yogeeraj_1 — Fri, 02 Sep 2005 01:29:34 GMT

hi pankaj,

if you have oracle support, you can access the Metalink site (http://metalink.oracle.com) and download this utility which will examine your system and recommend you the kernel settings to be used as well as patches required.

For the error that you are getting now, please follow the guidance provided by Indira above.

if you still need additional help do let us know.

kind regards
yogeeraj

Re: Problem with database( Oracle 9i ) starting

Yogeeraj_1 — Fri, 02 Sep 2005 01:35:03 GMT

hi again,

attaching the desired script which will do the following verifications:-

- ORACLE_HOME Directory Verification
- UNIX User/umask Verification
- UNIX Group Verification
- Memory/Swap Verification
- TMP Space Verification
- Real Application Cluster Option Verification
- Unix Kernel Verification

hope this helps!
regards
yogeeraj

Re: Problem with database( Oracle 9i ) starting

Yogeeraj_1 — Fri, 02 Sep 2005 01:41:08 GMT

hi,

sorry forgot the attachment.

below a quote on how to install:

Follow these steps to download and run the script:
1. Change the name of the script to InstallPrep.sh
2. Ftp the InstallPrep.sh script (in ascii format) to the Unix system that you will be installing the Oracle DataServer on.
3. Change the permissions of the script to execute for the user running the script:
chmod 777 InstallPrep.sh
4. Log in as the user that will be installing the Oracle software.
5. Copy the InstallPrep.sh script to the /tmp directory and run it from this location.
6. Note: on some Linux platforms you may get the error "bad interpreter", just run the command 'sh InstallPrep.sh' and the try running it. Otherwise, you can try "dos2unix InstallPrep.sh" and then retry it.
7. Note: on Linux if you get messages like:
'tmp/InstallPrep.sh: line 138: syntax error near unexpected token `in
'tmp/InstallPrep.sh: line 138: `case $OS in
do "dos2unix InstallPrep.sh"
8. Answer the first few questions, the output from the script will be written to /tmp/InstallPrep.out and the errors written to /tmp/InstallPrep.err.
9. Resolve any problems found in /tmp/InstallPrep.err and then install the Oracle DataServer software.

hope this helps!

regards
yogeeraj

Re: Problem with database( Oracle 9i ) starting

Pankaj_18 — Fri, 02 Sep 2005 01:41:24 GMT

where is the attachment

Re: Problem with database( Oracle 9i ) starting

Yogeeraj_1 — Fri, 02 Sep 2005 02:06:10 GMT

hi,

see to the top right corner of my last post. The paper clip icon is the attachment.

all you have to do is click on it

hope this helps!

regards
yogeeraj

Re: Problem with database( Oracle 9i ) starting

ivo mencke_1 — Thu, 08 Sep 2005 07:59:07 GMT

Hi,

this means you have hit the hard limit for the max semaphores in your system. its a misleading message. push up the kernel parameter in /etc/system with something like this (cant really remember the exact format)

set semsys:semmax=

and reboot

where xxx is the recommended value in the oracle 9i docs

ivo