Win a copy of Soft Skills: The software developer's life manual this week in the Jobs Discussion forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

ORA-01017: invalid username/password; logon denied

 
Vibhas Kumar
Greenhorn
Posts: 28
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Friends while configuring the weblogic admin console i am getting this problem i dont know why but my user name and password for Oracle 11g server is "SYS" only. Here is the error which i am getting now:

Message icon - Error Connection test failed. Message icon - Error [BEA][Oracle JDBC Driver][Oracle]ORA-01017: invalid username/password; logon denied
weblogic.jdbc.base.BaseExceptions.createException(Unknown Source)
weblogic.jdbc.base.BaseExceptions.getException(Unknown Source)
weblogic.jdbc.oracle.OracleImplConnection.connectAndAuthenticate(Unknown Source)
weblogic.jdbc.oracle.OracleImplConnection.open(Unknown Source)
weblogic.jdbc.base.BaseConnection.connect(Unknown Source)
weblogic.jdbc.base.BaseConnection.setupImplConnection(Unknown Source)
weblogic.jdbc.base.BaseConnection.open(Unknown Source)
weblogic.jdbcx.base.BaseXADataSource.getBaseConnectionPreparedForXA(Unknown Source)
weblogic.jdbcx.base.BaseXADataSource.getXAConnection(Unknown Source)
com.bea.console.utils.jdbc.JDBCUtils.testConnection(JDBCUtils.java:550)
com.bea.console.actions.jdbc.datasources.createjdbcdatasource.CreateJDBCDataSource.testConnectionConfiguration(CreateJDBCDataSource.java:369)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
java.lang.reflect.Method.invoke(Method.java:597)
org.apache.beehive.netui.pageflow.FlowController.invokeActionMethod(FlowController.java:870)
org.apache.beehive.netui.pageflow.FlowController.getActionMethodForward(FlowController.java:809)
org.apache.beehive.netui.pageflow.FlowController.internalExecute(FlowController.java:478)
org.apache.beehive.netui.pageflow.PageFlowController.internalExecute(PageFlowController.java:306)
org.apache.beehive.netui.pageflow.FlowController.execute(FlowController.java:336)
...

These are the details:

Driver Class Name:weblogic.jdbcx.oracle.OracleDataSource

URL:jdbc:bearacle://127.0.0

Database User Name:SYS Password:SYS

Properties: user=SYS portNumber=1521 SID=ORCL serverName=127.0.0.1

Test Table Name: select * from customer
 
Sunil Tiwari
Ranch Hand
Posts: 49
Clojure Redhat Spring
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Well are you able to connect to the Oracle using sys as user?
I believe you cannot do that. The connection to sys should be as sysdba or sysoper!

Why don't you create a new user and try connecting with it?
 
Vibhas Kumar
Greenhorn
Posts: 28
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Yes i am able to login into pl/sql developer (Oracle) using the same user id "SYS" and password.
 
Vibhas Kumar
Greenhorn
Posts: 28
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Also when i run the query to get the username and password i get the username as "SYS" only. I am able to login into oracle using the same username and password.
 
Sunil Tiwari
Ranch Hand
Posts: 49
Clojure Redhat Spring
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
a) Can you paste the screen shot where you are trying to set the user in Admin console?

b) Can you paste the screenshot of the PL/SQL connection settings / connection dialog box? I think you are setting the connect as parameter to SYSDBA, along with user SYS and password.

c) There is a property as : internal_logon which can be set to sysdba, to connect to the Oracle as SYS.

d) Try using user/password SCOTT/TIGER, and test your Connectivity through Admin Console.
 
Vibhas Kumar
Greenhorn
Posts: 28
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks Sunil will try and let you know.Also if not resolved i will post the prinst screen as well.
 
Vibhas Kumar
Greenhorn
Posts: 28
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Sunil I tried with scott/tiger as username and password and able to login into the pl/sql developer. Also i tried to use the same credentials in weblogic admin console and got this error now. Kindly suggest what is this issue.

ORA-28000: the account is locked <br/>oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)<br/>oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:112)<br/>oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:173)<br/>oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)<br/>oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:406)<br/>oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)<br/>oracle.jdbc.driver.T4CTTIoauthenticate.receiveOauth(T4CTTIoauthenticate.java:794)<br/>oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:391)<br/>oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:490)<br/>oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:202)<br/>oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:33)<br/>oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:474)<br/>com.bea.console.utils.jdbc.JDBCUtils.testConnection(JDBCUtils.java:505)<br/>com.bea.console.actions.jdbc.datasources.createjdbcdatasource.CreateJDBCDataSource.testConnectionConfiguration(CreateJDBCDataSource.java:369)<br/>sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<br/>sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)<br/>sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)<br/>java.lang.reflect.Method.invoke(Method.java:597)<br/>org.apache.beehive.netui.pageflow.FlowController.invokeActionMethod(FlowController.java:870)<br/>org.apache.beehive.netui.pageflow.FlowController.getActionMethodForward(FlowController.java:809)<br/>...

thanks in advance
 
Sunil Tiwari
Ranch Hand
Posts: 49
Clojure Redhat Spring
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
well the exception itself is declaring that "ORA-28000: the account is locked oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)"!!
Check with your DBA / DB Developer if any other account exists.

Did you try setting up internal_logon property for SYS user?

 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic