Re: Problems with isqlplusdba
From: Marc Guedon <guedon.marc_at_wanadoo.fr>
Date: Fri, 2 May 2003 10:33:02 +0200
Message-ID: <b8tagc$cg5$1_at_news-reader11.wanadoo.fr>
<Location /isqlplusdba>
SetHandler fastcgi-script
Order deny,allow
AuthType Basic
AuthName 'iSQL*Plus DBA'
AuthUserFile E:\oracle\ora92\sqlplus\admin\iplusdba.pw Require valid-user
</Location>
> Win 2000 Win Xp Oracle 9i Release 2 ISQLPLUSDBA
> Where can I find the file and what is the file name to enter username and
> password to connect myself via Apache as a sysdba?
> I get the message:
> Authorization Required
> This server could not verify that you are authorized to access the
document
> requested. Either you supplied the wrong credentials (e.g., bad password),
> or your browser doesn't understand how to supply the credentials required.
> ----
> Oracle HTTP Server Powered by Apache/1.3.22 Server at BEIJING Port 7778
> Greetings
> Manfred
>
> Received on Fri May 02 2003 - 10:33:02 CEST
Date: Fri, 2 May 2003 10:33:02 +0200
Message-ID: <b8tagc$cg5$1_at_news-reader11.wanadoo.fr>
Hi, Manfred
Have you read %ora_home%\sqlplus\admin\isqlplus.conf ?
Here :
# # Enable handling of all virtual paths beginning with "/isqlplusdba". # # Note: Oracle HTTP authentication access must be configured to # prevent unauthorized users performing DBA operations on # the database # # Use the HTTP server utility script "htpasswd" to add users to the # "iplusdba.pw" file. #
<Location /isqlplusdba>
SetHandler fastcgi-script
Order deny,allow
AuthType Basic
AuthName 'iSQL*Plus DBA'
AuthUserFile E:\oracle\ora92\sqlplus\admin\iplusdba.pw Require valid-user
</Location>
So try : htpasswd -b %ora_home%\sqlplus\admin\iplusdba.pw webadmin webadmin
This will authorize you to connect sysdba with webadmin/webadmin account !
Marc.
"Lanying & Manfred Chen-Fischer" <manfis_at_t-online.de> a écrit dans le
message de news:b8qgc8$v0q$07$1_at_news.t-online.com...
> Hello,
>
> Win 2000 Win Xp Oracle 9i Release 2 ISQLPLUSDBA
>
> Where can I find the file and what is the file name to enter username and
> password to connect myself via Apache as a sysdba?
>
> I get the message:
>
> Authorization Required
> This server could not verify that you are authorized to access the
document
> requested. Either you supplied the wrong credentials (e.g., bad password),
> or your browser doesn't understand how to supply the credentials required.
> >
> --------------------------------------------------------------------------
--
> ----
>
> Oracle HTTP Server Powered by Apache/1.3.22 Server at BEIJING Port 7778
> >
> Greetings
>
> Manfred
>
> Received on Fri May 02 2003 - 10:33:02 CEST