ORA-01034: ORACLE not available - When trying to connect to database using tnsnames

Hi everyone


We have a 11.2.0.4 Database on Linux

There are 2 interfaces on the db server one to be used as PUBLIC and other one as PRIVATE
PUBLIC IP is 192.168.1.12 and PRIVATE IP is 10.2.2.12
We have configured 2 listeners; one for PUBLIC IP and the other for PRIVATE IP
Applicaiton would be connected to the database server using PRIVATE IP only


We also have configured tnsnames.ora file to test the connectivity from within the database serve
Here is the tnsnames.ora from the db server

ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.12)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )

PROD =
  (DESCRIPTION =