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
August 11th, 2011 at 1:05 am
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 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = myoraclehost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(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
November 1st, 2011 at 1:11 pm
For me the trick worked the following way…
i added a space before the TNS entry name and writing everything in one line 😀
PATTEST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.171.241.71)(PORT = 1521))) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = PATTEST)))
October 26th, 2012 at 12:04 pm
Helped a lot!
Thanks..
December 24th, 2013 at 1:58 pm
Thanks,
this help me a lot!!
May 15th, 2015 at 5:39 pm
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
June 24th, 2015 at 11:14 am
Good to know it helped, Sandro