| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: [Q] insufficient privilege while "connect / as sysdba" on NT?
hi.
after re-creating the password file, you have to cycle the instance for it
to take effect.
stop and restart the oracle service. (this will kill any connections)
You are better off to login to the instance and perform the shutdown
manually as opposed to just killing the service.
Have you set the timeout parameter for the service?
you can manually adjust this via the oradim.exe utility
D:\Oracle\Ora81\Bin\> oradim -edit -sid ORCL -timeout 300
this can also be set in the registry:
HKLM\SOFTWARE\ORACLE\HOMEn\ORACLE_%ORACLE_SID%_SHUTDOWN_TIMEOUT I like a value of 300 seconds for a smaller sga, larger if you have a large SGA. You will also have to set the following parameter:
HKLM\SYSTEM\CurrentControlSet\Control\WaitToKillServiceTimeout 300000
this one is in milliseconds.
As usual, you may want to backup the registry with regedit.exe prior to making changes.
hth,
Paul
-----Original Message-----
Sent: Friday, February 14, 2003 2:31 PM
To: Multiple recipients of list ORACLE-L
e have ORACLE 8.1.7 on NT server and I login as user wirh "administrator" privilege. I tried to "connect / as sysdba" and got "insufficient prvilege". The procedure are:
I have been recreate the password file on oracle ($ORACLE_HOME/databae/pwXXX.ora). Still make no difference. If I use "svrmgrl" ==> "connect internal", it work fine.
Does anyone know why?
Thanks.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: dist cash
INET: mccdba_at_hotmail.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
"This information in this e-mail is intended solely for the addressee and may contain information which is confidential or privileged. Access to this e-mail by anyone else is unauthorized. If you are not the intended recipient, or believe that you have received this communication in error, please do not print, copy, retransmit, disseminate, or otherwise use the information. Also, please notify the sender that you have received this e-mail in error, and delete the copy you received."
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Drake, Paul
INET: Paul.Drake_at_encodasystems.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri Feb 14 2003 - 14:23:50 CST
 |
 |