Home » Infrastructure » Windows » ORA-12560 : TNS:protocol adapter error (oracle,9i,XP)
ORA-12560 : TNS:protocol adapter error [message #411856] Tue, 07 July 2009 03:07 Go to next message
tushar88
Messages: 13
Registered: July 2009
Junior Member
this error occured when i started sqlplusw .
i think it occured because i closed the oracle.exe .
how can i start it again without restarting my system.

Re: ORA-12560 : TNS:protocol adapter error [message #411857 is a reply to message #411856] Tue, 07 July 2009 03:17 Go to previous messageGo to next message
Michel Cadot
Messages: 59414
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
i think it occured because i closed the oracle.exe .

Yes.

Quote:
how can i start it again without restarting my system

Restart the service.
Restart the database.

Regards
Michel
Re: ORA-12560 : TNS:protocol adapter error [message #411858 is a reply to message #411856] Tue, 07 July 2009 03:24 Go to previous messageGo to next message
tushar88
Messages: 13
Registered: July 2009
Junior Member
how to restart the service & database without restarting the system ??? is there a way ??
Re: ORA-12560 : TNS:protocol adapter error [message #411861 is a reply to message #411858] Tue, 07 July 2009 03:32 Go to previous message
Michel Cadot
Messages: 59414
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ Start -> Setting -> Control Panel -> Service
2/ net start <service name>
3/ oradim
ORADIM: <command> [options].  Refer to manual.
Enter one of the following command:
Create an instance by specifying the following options:
     -NEW -SID sid | -SRVC srvc | -ASMSID sid | -ASMSRVC srvc [-SYSPWD pass]
 [-STARTMODE auto|manual] [-SRVCSTART system|demand] [-PFILE file | -SPFILE]
 [-SHUTMODE normal|immediate|abort] [-TIMEOUT secs] [-RUNAS osusr/ospass]
Edit an instance by specifying the following options:
     -EDIT -SID sid | -ASMSID sid [-SYSPWD pass]
 [-STARTMODE auto|manual] [-SRVCSTART system|demand] [-PFILE file | -SPFILE]
 [-SHUTMODE normal|immediate|abort] [-SHUTTYPE srvc|inst] [-RUNAS osusr/ospass]
Delete instances by specifying the following options:
     -DELETE -SID sid | -ASMSID sid | -SRVC srvc | -ASMSRVC srvc
Startup services and instance by specifying the following options:
     -STARTUP -SID sid | -ASMSID sid [-SYSPWD pass]
 [-STARTTYPE srvc|inst|srvc,inst] [-PFILE filename | -SPFILE]
Shutdown service and instance by specifying the following options:
     -SHUTDOWN -SID sid | -ASMSID sid [-SYSPWD pass]
 [-SHUTTYPE srvc|inst|srvc,inst] [-SHUTMODE normal|immediate|abort]
 Query for help by specifying the following parameters: -? | -h | -help

Regards
Michel
Previous Topic: OS Support on Oracle - Client and Server
Next Topic: Batch file / SQLPLUS automation Error message
Goto Forum:
  


Current Time: Wed Oct 22 07:10:37 CDT 2014

Total time taken to generate the page: 0.05599 seconds