Home » RDBMS Server » Server Administration » Oracle Startup Problem(URGENT)
Oracle Startup Problem(URGENT) [message #51571] Fri, 31 May 2002 05:18 Go to next message
Soumen Ghosh
Messages: 9
Registered: May 2002
Junior Member
Hello,

We are using Oracle 8.1.6 on HP-UX 11.0. We faced a problem in connecting to Oracle instance from client and it gave an error message like : 'fatal two-task communnication protocol error'.
We could not shutdown it from server manager utility. It would jusi hang if I tried to shutdown it.
I killed all the processes by using 'kill <pid>' command not using '-9' argument.
Now if I try to start it up, it says Oracle Instance is already running. If I try to shut it down, it says that Oracle not available.
What can be done to start it up?
Please help. It is very urgent.

Soumen Ghosh
Re: Oracle Startup Problem(URGENT) [message #51573 is a reply to message #51571] Fri, 31 May 2002 05:42 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
1.) 	first check the NLS settings

 	select * from nls_database_parameters;
	
	is the result UTF8?
	then
	You are NOT using SQL*Net version 2.3.4 and higher.  SQL*Net version 2.3.4
	and higher is required to be able to connect to a Unicode UTF8 database.

2.)	In extreme circumstances, this could indicate that a shared memory segment 
	used by Oracle is corrupted.  You will have to shut down the database, 
	possibly using the abort option.  Make sure all semaphores have been 
	released by using the IPCS command on Unix.  Oracle uses semaphores to 
	control concurrency between all of the background processes (pmon, smon, 
	drwr, lgwr, and oracle shadow processes).  Semaphores are also used to 
	control Two-Task communication between the user process and the shadow 
	process.
Re: Oracle Startup Problem(URGENT) [message #51578 is a reply to message #51571] Fri, 31 May 2002 08:54 Go to previous message
Grant
Messages: 578
Registered: January 2002
Senior Member
svrmgrl> shutdown abort
svrmgrl> startup
Previous Topic: query
Next Topic: Re: ORA-06553: PLS-707: unsupported construct or internal error [2603]
Goto Forum:
  


Current Time: Mon Sep 16 18:18:38 CDT 2024