Home » RDBMS Server » Security » cannot logging as sysdba
cannot logging as sysdba [message #430169] Mon, 09 November 2009 06:06 Go to next message
sailesh
Messages: 72
Registered: September 2007
Location: MAURITIUS
Member
Hi all,

i have migrated a 10g db to 11gR1 using export import.
Now i am unable to logging as sysdba on the 11g db.
i have created a password file manually on $ORACLE_HOME/dbs. furthermore, i am able to logging as sysdba using the tnsnames.ora.

SUN6#sqlplus

SQL*Plus: Release 11.1.0.6.0 - Production on Mon Nov 9 15:43:17 2009

Copyright (c) 1982, 2007, Oracle. All rights reserved.

Enter user-name: / as sysdba
ERROR:
ORA-01031: insufficient privileges

Enter user-name:

------------------------

here i am using my tnsnames.ora to resolve:

SUN6#sqlplus sys as sysdba@webcms

SQL*Plus: Release 11.1.0.6.0 - Production on Mon Nov 9 16:03:02 2009

Copyright (c) 1982, 2007, Oracle. All rights reserved.

Enter password:

Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>

please if anyone can help me sort out this problem.

Thanks,

Sailesh


Re: cannot logging as sysdba [message #430175 is a reply to message #430169] Mon, 09 November 2009 06:31 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
"connect / as sysdba" is only allowed if you are in the dba OS group.

Regards
Michel
Re: cannot logging as sysdba [message #430188 is a reply to message #430175] Mon, 09 November 2009 07:03 Go to previous messageGo to next message
sailesh
Messages: 72
Registered: September 2007
Location: MAURITIUS
Member
oracle user is in the dba group.

dba::100:
econnect::333:
# su - oracle
Sun Microsystems Inc. SunOS 5.10 Generic January 2005
SUN6#id
uid=100(oracle) gid=100(dba)
SUN6#
Re: cannot logging as sysdba [message #430198 is a reply to message #430188] Mon, 09 November 2009 07:46 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Is "dba" the dba group indicated at installation?

Regards
Michel

[Updated on: Mon, 09 November 2009 10:29]

Report message to a moderator

Re: cannot logging as sysdba [message #430218 is a reply to message #430169] Mon, 09 November 2009 09:27 Go to previous messageGo to next message
bucky
Messages: 1
Registered: November 2009
Junior Member
try not putting the password and let it ask for it in the sql+

try using username: sys@orcl AS SYSDBA

replace orcl with your db name u created orcl being default

no need to put anything in the host box

[Updated on: Mon, 09 November 2009 09:32]

Report message to a moderator

Re: cannot logging as sysdba [message #430305 is a reply to message #430198] Tue, 10 November 2009 00:21 Go to previous messageGo to next message
sailesh
Messages: 72
Registered: September 2007
Location: MAURITIUS
Member
Hi,

yes dba was used during installation.

Thanks,

Sailesh
Re: cannot logging as sysdba [message #430311 is a reply to message #430218] Tue, 10 November 2009 00:25 Go to previous messageGo to next message
sailesh
Messages: 72
Registered: September 2007
Location: MAURITIUS
Member
Hi,
See below: i can connect using this method. I had send this yesterday:

SUN6#sqlplus sys@webcms as sysdba

SQL*Plus: Release 11.1.0.6.0 - Production on Tue Nov 10 10:23:21 2009

Copyright (c) 1982, 2007, Oracle. All rights reserved.

Enter password:

Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>
Re: cannot logging as sysdba [message #430316 is a reply to message #430311] Tue, 10 November 2009 00:37 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I notice you use:
su - oracle
to post the group, so the question is: do you use this user to connect "/ as sysdba"?

Regards
Michel
Re: cannot logging as sysdba [message #430317 is a reply to message #430316] Tue, 10 November 2009 00:46 Go to previous messageGo to next message
sailesh
Messages: 72
Registered: September 2007
Location: MAURITIUS
Member
yes.

This is the user i used to connect to oracle.


Sailesh
Re: cannot logging as sysdba [message #430403 is a reply to message #430317] Tue, 10 November 2009 05:31 Go to previous messageGo to next message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
We need to assign the privileges on the DBA group to the user oracle?
While installation what are the permissions you entered for the oracle user?

sriram Smile
Re: cannot logging as sysdba [message #430531 is a reply to message #430403] Tue, 10 November 2009 22:40 Go to previous messageGo to next message
sailesh
Messages: 72
Registered: September 2007
Location: MAURITIUS
Member
hi,

the permission for oracle was 755 during installation.
how to assign the privileges on the DBA group to the user oracle, as the oracle user is an OS user not a db user.


Thanks,

Sailesh
Re: cannot logging as sysdba [message #430716 is a reply to message #430531] Thu, 12 November 2009 00:04 Go to previous messageGo to next message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
I am sorry i misunderstood....

Can you show us the parameters of your sqlnet.ora and

The value for REMOTE_LOGIN_PASSWORDFILE parameter also.

Sriram
Re: cannot logging as sysdba [message #430757 is a reply to message #430716] Thu, 12 November 2009 04:25 Go to previous messageGo to next message
sailesh
Messages: 72
Registered: September 2007
Location: MAURITIUS
Member
Hi,

The parameter is set as below;

remote_login_passwordfile string EXCLUSIVE
remote_os_authent boolean FALSE

for sqlnet.ora files

SQLNET.AUTHENTICATION_SERVICES = (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, EZCONNECT)
Re: cannot logging as sysdba [message #430764 is a reply to message #430757] Thu, 12 November 2009 05:04 Go to previous messageGo to next message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Strange case !

Show me the following..

Sqlplus /nolog

conn / as sysdba

sriram
Re: cannot logging as sysdba [message #430898 is a reply to message #430764] Thu, 12 November 2009 23:47 Go to previous messageGo to next message
sailesh
Messages: 72
Registered: September 2007
Location: MAURITIUS
Member
hi,

SUN6#sqlplus /nolog

SQL*Plus: Release 11.1.0.6.0 - Production on Fri Nov 13 09:45:40 2009

Copyright (c) 1982, 2007, Oracle. All rights reserved.

SQL> conn / as sysdba
ERROR:
ORA-01031: insufficient privileges


SQL>

Thanks,

sailesh
Re: cannot logging as sysdba [message #430958 is a reply to message #430764] Fri, 13 November 2009 07:20 Go to previous messageGo to next message
sailesh
Messages: 72
Registered: September 2007
Location: MAURITIUS
Member
hi,

i have found something on 10g and 11gR1 with my forms & Report. i have created a db user on 10g for ex pass123 lowercase. when the user login on the application, the password is converted to uppercase.

what i have tested is that on oracle 11g it accepts only passwd with uppercase. is there any way so that i can disable this security feature?


thanks,


Sailesh
Re: cannot logging as sysdba [message #430961 is a reply to message #430958] Fri, 13 November 2009 07:25 Go to previous message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
See this....This is for your topic ON forms....
Upgrade Notes @4.6



 sho parameter sec_case_sensitive_logon 

--HOpe this will (Not sure)...Try this at your Test DB...
sql> alter system set sec_case_sensitive_logon=false;



But for this topic I guess There should be a configuration issue....


Sriram.

[Updated on: Fri, 13 November 2009 07:44]

Report message to a moderator

Previous Topic: Revoke privilege
Next Topic: login issue
Goto Forum:
  


Current Time: Thu Mar 28 12:20:24 CDT 2024