|
|
|
|
|
|
|
|
Re: how can i login as sysdba @ isqlplus [message #355146 is a reply to message #324151] |
Wed, 22 October 2008 21:09 |
kacraj
Messages: 1 Registered: October 2008
|
Junior Member |
|
|
iSQL*Plus login as Sysdba - Solved
When u wants to connect sys as sysdba in isqlplus then u have to type
http://localhost:port/isqlplusdba <- Only for sysdba
http://localhost:port/isqlplus <- Other user like scott,hr etc.
When connect with "isqlplusdba", a promt will be show to ask u to type
username and password. This information is generally kept in
"$ORACLE_HOME/sqlplus/admin" location named "iplusdba.pw".
This file is maintained by "htpasswd.exe" located in
"$ORACLE_HOME/Apache/Apache/bin" location. So at first u have to create
"iplusdba.pw" file same as u create oracle password by "orapwd". So do
this step :
1. Go to the location "$ORACLE_HOME/Apache/Apache/bin" from your
command promt.
2. Type "htpasswd -c iplusdba.pw oracle". In this example iplusdba.pw
is the name of the password file and oracle is the name of the user
allowed to use the DBA utility. htpasswd prompts you to enter the
password and confirm. You can see help by typing "htpasswd /?".
3. Now "iplusdba.pw" file will be created. Copy the file and overwrite
the file in the location ""$ORACLE_HOME/sqlplus/admin".
4. Now just type "http://localhost:port/isqlplusdba" and when u asked
for username and password then those username and password that u used
to create the iplusdba.pw file.
|
|
|
|
|