-
Hi,
Can any one please let me know how can I connect as Sysdba or Sysoper.
I tried connecting Sys/sys as Sysdba, Got insifficient priviliges, then connect Internal/Oracle as sysdba same error.
Can any one please let me know how to connect as Sysdba.
I changed the password of Sys to Sys and Internal still has Oracle... I am asking to use personally on Oracle personal 8.0.5
Thanks in advance.
-
Which OS of your system?
If your system is Unix, your login account must be in DBA group as you want to connect as sysdba.
Am I solve your question?
Eric
-
I'm not sure,
but I guess you are on remote and
this have someting to do with your
remote_login_passwordfile = exclusive
in init.ora
-
ericchan is right ...
if your in the unix "dba" group simply ...
At the unix prompt(as "oracle" user - "dba" group):
%sqlplus /nolog
Now your at the SQL prompt:
SQL> connect / as sysdba
If your having this problem it sounds like you should invest 40 bucks in a good Oracle book.
Cheers,
Roger
-
Sorry Guys, I am in win Millenium... using Oracle Personal 8
I tried in Server Manager but did not let me in as SysDba..
Thanks in Advance
-
Hi,
first connect internal and then grant sysdba and sysoper to sys.OK and then try to connect sys /XXX as sysdba.Now u will be able to connect as sysdba ok.for confirmation check in v$pw_file view.ok/.
Cheers,
Vinod Kumar.
-
"insifficient priviliges..."
makes me think your password file is missing or is not at the correct location. For Windows it should be in --
Oracle_Home\database folder and should be named as pwdSID.ora
Then try connecting as sys with the password you specified at the time of password file creation.
I am assuming that you are connecting from the database server itself (not the client)
You should be part of the ORA_DBA group in Windows NT if you wish to connect as sysdba without the password --
connect / as sysdba
For Remote authentication you will also need to set the --
sqlnet.authentication_services = (NTS)
in the sqlnet.ora on both client and server side
- Rajeev
Rajeev Suri
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|