Kamran Agayev's Oracle Blog

Oracle Certified Master

TNS-04612: Null RHS for … while creating a database using dbca

Posted by Kamran Agayev A. on March 31st, 2011

While creating a database I’ve got TNS-04414: File error caused by: TNS-04612: Null RHS for “….” error

Between quotation marks I’ve got a tns entry that was recently added. I tested it using tnsping utility and succeeded. However, the reason was that entry as it was added manually and it seems in this step somehow dbca can’t read or understand it :) Anyway, I took the backup of the tnsnames.ora file, deleted that entry and tried to create the database again, and it worked. After that, reverted the tnsnames back

6 Responses to “TNS-04612: Null RHS for … while creating a database using dbca”

  1. Michel Riou Says:

    This problem occur when i run version 10.2 of Console Enterprise Manager
    This a very funny error but took me a lot tries and errors to solve it !

    I’ts related to the syntax of an entry defining an SID in the tnsnames.ora. This an oracle bug for sure
    Here is an entry in my tnsnames.ora

    mydb.world =
    (ADDRESS = (PROTOCOL = TCP)(HOST = myoraclehost)(PORT = 1521))
    (SERVICE_NAME = mydb)

    At first look this entry is valid. At least SHOULD BE VALID an understood by oracle tnsnames interpreter
    After a couple of tries, i finally found that there should be at least one space between the begining of the line where figure out the description keyword (DESCRIPTION

    I’ve corrected the problem by inserting a space before this keyword.
    This happen

  2. Khalid Says:

    For me the trick worked the following way…

    i added a space before the TNS entry name and writing everything in one line 😀


  3. Davy Dullaert Says:

    Helped a lot!


  4. Edison Says:

    this help me a lot!!

  5. Sandro Says:

    Very, very, very thanks for the tip!

    Adding the space before “(DESCRIPTION”… it worked! :-)

    I don’t know if this bug (it is a bug, there is no doubt about this!) whether it is more absurd or funny…

    Bye, Sandro

  6. Kamran Agayev A. Says:

    Good to know it helped, Sandro :)

Leave a Reply

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>