I have recently installed oracle 11g on Windows 7 Home Premium Operating System. I logged in as administrator into windows. I am trying to create a database using DBCA wizard. I started the wizard as administrator. Everything goes fine until last step. However when creating the database the creation fails with ORA-01034 Oracle Not Available error. All my oracle services looks up and running. I consulted the documentation and forums. I have got no clue why I am running into the error.

link|improve this question
feedback

migrated from stackoverflow.com Mar 19 '11 at 2:21

This question came from our site for professional and enthusiast programmers.

2 Answers

Did you look here?

A quote:

When DBCA is used to create or configure the database, the corresponding entry for the listener name alias is NOT automatically added to the tnsnames.ora file

Make sure the entry for the listener name alias specified by the LOCAL_LISTENER exists in the TNSNAMES.ORA file.

link|improve this answer
feedback

Before running DBCA, can you start LISTENER with lsnrctl start command?

You can find this tool in $ORACLE_HOME/bin.

If any config(LISTENER.ora) isn't created then this command will create it from scratch.

link|improve this answer
feedback

Your Answer

 
or
required, but never shown