On the move:

I'm currently moving the following to their own blogs: Unix, HTML for Blogs, Perl & Java.
The links are on the left side.

Tuesday, October 7, 2008

How to Start and Stop Oracle Services on the PC


Select 'Start' in Windows
Choose
  • Control Panel
  • Administrative Tools
  • Services
Find the name of the Oracle services and create two batch files.

StartAll.Bat
net start OracleDBConsoleorcl10
net start OracleOraDb10g_home1TNSListener
net start OracleServiceORCL10

StopAll.Bat
net stop OracleDBConsoleorcl10
net stop OracleOraDb10g_home1TNSListener
net stop OracleServiceORCL10

OracleServiceSID = (the Oracle Database instance)
OracleORACLE_HOMETNSListener = (the listener)
OracleDBConsoleSID = (Enterprise Manager)

SID : the system identifier for the instance : orcl10
ORACLE_HOME: the Oracle home. : OraDb10g_home1

No comments:

Post a Comment