When I try to login as SYS, oracle complains that I should connect as SYSDBA or SYSOPER. Fine. Now I enter the login user as SYSDBA and enter the password..it fails. However, if I login as user scott and password tiger, I can login. Then from the SQL prompt I do:
connect SYS/<password> as SYSDBA;
and it works. So my question is, when I use the same <password> as login prompt and user as SYSDBA or SYSOPER, why does that fail and how can I change to make that work directly without loggin in as some other user and then manually change to SYS.
I've got the same problem with iSQLPlus, that sunjit had. but i can't connect through http://host:5560/isqlplus/dba, because it requests password "Realm iSQL*plus DBA". Nither sys/sysdba/sysoper/pass (database credentials) nor Administrator/pass (host crdentials) are working.
My question is: what kind of password should I type there, and if i didn't create it, where could I assign it?
For 10g, To access the isqlplus DBA url, you must set up login credentials using the Oracle JAAS provider, known as JAZN. See SQL*Plus User's guide for more details of how to setup iSQL*Plus DBA access.
was searching through the forum and found this thread. Im kinda having the same problem. I'm using Oracle 10.2.0 on Windows XP SP2. I can connect to iSQL*Plus using just a regular login, but I cannot connect as sysdba or sysoper. It asks for a computer username/password and I tried the admin user on the local computer and the admin user on the network, neither let me proceed. I logged in as system/password and then gave the instruction sys/password as sysdba and got the following error.
SP2-0927: CONNECT AS SYSDBA or AS SYSOPER not allowed through iSQL*Plus URL
Why is this? I have a 9.2 client running where I connect to the DB Across town BTW.
Oh and I don't have a Webdba role in my list of roles in my Enterprise Manager so I cannot add it to the sys user.
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 ur
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.