- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Problem with database( Oracle 9i ) starting
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-01-2005 04:13 PM
тАО09-01-2005 04:13 PM
Problem with database( Oracle 9i ) starting
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..
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-01-2005 04:20 PM
тАО09-01-2005 04:20 PM
Re: Problem with database( Oracle 9i ) starting
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-01-2005 04:26 PM
тАО09-01-2005 04:26 PM
Re: Problem with database( Oracle 9i ) starting
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-01-2005 04:49 PM
тАО09-01-2005 04:49 PM
Re: Problem with database( Oracle 9i ) starting
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-01-2005 05:41 PM
тАО09-01-2005 05:41 PM
Re: Problem with database( Oracle 9i ) starting
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
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-01-2005 06:29 PM
тАО09-01-2005 06:29 PM
Re: Problem with database( Oracle 9i ) starting
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-01-2005 06:35 PM
тАО09-01-2005 06:35 PM
Re: Problem with database( Oracle 9i ) starting
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-01-2005 06:41 PM
тАО09-01-2005 06:41 PM
Re: Problem with database( Oracle 9i ) starting
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-01-2005 06:41 PM
тАО09-01-2005 06:41 PM
Re: Problem with database( Oracle 9i ) starting
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-01-2005 07:06 PM
тАО09-01-2005 07:06 PM
Re: Problem with database( Oracle 9i ) starting
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