Home » RDBMS Server » Server Administration » Trouble in starding oracleservicedawn
Trouble in starding oracleservicedawn [message #199082] Fri, 20 October 2006 01:21 Go to next message
charankarthikeyan
Messages: 16
Registered: August 2006
Junior Member
hi,

I've a strange problem i've oracle 9i installed a long back in Windows xp everything was working fine for the past 4 days i could not connect db through sqlplus

1.when i connect to scott/tiger it prompts
12560 Tns: protocol adapter error

2. i found the oracle service is not started it is auto when i start oracleservicedawn in the service and throws error: 1067 unable to start the oracleservicedawn the process terminated unexpectedly.

3. as per forum message i' ve again set Oracle_sid=dawn
and connected in sqlplus> conn system/manager@dawn it prompts
12154:TNS:Could not resolved service name given in the connect descriptor.

my listener and tnsname ora files have the servicename correct.
any one suggest can i delete my oracleservicedawn through oradim
and create a new one in order to secure my precious database
pls suggest how to start my oracleservice to connect to my database. seeking assistance

with warm wishes
karthik

Re: Trouble in starding oracleservicedawn [message #199149 is a reply to message #199082] Fri, 20 October 2006 10:09 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Is your database mounted and open?
Try this:
1. set Oracle_sid=dawn
2. sqlplus "sys/syspasswordwhateveritisyougave as sysdba"
or
   if you are logged in as same your you installed oracle
   sqlplus /nolog
   connect /as sysdba
3. Startup


If none of these work, edit your sqlnet.ora , comment all entries
and try again.

[Updated on: Fri, 20 October 2006 10:09]

Report message to a moderator

Re: Trouble in starding oracleservicedawn [message #199194 is a reply to message #199082] Sat, 21 October 2006 00:04 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

12154:TNS:Could not resolved service name given in the connect descriptor

After try "Mahesh" suggestion if problem is persists then check "tnsnames.ora" file "service" clause is some ur oracle_sid if not then correct.

hope this helps.
Previous Topic: dba_free_space
Next Topic: DBMS_METADATA
Goto Forum:
  


Current Time: Fri Dec 02 22:48:32 CST 2016

Total time taken to generate the page: 0.12750 seconds