| insufficient privileges [message #251533] |
Sat, 14 July 2007 05:34  |
M.Shakeel Azeem
Messages: 226
Registered: September 2006
|
Senior Member |
|
|
i am using oracle 10g on redhat AS 4
[oracle@linora /] sqlplus /nolog
SQL>conn system/gateway@linorcl Connected.
But whenever i tried to connect as sysdba like:
SQL>conn sys/gateway@linorcl as sysdbaERROR:
ORA-01031: insufficient priviliges
Warning :you are no longer connected to ORACLE
should i have to recreate password file or there is some other issues?
thanx in advance
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: insufficient privileges [message #251989 is a reply to message #251885] |
Tue, 17 July 2007 11:02  |
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
|
Senior Member |
|
|
DreamzZ:/export/home/oracle: cat $ORACLE_HOME/network/admin/sqlnet.ora
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
SQLNET.AUTHENTICATION_SERVICES=NTS
omzimp14ESPSVCS:/export/home/oracle: sqlplus sys as sysdba
SQL*Plus: Release 10.2.0.3.0 - Production on Tue Jul 17 16:01:11 2007
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
Enter password:
ERROR:
ORA-01031: insufficient privileges
|
|
|
|
|
|
|
|
| Re: insufficient privileges [message #252186 is a reply to message #252183] |
Wed, 18 July 2007 01:50 |
M.Shakeel Azeem
Messages: 226
Registered: September 2006
|
Senior Member |
|
|
| Mohammad Taj wrote on Wed, 18 July 2007 01:44 | Hi,
There is no problem.
For connect to database without password as SYSDBA privs.
1. OS user add OS DBA group
2. sqlnet.authentication_services=NTS
3. except SYS user must grant SYSDBA privs to user for connect sysdba privs.
4. we are able to connect without password only on Oracle Server not through CLIENT.
through client we must give Password for connection.
Default value is sqlnet.authentication_services=NTS.
In Documentation showing default value is NONE but when we create database through dbca then default value is NTS instead of NONE.
Regards
Taj
|
|
|
|
|
|
|
|
|
|
|
| Re: insufficient privileges [message #252201 is a reply to message #252183] |
Wed, 18 July 2007 02:27 |
M.Shakeel Azeem
Messages: 226
Registered: September 2006
|
Senior Member |
|
|
Dear taj
as u suggest,after making sure
1-sqlnet.authentication_services=NTS
2-REMOTE_LOGIN_PASSWORDFILE=exclusive
and re-creating the password file i have resolved the problem
now i am able to connect
sys/pass@linorcl as sysdba
thanx to u
can u please tell me how to automate dbstart and dbshut
in 10g
can u please provide the steps?
i have used the following steps
1-edit the "/etc/oratab" with the following
TSH1:/u01/app/oracle/product/10.2.0:Y
2-create a file called "/etc/init.d/dbora" as the root user
#!/bin/sh
# chkconfig: 345 99 10
# description: Oracle auto start-stop script.
#
# Change the value of ORACLE_HOME to specify the correct Oracle home
# directory for your installation.
ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1
#
# Change the value of ORACLE to the login name of the
# oracle owner at your site.
#
ORACLE=oracle
PATH=${PATH}:$ORACLE_HOME/bin
HOST=`hostname`
PLATFORM=`uname`
export ORACLE_HOME PATH
#
if [ ! "$2" = "ORA_DB" ] ; then
if [ "$PLATFORM" = "HP-UX" ] ; then
remsh $HOST -l $ORACLE -n "$0 $1 ORA_DB"
exit
else
rsh $HOST -l $ORACLE $0 $1 ORA_DB
exit
fi
fi
#
case $1 in
'start')
$ORACLE_HOME/bin/dbstart $ORACLE_HOME
;;
'stop')
$ORACLE_HOME/bin/dbshut $ORACLE_HOME
;;
*)
echo "usage: $0 {start|stop}"
exit
;;
esac
#
exit
5-Change the group of the dbora file to the OSDBA group (typically dba), and set the permissions to 750:
# chgrp dba dbora
# chmod 750 dbora
but no success ,can u please give me any suggestions regarding this?
it'll b highly appreciated
thanx in advance
|
|
|
|
| Re: insufficient privileges [message #252270 is a reply to message #252197] |
Wed, 18 July 2007 07:45 |
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
|
Senior Member |
|
|
Hi,
C:\>type c:\oracle\product\10.1.0\db_1\network\admin\sqlnet.ora
# sqlnet.ora Network Configuration File: C:\oracle\product\10.1.0\Db_1\network\a
dmin\sqlnet.ora
# Generated by Oracle configuration tools.
SQLNET.AUTHENTICATION_SERVICES= (NONE)
SQLNET.EXPIRE_TIME=2
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
C:\>sqlplus sys as sysdba
SQL*Plus: Release 10.1.0.5.0 - Production on Wed Jul 18 16:39:03 2007
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Enter password:
Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.5.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> create user asss identified by asss;
User created.
SQL> conn asss as sysdba
Enter password:
ERROR:
ORA-01031: insufficient privileges
Warning: You are no longer connected to ORACLE.
SQL> EXIT
C:\>type c:\oracle\product\10.1.0\db_1\network\admin\sqlnet.ora
# sqlnet.ora Network Configuration File: C:\oracle\product\10.1.0\Db_1\network\a
dmin\sqlnet.ora
# Generated by Oracle configuration tools.
SQLNET.AUTHENTICATION_SERVICES= (NTS)
SQLNET.EXPIRE_TIME=2
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
C:\>SQLPLUS SYS/ORACLE AS SYSDBA
SQL*Plus: Release 10.1.0.5.0 - Production on Wed Jul 18 16:40:55 2007
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.5.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> CONN ASSS AS SYSDBA
Enter password:
Connected.
SQL>
Note: my OS User is member of ORA_DBA group.
Regards
Taj
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
