Tuesday, 13 September 2011

Starting a oracle database

First step is to set the environmental variable.In my case it is devel.env

Login to sqlplus--->sqlplus /nolog
sql>conn /as sysdba
sql>startup;
sql>quit
#ps -ef | grep tns

To Start the Listener

#lsnrctl start LISTENERNAME

To check if the listener is running

#ps -ef | grep tns

No comments:

Post a Comment