| cannot logging as sysdba [message #430169] |
Mon, 09 November 2009 06:06  |
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 #430188 is a reply to message #430175] |
Mon, 09 November 2009 07:03  |
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 #430311 is a reply to message #430218] |
Tue, 10 November 2009 00:25 |
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 #430531 is a reply to message #430403] |
Tue, 10 November 2009 22:40 |
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 #430757 is a reply to message #430716] |
Thu, 12 November 2009 04:25 |
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 #430898 is a reply to message #430764] |
Thu, 12 November 2009 23:47 |
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 |
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 |
 |
ramoradba
Messages: 2457
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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
