If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

unable to login in isqlplus(sql,pl/sql browser facility of Oracle 9i)

Hi,
I am new to Oracle 9i database administration.My problem is that I am unable to enter in isqlplus as sysdba.However I am able to login easily as user.I am trying to enter in my system database named orcl.I have tried to enter as username-sys and default password-change_on_install.
However i am not facing any problem in login either from command promt or from sqlplus with the same username and password.
Kindly help me to solve my problem.
You can also send the answer to me by email at saurabhverma2003@indiatimes.com
Regards,
Saurabh

Originally posted by Thomasps To connect as a sysdbb or SYSOPER you need to invkoe

"https://serverort/isqlplusdba"

Pre-requsite is to create the password file for the webserver authentication. example

$ORACLE_HOME/Apache/Apache/bin/htpasswd iplusdba.pw oracle

If you have apache running on your client machine (as I have, in order to connect to 100s of database servers via isqlplus), then you add your username and password to iplusdba.pw, which probably is not oracle :-)

I am doing the same thing. Installed oracle with apache in my client machine and created password file (in apache, gave the apache username "ORACLE" - I don't think it is a problem and working fine for me) . Created an Oracle user "thomas" with SYSDBA (so oracle pwd file exists) priviliages. In this way I didn't face any problem connecting to any number of databases in different servers.

I am doing the same thing. Installed oracle with apache in my client machine and created password file (in apache, gave the apache username "ORACLE" - I don't think it is a problem and working fine for me) . Created an Oracle user "thomas" with SYSDBA (so oracle pwd file exists) priviliages. In this way I didn't face any problem connecting to any number of databases in different servers.

I don't get very much of what you are trying to tell me. Where did you crea "an Oracle user "thomas" with SYSDBA"? In each databases?