Seach Makes Easy

Labels:

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

Comments (0)

Followers

Blog Archive