Hi,
can any1 plss tell me how do i start the oracle service from the Unix prompt?
I been working on NT for a loooong time....
and In NT..its a s simple as going to thr contol panel/servives and stating the service.......
thanx for the help
Printable View
Hi,
can any1 plss tell me how do i start the oracle service from the Unix prompt?
I been working on NT for a loooong time....
and In NT..its a s simple as going to thr contol panel/servives and stating the service.......
thanx for the help
there are no services with Unix, now you're going to work on a really efficient OS :)
you need to use server manager.
first check your env variables ORACLE_HOME and ORACLE_SID, as well as your PATH, then :
$> svrmgrl
svrmgrl> startup
ya that starts the database.....
But now that I have my service itself stopped.......
can i start it any how from here?
Hi,
Ensure the environment variable ORACLE_SID is set to the correct database name then run server manager and startup the instance....
UNIX> export ORACLE_SID=mydatabase
UNIX> svrmgrl
SVRMGRL> connect internal
SVRMGRL> startup
The Oracle listener command is 'lsnrctl start'
Cheers
Moff
SVRMGR> startup
LCC-00161: Message 161 not found; product=RDBMS; facility=MGR
ORA-12560: TNS:protocol adapter error
SVRMGR>
SVRMGR> connect internal@local
Password:
Password:
ORA-12500: TNS:listener failed to start a dedicated server process
SVRMGR>
why does it ask a password for the internal?
Thanx
check the parameter :
remote_login_passwordfile
if it is defined in your init.ora, it should be = none, else define it like that, and you'll no longer have to enter a password as long as you're connected using a login that belongs to the dba group
No it stil asks for the password......
what is the login you are connected with ???
what are the groups this login belongs to ???
Actually the porblem is this....
If i start the oracle service from control panel/services (in NT)
then
$svrmgrl enter
svrmgr>connect intrnal@local enter
connected
svrmgr>shut down immediate
blah
blah
shutdown
svrmgr>
hen i go to the control panel/services stop the oracle service going on
then i come to unix again
$svrmgrl enter
svrmgr>connect internal@local enter
password:
password:
ORA-12500: TNS:listener failed to start a dedicated server process
SVRMGR>
This is the problem..
i hope u guys can understand what i am trying to say.....
thanx a lot
your problem is well understood. forget about services, under Unix you have your instance running or not, and it's just a group of processes.
now, to help you with your problem : what is the login you are using, what are the groups your login belongs to ???