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 Java 8 in Action this week in the Java 8 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
 
Similar Threads
How to get Browser Variable value in side JSTL
Deployment failed
Database connectivity with servlet
Error connecting to Oracle database during Jboss startup
Problem with ODBC data source with JRun4