1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

ora 12154 error when creating a new database

Discussion in 'Installation - Unix and Unix Like' started by irfsmurf, Dec 29, 2009.

  1. irfsmurf

    irfsmurf Active Member

    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    55
    Location:
    canada
    Hi Everyone,

    I am trying to create a new database using dbca and when the wizard reaches about 40% i get the ora 12154 error: TNS could not resolve the connect identifier specified

    Could anyone help please

    Cheers
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,351
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    Stop using an automated process for this. Use DBCA to create the necessary scripts to create your database then run those scripts from the command line; you may find the problem clearly presented to you.
     
    irfsmurf likes this.
  3. irfsmurf

    irfsmurf Active Member

    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    55
    Location:
    canada
    Hi Zargon,

    Thank you for you tip, I did exactly that and lo and behold my ORACLE_HOME was not set in the ORATAB file. Everything is running smooth now.

    Cheers and thank you :)
     
  4. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,351
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    You're welcome.