aspose file tools*
The moose likes BEA/Weblogic and the fly likes ORA-01017: invalid username/password; logon denied Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Products » BEA/Weblogic
Bookmark "ORA-01017: invalid username/password; logon denied " Watch "ORA-01017: invalid username/password; logon denied " New topic
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: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

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?

 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: ORA-01017: invalid username/password; logon denied