| Author |
ORA-01017: invalid username/password; logon denied
|
Vibhas Kumar
Greenhorn
Joined: Oct 13, 2009
Posts: 28
|
|
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:bea racle://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
Joined: Sep 19, 2006
Posts: 49
|
|
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?
|
~ Neil (SCJP)
|
|
Vibhas Kumar
Greenhorn
Joined: Oct 13, 2009
Posts: 28
|
|
|
Yes i am able to login into pl/sql developer (Oracle) using the same user id "SYS" and password.
|
|
Vibhas Kumar
Greenhorn
Joined: Oct 13, 2009
Posts: 28
|
|
|
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
Joined: Sep 19, 2006
Posts: 49
|
|
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
Joined: Oct 13, 2009
Posts: 28
|
|
|
Thanks Sunil will try and let you know.Also if not resolved i will post the prinst screen as well.
|
|
Vibhas Kumar
Greenhorn
Joined: Oct 13, 2009
Posts: 28
|
|
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
Joined: Sep 19, 2006
Posts: 49
|
|
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?
|
|
 |
|
|
subject: ORA-01017: invalid username/password; logon denied
|
|
|
0
