Home » SQL & PL/SQL » Client Tools » how can i login as sysdba @ isqlplus
how can i login as sysdba @ isqlplus [message #324151] Sat, 31 May 2008 03:34 Go to next message
sumanbangladesh
Messages: 17
Registered: April 2008
Location: Bangladesh
Junior Member

Hi

I setup oracle 10g & using windows xp. I like to login as sysdba in isqlplus. Would you please tell me, how can I do so..

Thanks,
Suman
Re: how can i login as sysdba @ isqlplus [message #324165 is a reply to message #324151] Sat, 31 May 2008 03:58 Go to previous messageGo to next message
Littlefoot
Messages: 20827
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
CONNECT AS SYSDBA or AS SYSOPER not allowed through iSQL*Plus URL. How to enable iSQL*Plus DBA? Check the documentation (see Part I: SQL*Plus Getting Started chapter.
Re: how can i login as sysdba @ isqlplus [message #324179 is a reply to message #324165] Sat, 31 May 2008 04:51 Go to previous messageGo to next message
sumanbangladesh
Messages: 17
Registered: April 2008
Location: Bangladesh
Junior Member

http://www.oracle.com/technology/obe/obe9ir2/obe-mng/isqlplus/isqlplus.htm

here is a way to connect as sysdba in isqlplus but i connot do it in oracle10g
Re: how can i login as sysdba @ isqlplus [message #324181 is a reply to message #324179] Sat, 31 May 2008 05:15 Go to previous messageGo to next message
msmallya
Messages: 66
Registered: March 2008
Location: AHMEDABAD, GUJARAT
Member
Will you post all the steps you carried out with command line
statements issued? (As per @littlefoot given link to follow).

Regards,

MSMallya
Re: how can i login as sysdba @ isqlplus [message #324199 is a reply to message #324181] Sat, 31 May 2008 08:37 Go to previous messageGo to next message
sumanbangladesh
Messages: 17
Registered: April 2008
Location: Bangladesh
Junior Member

hi MSMallya,

I didnt try according to littlefoot. If u use Oracle'9i..then u can try
http://www.oracle.com/technology/obe/obe9ir2/obe-mng/isqlplus/isqlplus.htm


Thanks,
Suman
Re: how can i login as sysdba @ isqlplus [message #324331 is a reply to message #324199] Mon, 02 June 2008 00:57 Go to previous messageGo to next message
msmallya
Messages: 66
Registered: March 2008
Location: AHMEDABAD, GUJARAT
Member
Question is : were you, able to login using iSQLPlus?

I think it does not matter which version you are using.
You can connect to oracle 9i, 10g once iSQLPlus is working.

Regards,

MSMallya
Re: how can i login as sysdba @ isqlplus [message #325200 is a reply to message #324151] Thu, 05 June 2008 05:09 Go to previous messageGo to next message
star_guan2008
Messages: 4
Registered: June 2008
Junior Member
Quote:
sqlplus "/nolog"
conn /as sysdba
Re: how can i login as sysdba @ isqlplus [message #325202 is a reply to message #325200] Thu, 05 June 2008 05:10 Go to previous messageGo to next message
Michel Cadot
Messages: 63808
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
At least READ the topic BEFORE posting.

Regards
Michel
Re: how can i login as sysdba @ isqlplus [message #355146 is a reply to message #324151] Wed, 22 October 2008 21:09 Go to previous messageGo to next message
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.
icon5.gif  Re: how can i login as sysdba @ isqlplus [message #436891 is a reply to message #355146] Tue, 29 December 2009 07:06 Go to previous messageGo to next message
mmiorasun
Messages: 1
Registered: December 2009
Location: Dhaka
Junior Member
This really a bogus answer. Have you tried this by yourself? Why you confused the people? Also waste there time....

I got below solution for Oracle 10g with UNIX system:

Setting Up iSQL*Plus for SYSDBA and SYSOPER Access
When the iSQL*Plus Connection Role page appears, notice that the SYSOPER and SYSDBA roles require special setup and authentication for security reasons. To do this, you must set up a user in the Oracle Application Server Containers for J2EE (OC4J) user manager and grant access to the webDba role for the user. Do this by performing the following steps. Note that the JAVA_HOME OS environment variable must be set to $ORACLE_HOME/jdk.
1. Change to the correct directory:
cd $ORACLE_HOME/oc4j/j2ee/isqlplus/\
application-deployments/isqlplus
2. Run the JAZN shell:
$JAVA_HOME/bin/java \
-Djava.security.properties=\
$ORACLE_HOME\
/oc4j/j2ee/home/config/jazn.security.props \
-jar $ORACLE_HOME/oc4j/j2ee/home/jazn.jar \
-user "iSQL*Plus DBA/admin" \
-password welcome -shell
3. Create a user, choosing a username and password:
JAZN> adduser "iSQL*Plus DBA" username password
4. Grant the webDba role to the user:
JAZN> grantrole webDba "iSQL*Plus DBA" username
5. Exit the JAZN shell:
JAZN> exit

Thanks
Re: how can i login as sysdba @ isqlplus [message #436910 is a reply to message #436891] Tue, 29 December 2009 08:02 Go to previous message
Michel Cadot
Messages: 63808
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
As iSQL*Plus is obsolete, I think you're wasting your time.

Regards
Michel
Previous Topic: Client / Server Connection Problem
Next Topic: How do you Print an Explain Plan from SQL Developer?
Goto Forum:
  


Current Time: Wed Sep 28 22:44:43 CDT 2016

Total time taken to generate the page: 0.14386 seconds