HP Openview, used for monitoring and alerting, is in it's migration phase. The database now runs on Oracle 11g. However, the Reporting Server that connects to the database underwent no such migration or upgrade. This Reporting Server is still using the Oracle 9.1 ODBC drivers.
While trying to connect to the new 11g database, the team encountered the following error:
Unable to connect
SQLState=28000
[Oracle][ODBC][Ora]ORA-01017: invalid username/password; logon denied
Interestingly, if I tried to connect using SQLPLUS, I could establish a connection without any problems.
C:\Documents and Settings\xxxxxx>sqlplus
SQL*Plus: Release 9.2.0.1.0 - Production on Wed Sep 5 10:13:57 2012
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Enter user-name: opc_report@xxxxxxxxxxxxx
Enter password:
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> select * from v$version;
BANNER
-------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
PL/SQL Release 11.2.0.3.0 - Production
CORE 11.2.0.3.0 Production
TNS for HPUX: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - Production
SQL>
Cause and Solution:
This was because of the usage of CASE SENSITIVE passwords in Oracle 11g. This was resolved by turning off the case sensitive feature in the database:$ sqlplus
SQL*Plus: Release 11.2.0.3.0 Production on Wed Sep 5 10:05:06 2012
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Enter user-name: / as sysdba
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> alter system set SEC_CASE_SENSITIVE_LOGON = FALSE
2 scope=both;
System altered.
And, woolaaa:
Dear Sir,
ReplyDeleteI m planning to write oracle certification exam but confused to choose between 10g or 11g, please suggest me, which exam should i take...
i m also using certification dumps so please review the questions or provide me latest dumps...
1z0-054 dumps oracle database
Hi Faraz,
ReplyDeleteSorry for the late reply. Always go with the latest technology certification. If you already have obtained your 11g Certification, try to upgrade it to 12c.
I personally do not like the idea of using Dumps or any other means of passing the exam. This will not be of any help in the long term. I would strongly advise you to learn, practice and again learn before you sit for your exam.
All the best !
I'm pretty sure it is VIOLA... :-)
ReplyDeleteHi,
ReplyDeleteWhen i am trying to run this query: alter system set SEC_CASE_SENSITIVE_LOGON = FALSE
i am getting the error as: illegal option for ALTER SYSTEM
Can you please help with this.
Not able to Solve Oracle Connection Issue with Pyodbc? Contact to Remote DBA Services
ReplyDeleteSo far trying to interface with the Oracle Database using Pyodbc anyway it keeps giving you an oversight message? Damn without question, you are having is that 64 bits Windows which isn't play well with your 32 bit ODBC. If you have to deal with this issue by then undertaking to associate with Database Administration for Oracle or Oracle Database Solution. Here we furthermore give Online Oracle DB Support and resolve you're altogether particular glitches inside surveyed day and age.
For More Info: https://cognegicsystems.com/
Contact Number: 1-800-450-8670
Email Address- info@cognegicsystems.com
Company’s Address- 507 Copper Square Drive Bethel Connecticut (USA) 06801
I am so glad for my result in 1Z0-054 Exam and I wish good luck to all the candidates who aspire to pass this IT Exam. I say thanks to DumpsResources.com for helping me with 1Z0-054 Dumps PDF and developing online practice test. In addition, I also suggest all the candidates to use 1Z0-054 Dumps during their preparation. I think it would be a very difficult task to pass this certification without taking help from this smart guide. I am so excited for this incredible success.
ReplyDelete