if you have installed oracle 10g(in windows xp) , then you must be facing the horrible slow startup problem of windows.the problem is by default there are n no of services which are started automatically at the time of system startup. so an obvious solution is to make oracle services manual, means whenever we need we can start the services manually. in this short tutorial i will guide through few easy steps to take you out of this mess.
step 1: we have to set oracle services as manual startup type. to do that , open control panel->administrative tools->Services
in the list of services , look up for these oracle services OracleServiceORCL,OracleOraDb10g_home1TNSListener,OracleOraDb10g_home1iSQL*Plus,OracleDBConsoleorcl
now change their startup type to manual, to do that just double click and then select manual from the dropdown box.and don't forget to click apply.
now whenever you need to start using oracle, you need to start relevant oracle services.
the very first oracle service that is required is TNSListener, to start that u dnt nedd to come here in services list.
start command prompt and type lsnrctl start
then you can start other oracle components,
to start a database of sid orcl
type oradim -startup -sid orcl
to start enterprise manager service,the command is
emctl start dbconsole
(this will start enterprise manager for defualt sid, you may have multiple database and hence multiple sid's , so to start enterprise manager for a database of sid orcl2,you need to first set sid environment variable at command prompt the command is set ORACLE_SID=otherdatabasesid)
ask further ....
