-
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: TNSrotocol 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 ???
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|