Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

java.sql.SQLException: ORA-01034: ORACLE not available

AmbarishMitraSep 17 2008 — edited Sep 17 2008

Database: Oracle 10g Enterprise Edition.
OS: Solaris 10.

I have been sent a Java class file which is supposed to create a database user account in a Oracle 10g database. This file, during execution, asks for JDBC url, JDBC driver, the new user name, password, and the db admin user name, password. Which I enter correctly.

Please input JDBC URL: jdbc:oracle:thin:mydbserver:1521:orasid
Please input JDBC Driver: oracle.jdbc.driver.OracleDriver
Please input new database user name: newuser
Please input new database user password: password
Please input database admin name (Eg. sys): system
Please input database admin password: password

However, it gives the following error:

java.sql.SQLException: ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
SVR4 Error: 2: No such file or directory

I have checked the database is up and running, and I can successfully connect and login using the url:
http://mydbserver:5560/isqlplus

Any help/pointers to resolve the java.sql.SQLException even when the database is running will be helpful.

Thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 15 2008

Added on Sep 17 2008

#general-database-discussions

1 comment

1,578 views