CODEWITHSUNDEEP
javajdbcoracle11gsqlexception
fastboat
fastboat

Reputation: 23

java.sql.SQLException: ORA-01501: CREATE DATABASE failed ORA-01100: database already mounted

I made some MySQL java-jdbc code to create a database and add a few sample rows to it. I wanted to make this code work for oracle 11g also. So, I changed the connection URL in my code accordingly. But, now I am getting the error:

java.sql.SQLException: ORA-01501: CREATE DATABASE failed ORA-01100: database already mounted

I don't why am I getting this error. What does this mean "database already mounted" ? Please help me to fix this problem.

Thanks.

Upvotes: 2

Views: 13808

Answers (1)

Sai Ye Yan Naing Aye
Sai Ye Yan Naing Aye

Reputation: 6738

Shutdown the database then start it in nomount stage then apply create database statement 

     SQL>shutdown immediate;
     SQL>startup nomount;
     SQL>CREATE ........

Upvotes: 4

Related Questions