Home » RDBMS Server » Server Administration » Very Very Urgent Help
Very Very Urgent Help [message #63092] Thu, 09 September 2004 03:42 Go to next message
Gunasekaran D
Messages: 11
Registered: August 2004
Junior Member
Hi All,

I have oracle server version 8.1.7 along with the client part. I uninstalled the client and installed it again. After this i tried to startup the server in the command prompt using.

c: sqlplus internal@sid

But the system throws "ORA-24314 Service Handle Not Initialized" error.

Whats the solution for this? pls help me

Regards,

Gunasekaran

 

Report message to a moderator

Re: Very Very Urgent Help [message #63095 is a reply to message #63092] Thu, 09 September 2004 04:46 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
use svrmgrl NOT sqlplus.
login as sys to do this.
In most cases, You can just make the oracle service autostarted after reboot.
please have a look here..

http://orafaq.com/faqwinnt.htm

Report message to a moderator

Re: Very Very Urgent Help [message #63097 is a reply to message #63095] Thu, 09 September 2004 05:39 Go to previous messageGo to next message
Gunasekaran Duraivelu
Messages: 1
Registered: September 2004
Junior Member
Hi,
Now it says "ORA-12500 Listener Failed to start the dedicated Server process".
This is very urgent..what to do?

Regards,
Guna

Report message to a moderator

Re: Very Very Urgent Help [message #63099 is a reply to message #63097] Thu, 09 September 2004 06:16 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
First make sure the OS user logged in has the right permissions
and
check you listener.ora ( check the ORACLE_HOME value etc).

Report message to a moderator

Re: Very Very Urgent Help [message #63100 is a reply to message #63099] Thu, 09 September 2004 07:12 Go to previous messageGo to next message
Gunasekaran D
Messages: 11
Registered: August 2004
Junior Member
Hi,
I checked listener.ora file, everything is fine, but it still gives "Listener failed to start a dedicated server process".

Whats the dedicated server process and what might be the reason for the error.

Contents of listener.ora:

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = chnshl34492)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:ORANT)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = frate)
(ORACLE_HOME = D:ORANT)
(SID_NAME = frate)
)
)

Server machine: chnshl34492
SID: frate
ORACLE_HOME = D:ORANT

Is content is ok?

Report message to a moderator

Re: Very Very Urgent Help [message #63101 is a reply to message #63100] Thu, 09 September 2004 08:15 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Make sure u login as the administrative user with full rights.
goto controlpanel/services and make sure u have started listener service with the right SID.
try again.
else try again using LSNRCTL.
if there is any additional messages please post them.

Report message to a moderator

Re: Very Very Urgent Help [message #63104 is a reply to message #63101] Thu, 09 September 2004 11:40 Go to previous messageGo to next message
croK
Messages: 170
Registered: April 2002
Senior Member
Try stop listener service from control panel, and then try re-starting.
You can also do
net stop oracleService<you-servie-name-here>
and
net start oracleService<you-servie-name-here>
if error persists, try to locate listener.log file to find out if some trace can help.

You can also try:
set oracle_sid=your-SID
sqlplus sys/pass as sysdba

Best luck.

Report message to a moderator

Re: Very Very Urgent Help [message #63109 is a reply to message #63104] Thu, 09 September 2004 20:40 Go to previous messageGo to next message
Gunasekaran D
Messages: 11
Registered: August 2004
Junior Member
Hi,
when i tried to start the listener via services. System is giving following error.
"Could not start the OracleTNSListener80frate service on the local computer. The service did not return an error. This could be an internal windows error or an internal service error, If the problem persists contact the system administrator"
I had logged into the system with admin privilages.

Whats the cause for this error.

Report message to a moderator

Re: Very Very Urgent Help [message #63133 is a reply to message #63109] Mon, 13 September 2004 09:44 Go to previous message
croK
Messages: 170
Registered: April 2002
Senior Member
perform the start via LSNRCTL start command so we can see errors.

lsnrctl start

or lsnrctl start service-name

Report message to a moderator

Previous Topic: ORA-00942: table or view does not exist
Next Topic: How deinstall Ultrasearch, JVM, OLAP from database
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jan 24 03:44:10 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.