| problem when logging as sysdba as another user belonging to dba group [message #158960] |
Wed, 15 February 2006 04:16  |
deepa_balu
Messages: 74
Registered: March 2005
|
Member |
|
|
I have installed a 9i Rel 2 database on AIX box. (9.2.0.5)
When logged in as Oracle User which belongs to dba group i am able to connect as
sqlplus '/ as sysdba'
But when i login as another user which also belongs to dba group i am not able to login as sysdba
I can connect to it thru Sqlplus system/password@Instancename
$sqlplus /nolog
SQL*Plus: Release 9.2.0.1.0 - Production on Thu Jun 17 10:27:36 2004
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL> connect system@aix
Enter password:
Connected.
SQL> select name from v$database;
NAME
---------
ORCL
But when I try to connect to it using SYS, I get error as follows:
SQL> connect sys@aix
Enter password:
ERROR:
ORA-28009: connection to sys should be as sysdba or sysoper
Warning: You are no longer connected to ORACLE.
So, I try to connect as sysdba as follows:
SQL> connect sys as sysdba
Enter password:
Connected to an idle instance.
SQL> select name from v$database;
select name from v$database
*
ERROR at line 1:
ORA-01034: ORACLE not available
Although it connects BUT .. TO AN IDLE INSTANCE ?????
Could someone please explain what is going on and how can I connect to the database as SYS
when I connect using alias, I connect fine, but when I try to connect without supplying the alias, I get error.
I tried setting TWO_TASK but still it does not work . See below
/home/geneva> sqlplus '/ as sysdba'
SQL*Plus: Release 9.2.0.1.0 - Production on Thu Feb 16 01:45:37 2006
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
ERROR:
ORA-01031: insufficient privileges
Other info :
remote_login_passwordfile=NONE
|
|
|
|
| Re: problem when logging as sysdba as another user belonging to dba group [message #158977 is a reply to message #158960] |
Wed, 15 February 2006 05:27  |
tarundua
Messages: 1080
Registered: June 2005
Location: India
|
Senior Member |
|
|
You are stuck with two different-different issues:
1. First
| Quote: |
SQL> connect sys@aix
Enter password:
ERROR:
ORA-28009: connection to sys should be as sysdba or sysoper
Warning: You are no longer connected to ORACLE.
|
You can not connect to "sys" without specifying "as sysdba". The above statement should have been like this
SQL> connect sys/passwrd@aix as sysdba
2. And here
| Quote: |
SQL> connect sys as sysdba
Enter password:
Connected to an idle instance.
SQL> select name from v$database;
select name from v$database
*
ERROR at line 1:
ORA-01034: ORACLE not available
|
Your database is shutdown at this time , after logging to an "idle instance" give the following command first :
For the above command you should be logged in as sysdba.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
