How to Start the Service Manager
I am new to oracle. I want to know how to start
the service manager and where should I give the command. What is the password
for newlly installed oracle. Please help me out.
If you want to run SVRMGRL on UNIX then just log on to the UNIX with
your user name and password.
1. Type SVRMGRL
2. Type connect internal
The message will say connected. Now you are connected to Oracle. If
you are new to Oracle then make sure of you your commands, SVMGRL has a
lot of power.
Now if you are connecting to an NT machine, then you need to start
the command prompt.
1. Type SVRMGRL
2. It will ask you for a password, this is the same password that you
created when you did the fresh install of oracle. Once you issue a password
you should be in.
Thanks for the reply but I am working on Windows NT not Unix so let
me know how to start svrmgr in it. Your help will be appreciated.
For NT do the following....assuming u have Oracle installed on c:drive
if u have oracle on d: e: or anyother drive just replace the c:> with ur
drive.
c:> set ORACLE_SID=ORCL ( whatever db name u have)
c:> svrmgrl
svrmgrl > connect internal
svrmgrl > select * from v$database; -- if Oracle not available ...do
this
svrmgrl > startup
svrmgrl > select * from v$database;
You need to start the Listener too...for sqlplus conectivity..
c:> lsnrctl
lsnrctl > status -- if shows errors then you need to start the listener
lsnrctl > start
If you happen to have a named listener then u need to specify the name....
lsnrctl > start ORCL (whatever listener name you have ..check listener.ora
file for that)
You should be all set
But remember man, server manager "svrmgrl" is unsupported 9i onwards.
You have to use only sqlplus to get connected.
The person who posted this query didn't mention the version
I am new to oracle. I try to connect the oracle sever 8i (8.1.7)
from windows 2000, I got error message no listner, then I try to start
listner: start orcl and got another error message:
TNS-01151: Missing listerner name, oracle, in LISTENER.ORA
This is my listerner.ora
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = test)(PORT = 1521))
)
)
(DESCRIPTION =
(PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
)
(ADDRESS = (PROTOCOL = TCP)(HOST = test)(PORT = 2481))
)
)
What I need to do ? Please help.
According to your listener.ora file you don't have a named listener
so while starting the listener you must do the following
lsnrctl start -- Correct
lsnrctl start orcl -- Incorrect
NOTE : Only for named listener you need to start like ... lsnrctl start
orcl
Have a Oracle Question
Do
you have an Oracle Question?
Oracle Books
Oracle
Certification, Database Administration, SQL, Application, Programming Reference
Books
Oracle Application
Oracle
Application Hints and Tips
Oracle Home
Oracle
Database, SQL, Application, Programming Tips
All the site contents are Copyright © www.erpgreat.com
and the content authors. All rights reserved.
All product names are trademarks of their respective
companies.
The site www.erpgreat.com is not affiliated with or endorsed
by any company listed at this site.
Every effort is made to ensure the content integrity.
Information used on this site is at your own risk.
The content on this site may not be reproduced
or redistributed without the express written permission of
www.erpgreat.com or the content authors.
|