Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 73
  • Last Modified:

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
0
Sam OZ
Asked:
Sam OZ
  • 3
  • 2
1 Solution
 
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

Featured Post

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now