3 Replies Latest reply on Nov 20, 2008 11:17 AM by vladino.83

    Try thousand times could not resolve famous ORA-12514 error

    670506
      It is related to Linux, Oracle 9.2.0. I am new Oracle.

      I am trying to connect to Oracle database say A, but as I am running this command dbstart the error is

      “ORA-12514: TNS: listener could not resolve SERVICE_NAME given in connect descriptor”

      I have successfully started lsnrctl. If you need I will send my “listener.ora”, “sqlnet.ora” & “tnsnames.ora” files.

      As per my investigation all entries are corect in these files. If you need any further info I will provide them, please help me to resolve this as my project is in critical position.
        • 1. Re: Try thousand times could not resolve famous ORA-12514 error
          649879
          Hi,

          Just check whether your ORACLE_HOME is refererring to the correct path.

          You can verify it in Environment variables.

          Thanks,
          Siva
          • 2. Re: Try thousand times could not resolve famous ORA-12514 error
            670506
            My ORACLE_HOME is set as:

            /home/oracle/product/9.2.0

            Here are my tnsnames.ora, listener.ora & sqlnet.ora files. For clarification database names are "Pana" & "Pana2", host name is "pana".

            TNSNAMES.ORA::

            PANA2 =
            (DESCRIPTION =
            (ADDRESS = (PROTOCOL = TCP) (HOST = pana) (PORT = 1521)

                 (CONNECT_DATA =
                 (SERVER = DEDICATED)
                 (SERVICE_NAME = Pana)
                 )
            )

            PANA =
            (DESCRIPTION =
                 (ADDRESS = (PROTOCOL = TCP) (HOST = pana) (PORT = 1521)

                 (CONNECT_DATA =
                 (SERVER = DEDICATED)
                 (SERVICE_NAME = Pana)
                 )
            )


            LISTENER.ORA:

            LISTENER =
            (ADDRESS = (PROTOCOL = TCP) (HOST = pana)(PORT = 1521))

            SID_LIST_LISTENER =

                 (SID_LIST =

            (SID_DES =
                      (GLOBAL_DBNAME = Pana2)
                      (ORACLE_HOME = /home/oracle/product/9.2.0)
                      (SID_NAME = Pana)
            )

                 (SID_DES =
                      (GLOBAL_DBNAME = Pana)
            (ORACLE_HOME = /home/oracle/product/9.2.0)
                      (SID_NAME = Pana)
                 )
            )


            SQLNET.ORA::

            SQLNET.AUTHENICATION_SERVICE = (NONE)
            NAMES.DEFAULT_DOMAIN = localadmin
            NAMES.DIRECTORY_PATH = (TNSNAMES, ONAMES, HOSTNAME)
            NAMES.PREFERRED_SERVERS =

            (ADDRESS_LIST =
            (ADDRESS =
                 (PROTOCOL = TCP)
                 (PORT = 1521)
                 (HOST = Pana2)
                 )

                 (ADDRESS =
                 (PROTOCOL = TCP)
                 (PORT = 1521)
                 (HOST = Pana)
                 )
            )


            Please tell me where I am wrong?
            • 3. Re: Try thousand times could not resolve famous ORA-12514 error
              vladino.83
              Ok, fisrt modify tnsnames.ora and other files - use uppercase in SERVICE_NAME. I'm not sure about this, but I'm using only uppercase in these files.

              Open your command line and run "ping PANA_IP_ADDRESS" to see if you can access database server at all. If this works, you just need to modify your HOSTS file. Then try to use command line and run "ping pana".

              Or, you need to modify tnsnames.ora and other files and replace "pana" in HOST property with IP address.

              Vlado