Oracle Database creation fails

Hi Experts,
While trying to create a DB in Oracle 11G (0.3) , the DB creates , but with the error in attachment. I can see the Listener service and the DB service running correctly.  
Any idea on what causes this error ?
DBCreationFailed---Copy.JPG
Sam OZAsked:
Who is Participating?
 
slightwv (䄆 Netminder) Commented:
From a CMD prompt do:  lsnrctl status

That will tell you the listener name, port, etc...  that you need to provide to DBCA.

The database created fine.  It was just the last piece or registering it with the listener.

Go ahead and OK that window.
0
 
Sam OZAuthor Commented:
Thanks.  The IP and Port looks correct as what I try to configure the Netservice name . Still there is same error . Please see the attachment.
0
 
slightwv (䄆 Netminder) Commented:
No attachment.
0
 
Sam OZAuthor Commented:
Thanks.  The IP and Port looks correct as what I try to configure the Netservice name . Still there is same error . Please see the attachment. (Sorry , the last post didn't have the attachment)
OracleError.JPG
0
 
slightwv (䄆 Netminder) Commented:
That error means you have entered a service name that the listener isn't listening for.  Not sure what you were trying but forget about that for now.

The database service should be running.

From a CMD prompt:
sqlplus / as sysdba

If you connect post the result of:
show parameter local_listener


Can you also post the listener.ora and tnsnames.ora file from:
d:\app\administrator\product\11.2.0\dbhome_1\network\admin
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.