| Trouble in starding oracleservicedawn [message #199082] |
Fri, 20 October 2006 01:21  |
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  |
 |
Mahesh Rajendran
Messages: 10708
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 |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
