1 2 Previous Next 19 Replies Latest reply: Dec 11, 2012 9:33 PM by Dennis Lovelady RSS

    ORA-12545 when connecting to default (OK when using SID)

    Dennis Lovelady
      I am working with the Oracle Virtual Machine templates for HCM912 and TOOLS852. The installation and configuration went well, with only a couple of hurdles. Among them, there was no tnsnames.ora, listener.ora, and sqlnet.ora file created (probably because I missed something). However, I have created these, and everything is sort of working. In particular, I'm able to connect to and use the PIA, and Application Designer is working flawlessly.

      The problem is that when any local (not network-based) user (oracle and psadm2 among them) tries to connect to the database without specifying an instance name, ORA-12545 results. But connection with an instance name (SYSADM@HCM912) works fine. I could live with this (sort of), but it seems that the sqr utility is not operable at all since (as far as I can see) I cannot tell the local sqr what database to connect to. It will use the default, and the result is:

      psadm2@hcm /opt/oracle/psft/pt/tools/sqr> sqr setspace.sqr
      Enter Username: SYSADM
      Enter Password:
      SQR for PeopleSoft V8.52
      (SQR 5528) ORACLE OCIServerAttach error 12545 in cursor 0:
      ORA-12545: Connect failed because target host or object does not exist
      (SQR 4701) Cannot logon to the database.
      SQR for PeopleSoft: Program Aborting.

      Similarly, sqlplus result is like this:

      psadm2@hcm /opt/oracle/psft/pt/tools/sqr> sqlplus SYSADM
      SQL*Plus: Release 11.2.0.2.0 Production on Sat Dec 8 05:52:36 2012
      Copyright (c) 1982, 2010, Oracle. All rights reserved.
      Enter password:
      ERROR:
      ORA-12545: Connect failed because target host or object does not exist
      Enter user-name: SYSADM@HCM912
      Enter password:
      Connected to:
      Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
      With the Partitioning and Oracle Label Security options
      SQL>

      What do I need to do in order to make the system default to HCM912? (ORACLE_SID is currently set to HCM912, which I thought was enough for this.)

      Here're the essentials:

      /u01/app/oracle/product/11.2.0.x/db_1/network/admin/tnsnames.ora
      HCM912=
      (DESCRIPTION =
      (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL=TCP)(HOST=hcm)(PORT=1521))
      )
      (CONNECT_DATA =
      (SERVICE_NAME = HCM912)
      )
      )

      /u01/app/oracle/product/11.2.0.x/db_1/network/admin/sqlnet.ora
      ames.directory_path = (LDAP, TNSNAMES, HOSTNAME)
      names.default_domain =
      trace_level_client = OFF
      sqlnet.expire_time = 30

      /u01/app/oracle/product/11.2.0.x/db_1/network/admin/listener.ora
      LISTENER =
      (DESCRIPTION_LIST =
      (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = hcm)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      )
      )

      $ lsnrctl status

      Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=hcm)(PORT=1521)))
      STATUS of the LISTENER
      ------------------------
      Alias LISTENER
      Version TNSLSNR for Linux: Version 11.2.0.2.0 - Production
      Start Date 02-DEC-2012 08:13:48
      Uptime 5 days 21 hr. 44 min. 29 sec
      Trace Level off
      Security ON: Local OS Authentication
      SNMP OFF
      Listener Parameter File /u01/app/oracle/product/11.2.0.x/db_1/network/admin/listener.ora
      Listener Log File /u01/app/oracle/product/11.2.0.x/db_1/log/diag/tnslsnr/hcm/listener/alert/log.xml
      Listening Endpoints Summary...
      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=hcm)(PORT=1521)))
      (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
      Services Summary...
      Service "HCM912" has 1 instance(s).
      Instance "HCM912", status READY, has 1 handler(s) for this service...
      Service "XDB" has 1 instance(s).
      Instance "HCM912", status READY, has 1 handler(s) for this service...
      The command completed successfully

      Select environment variables (for psadm2 user)

      ORACLE_BASE=/opt/oracle/psft/pt/oracle-client
      ORACLE_HOME=/opt/oracle/psft/pt/oracle-client/11.2.0.x
      ORACLE_SID=HCM912
      PS_APP_HOME=/opt/oracle/psft/pt/apptools
      PS_CFG_HOME=/home/psadm2/psft/pt/8.52
      PS_DB=ORA
      PS_DBVER=8.1.x
      PS_DM_DATA_IN=/opt/oracle/psft/pt/tools/data
      PS_DM_DATA_OUT=/home/psadm2/PS_DM/data
      PS_DM_LOG=/home/psadm2/PS_DM/log
      PS_DM_SCRIPT=/opt/oracle/psft/pt/tools/scripts
      PS_HOME=/opt/oracle/psft/pt/tools
      PS_HOSTTYPE=oel-5-x86_64
      PS_JRE=/opt/oracle/psft/pt/tools/jre
      PS_LIBPATH=/opt/oracle/psft/pt/tools/bin
      PS_SERVDIR=/home/psadm2/PS_CACHE
      PS_SERVER_CFG=/opt/oracle/psft/pt/tools/setup/psdmtx.cfg
      PWD=/home/psadm2
      SQRDIR=/opt/oracle/psft/pt/tools/bin/sqr/ORA/bin
      SQR_HOME=/opt/oracle/psft/pt/tools/bin/sqr/ORA

      ---

      psadm2@hcm /home/psadm2> ping hcm
      PING hcm (127.0.0.1) 56(84) bytes of data.
      64 bytes from hcm (127.0.0.1): icmp_seq=1 ttl=64 time=0.020 ms
      64 bytes from hcm (127.0.0.1): icmp_seq=2 ttl=64 time=0.032 ms
      64 bytes from hcm (127.0.0.1): icmp_seq=3 ttl=64 time=0.020 ms
      ^C
      --- hcm ping statistics ---
      3 packets transmitted, 3 received, 0% packet loss, time 2001ms
      rtt min/avg/max/mdev = 0.020/0.024/0.032/0.005 ms

      Not sure what else I might provide to help. Any ideas what I'm doing wrong here, and how I can get sqr to connect?

      Thanks for your time!

      Edited by: Dennis Lovelady on Dec 8, 2012 8:27 AM - removed blank lines for clarity
        • 1. Re: ORA-12545 when connecting to default (OK when using SID)
          John Spencer
          Dennis:

          I think your proble is that you have the server name hcm configured with localhost IP address in the hosts file (/etc/hosts)

          The fact that you get:
          ping hcm
          PING hcm (127.0.0.1) 56(84) bytes of data.
          64 bytes from hcm (127.0.0.1): icmp_seq=1 ttl=64 time=0.020 ms
          64 bytes from hcm (127.0.0.1): icmp_seq=2 ttl=64 time=0.032 ms
          64 bytes from hcm (127.0.0.1): icmp_seq=3 ttl=64 time=0.020 ms
          seems to indicate that. You should be getting the actual IP address of the server, even pinging from the server.

          John
          • 2. Re: ORA-12545 when connecting to default (OK when using SID)
            Dennis Lovelady
            Thanks, John.

            I forgot to mention that I had tried that, and it didn't seem to help.

            Now, ping returns this, but still no joy without @HCM912 in Connect string:

            psadm2@hcm /home/psadm2> ping hcm
            PING hcm.lovelady.com (192.168.0.43) 56(84) bytes of data.
            64 bytes from hcm.lovelady.com (192.168.0.43): icmp_seq=1 ttl=64 time=0.011 ms
            64 bytes from hcm.lovelady.com (192.168.0.43): icmp_seq=2 ttl=64 time=0.032 ms
            64 bytes from hcm.lovelady.com (192.168.0.43): icmp_seq=3 ttl=64 time=0.033 ms
            ^C
            --- hcm.lovelady.com ping statistics ---
            3 packets transmitted, 3 received, 0% packet loss, time 2001ms
            rtt min/avg/max/mdev = 0.011/0.025/0.033/0.010 ms

            psadm2@hcm /home/psadm2> sqlplus SYSADM

            SQL*Plus: Release 11.2.0.2.0 Production on Sat Dec 8 06:35:11 2012
            Copyright (c) 1982, 2010, Oracle. All rights reserved.
            Enter password:
            ERROR:
            ORA-12545: Connect failed because target host or object does not exist
            Enter user-name: SYSADM@HCM912
            Enter password:
            Connected to:
            Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
            With the Partitioning and Oracle Label Security options
            SQL>
            • 3. Re: ORA-12545 when connecting to default (OK when using SID)
              sb92075
              post results from following OS commands below

              hostname
              uname -a
              cat /etc/hosts
              /sbin/ifconfig
              id
              env | sort
              • 4. Re: ORA-12545 when connecting to default (OK when using SID)
                Dennis Lovelady
                psadm2@hcm /home/psadm2> hostname
                hcm

                psadm2@hcm /home/psadm2> hostname --long
                hcm.lovelady.com

                psadm2@hcm /home/psadm2> uname -a
                Linux hcm 2.6.32-300.39.1.el5uek #1 SMP Wed Nov 7 18:13:56 PST 2012 x86_64 x86_64 x86_64 GNU/Linux

                psadm2@hcm /home/psadm2> cat /etc/hosts
                # Do not remove the following line, or various programs
                # that require network functionality will fail.
                127.0.0.1 localhost.localdomain localhost
                ::1 localhost6.localdomain6 localhost6

                psadm2@hcm /home/psadm2> id
                uid=506(psadm2) gid=505(oracle) groups=505(oracle)

                psadm2@hcm /home/psadm2> /sbin/ifconfig
                eth0 Link encap:Ethernet HWaddr 00:0C:29:B4:6E:C5
                inet addr:192.168.0.43 Bcast:192.168.0.255 Mask:255.255.255.0
                UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
                RX packets:3512662 errors:0 dropped:0 overruns:0 frame:0
                TX packets:1387000 errors:0 dropped:0 overruns:0 carrier:0
                collisions:0 txqueuelen:1000
                RX bytes:266101161 (253.7 MiB) TX bytes:1997579983 (1.8 GiB)

                lo Link encap:Local Loopback
                inet addr:127.0.0.1 Mask:255.0.0.0
                UP LOOPBACK RUNNING MTU:16436 Metric:1
                RX packets:2929535 errors:0 dropped:0 overruns:0 frame:0
                TX packets:2929535 errors:0 dropped:0 overruns:0 carrier:0
                collisions:0 txqueuelen:0
                RX bytes:1331894028 (1.2 GiB) TX bytes:1331894028 (1.2 GiB)

                psadm2@hcm /home/psadm2> env | sort
                CLASSPATH=/opt/oracle/psft/pt/tools/appserv/classes
                COBDIR=/opt/oracle/psft/pt/cobol/svrexp-51_wp4-64bit
                COBPATH=/opt/oracle/psft/pt/tools/cblbin
                DM_HOME=/home/psadm2/PS_DM
                G_BROKEN_FILENAMES=1
                HISTSIZE=1000
                HOME=/home/psadm2
                HOSTNAME=hcm
                INPUTRC=/etc/inputrc
                IS_PS_PLT=Y
                JAVA_FONTS=/opt/oracle/psft/pt/tools/jre/lib/fonts:/usr/share/fonts/default/TrueType:/usr/share/font
                s/ja/TrueType:/usr/share/fonts/zh_CN/TrueType:/usr/share/fonts/zh_TW/TrueType:/usr/share/fonts/ko/Tr
                ueType
                LANG=C
                LD_LIBRARY_PATH=/opt/oracle/psft/pt/tools/jre/lib/amd64/native_threads:/opt/oracle/psft/pt/tools/jre
                /lib/amd64/server:/opt/oracle/psft/pt/tools/jre/lib/amd64:/opt/oracle/psft/pt/bea/tuxedo/lib::/opt/o
                racle/psft/pt/oracle-client/11.2.0.x/lib:/opt/oracle/psft/pt/tools/bin:/opt/oracle/psft/pt/tools/bin
                /interfacedrivers:/opt/oracle/psft/pt/tools/bin/sqr/ORA/bin:/opt/oracle/psft/pt/tools/optbin:/opt/or
                acle/psft/pt/tools/verity/linux/_ilnx21/bin:/opt/oracle/psft/pt/oracle-client/11.2.0.x/lib:/opt/orac
                le/psft/pt/cobol/svrexp-51_wp4-64bit/lib
                LESSOPEN=|/usr/bin/lesspipe.sh %s
                LOGNAME=psadm2
                LS_COLORS=no=00:fi=00:di=00;34:ln=00;36:pi=40;33:so=00;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=
                01;05;37;41:ex=00;32:*.cmd=00;32:*.exe=00;32:*.com=00;32:*.btm=00;32:*.bat=00;32:*.sh=00;32:*.csh=00
                ;32:*.tar=00;31:*.tgz=00;31:*.arj=00;31:*.taz=00;31:*.lzh=00;31:*.zip=00;31:*.z=00;31:*.Z=00;31:*.gz
                =00;31:*.bz2=00;31:*.bz=00;31:*.tz=00;31:*.rpm=00;31:*.cpio=00;31:*.jpg=00;35:*.gif=00;35:*.bmp=00;3
                5:*.xbm=00;35:*.xpm=00;35:*.png=00;35:*.tif=00;35:
                MAIL=/var/spool/mail/psadm2
                NLS_LANG=AMERICAN_AMERICA.UTF8
                OLDPWD=/home/psadm2
                ORACLE_BASE=/opt/oracle/psft/pt/oracle-client
                ORACLE_HOME=/opt/oracle/psft/pt/oracle-client/11.2.0.x
                ORACLE_SID=HCM912
                PATH=/opt/oracle/psft/pt/bea/tuxedo/bin:/opt/oracle/psft/pt/tools/jre/bin:/usr/kerberos/bin:/usr/loc
                al/bin:/bin:/usr/bin:/home/psadm2/bin:/opt/oracle/psft/pt/tools/bin:/opt/oracle/psft/pt/tools/bin/sq
                r/ORA/bin:/opt/oracle/psft/pt/tools/verity/linux/_ilnx21/bin:/opt/oracle/psft/pt/oracle-client/11.2.
                0.x/bin:/opt/oracle/psft/pt/tools/setup:/opt/oracle/psft/pt/cobol/svrexp-51_wp4-64bit/bin
                PSJLIBPATH=/opt/oracle/psft/pt/tools/jre/lib/amd64/native_threads:/opt/oracle/psft/pt/tools/jre/lib/
                amd64/server:/opt/oracle/psft/pt/tools/jre/lib/amd64
                PS_APP_HOME=/opt/oracle/psft/pt/apptools
                PS_CFG_HOME=/home/psadm2/psft/pt/8.52
                PS_DB=ORA
                PS_DBVER=8.1.x
                PS_DM_DATA_IN=/opt/oracle/psft/pt/tools/data
                PS_DM_DATA_OUT=/home/psadm2/PS_DM/data
                PS_DM_LOG=/home/psadm2/PS_DM/log
                PS_DM_SCRIPT=/opt/oracle/psft/pt/tools/scripts
                PS_HOME=/opt/oracle/psft/pt/tools
                PS_HOSTTYPE=oel-5-x86_64
                PS_JRE=/opt/oracle/psft/pt/tools/jre
                PS_LIBPATH=/opt/oracle/psft/pt/tools/bin
                PS_SERVDIR=/home/psadm2/PS_CACHE
                PS_SERVER_CFG=/opt/oracle/psft/pt/tools/setup/psdmtx.cfg
                PWD=/home/psadm2
                SHELL=/bin/bash
                SHLVL=1
                SQRDIR=/opt/oracle/psft/pt/tools/bin/sqr/ORA/bin
                SQR_HOME=/opt/oracle/psft/pt/tools/bin/sqr/ORA
                SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass
                TERM=xterm
                TM_GP_AUTOSPAWNEXIT_FIX=yes
                TUXDIR=/opt/oracle/psft/pt/bea/tuxedo
                UMASKULOGPERM=yes
                USER=psadm2
                _=/bin/env
                • 5. Re: ORA-12545 when connecting to default (OK when using SID)
                  sb92075
                  Dennis Lovelady wrote:
                  psadm2@hcm /home/psadm2> hostname
                  hcm

                  psadm2@hcm /home/psadm2> hostname --long
                  hcm.lovelady.com

                  psadm2@hcm /home/psadm2> uname -a
                  Linux hcm 2.6.32-300.39.1.el5uek #1 SMP Wed Nov 7 18:13:56 PST 2012 x86_64 x86_64 x86_64 GNU/Linux

                  psadm2@hcm /home/psadm2> cat /etc/hosts
                  # Do not remove the following line, or various programs
                  # that require network functionality will fail.
                  127.0.0.1 localhost.localdomain localhost
                  ::1 localhost6.localdomain6 localhost6
                  add the line below to /etc/hosts file

                  192.168.0.43 hcm hcm.lovelady.com
                  >
                  psadm2@hcm /home/psadm2> id
                  uid=506(psadm2) gid=505(oracle) groups=505(oracle)
                  You should be logged onto the OS as OS user "oracle" who is in the "dba" OS group
                  • 6. Re: ORA-12545 when connecting to default (OK when using SID)
                    John Spencer
                    In addition to sb's suggestion, you should also look at the setting of your ORACLE_HOME environment variable. Is the database software actually installed under /opt/oracle/psft/pt/oracle-client/11.2.0.x? Based on the location of the parameter file from your lsnrctl status command, I think your ORACLE_HOME needs to be set to /u01/app/oracle/product/11.2.0.x/db_1 to get the bequeath connection you want.

                    John
                    • 7. Re: ORA-12545 when connecting to default (OK when using SID)
                      Dennis Lovelady
                      User oracle can log in - and could before any changes.

                      User psadm2 has the privileges and the environment setup required to operate in the PeopleTools environment. User oracle cannot (at least not without some major rework). I believe these sqr scripts (and the sqr program itself) are intended for user psadm2, but I'd appreciate any pointers regarding the "proper" way to run this.

                      Having said that, I made the suggested change to /etc/hosts. It did not help.

                      # Do not remove the following line, or various programs
                      # that require network functionality will fail.
                      127.0.0.1 localhost.localdomain localhost
                      ::1 localhost6.localdomain6 localhost6
                      192.168.0.43 hcm hcm.lovelady.com
                      • 8. Re: ORA-12545 when connecting to default (OK when using SID)
                        sb92075
                        post content of tnsnames.ora

                        cat $ORACLE_HOME/network/admin/tnsnames.ora

                        post results from OS commands below

                        lsnrctl status
                        lsnrctl service
                        ps -ef | grep -i pmon
                        • 9. Re: ORA-12545 when connecting to default (OK when using SID)
                          Dennis Lovelady
                          Thanks, John.

                          You're onto something here. I had actually followed these instructions: PeopleSoft HCM 9.1 OVM in a single VirtualBox guest machine to create a single-instance installation, and that is surely one overlooked tidbit. (Overlooked by me, of course.)

                          I have now set the ORACLE_HOME and ORACLE_BASE according to user oracle's environment. While it did change the result, it was not the good news I expected. What might cause this?

                          psadm2@hcm /home/psadm2> env|egrep '^ORA|^PS_'
                          PS_DB=ORA
                          PS_DM_LOG=/home/psadm2/PS_DM/log
                          PS_JRE=/opt/oracle/psft/pt/tools/jre
                          PS_LIBPATH=/opt/oracle/psft/pt/tools/bin
                          ORACLE_SID=HCM912
                          ORACLE_BASE=/u01/app/oracle
                          PS_HOSTTYPE=oel-5-x86_64
                          PS_SERVDIR=/home/psadm2/PS_CACHE
                          PS_SERVER_CFG=/opt/oracle/psft/pt/tools/setup/psdmtx.cfg
                          PS_DM_SCRIPT=/opt/oracle/psft/pt/tools/scripts
                          PS_CFG_HOME=/home/psadm2/psft/pt/8.52
                          PS_DBVER=8.1.x
                          PS_APP_HOME=/opt/oracle/psft/pt/apptools
                          PS_DM_DATA_IN=/opt/oracle/psft/pt/tools/data
                          ORACLE_HOME=/u01/app/oracle/product/11.2.0.x/db_1
                          PS_DM_DATA_OUT=/home/psadm2/PS_DM/data
                          PS_HOME=/opt/oracle/psft/pt/tools


                          PS_HOME=/opt/oracle/psft/pt/tools
                          psadm2@hcm /home/psadm2> sqlplus SYSADM
                          SQL*Plus: Release 11.2.0.2.0 Production on Sat Dec 8 07:29:06 2012
                          Copyright (c) 1982, 2010, Oracle. All rights reserved.
                          Enter password:
                          ERROR:
                          ORA-12547: TNS:lost contact
                          Enter user-name: SYSADM@HCM912
                          Enter password:
                          ERROR:
                          ORA-12154: TNS:could not resolve the connect identifier specified



                          psadm2@hcm /home/psadm2> cat $ORACLE_HOME/network/admin/tnsnames.ora
                          HCM912=
                          (DESCRIPTION =
                          (ADDRESS_LIST =
                          (ADDRESS = (PROTOCOL=TCP)(HOST=hcm)(PORT=1521))
                          )
                          (CONNECT_DATA =
                          (SERVICE_NAME = HCM912)
                          )
                          )


                          psadm2@hcm /home/psadm2> lsnrctl status
                          LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 08-DEC-2012 11:45:08
                          Copyright (c) 1991, 2010, Oracle. All rights reserved.
                          Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=hcm)(PORT=1521)))
                          STATUS of the LISTENER
                          ------------------------
                          Alias LISTENER
                          Version TNSLSNR for Linux: Version 11.2.0.2.0 - Production
                          Start Date 02-DEC-2012 08:13:48
                          Uptime 6 days 3 hr. 31 min. 20 sec
                          Trace Level off
                          Security ON: Local OS Authentication
                          SNMP OFF
                          Listener Parameter File /u01/app/oracle/product/11.2.0.x/db_1/network/admin/listener.ora
                          Listener Log File /u01/app/oracle/product/11.2.0.x/db_1/log/diag/tnslsnr/hcm/listener/alert/log.xml
                          Listening Endpoints Summary...
                          (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=hcm)(PORT=1521)))
                          (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
                          Services Summary...
                          Service "HCM912" has 1 instance(s).
                          Instance "HCM912", status READY, has 1 handler(s) for this service...
                          Service "XDB" has 1 instance(s).
                          Instance "HCM912", status READY, has 1 handler(s) for this service...
                          The command completed successfully


                          psadm2@hcm /home/psadm2> lsnrctl service
                          LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 08-DEC-2012 11:45:35
                          Copyright (c) 1991, 2010, Oracle. All rights reserved.
                          Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=hcm)(PORT=1521)))
                          Services Summary...
                          Service "HCM912" has 1 instance(s).
                          Instance "HCM912", status READY, has 1 handler(s) for this service...
                          Handler(s):
                          "DEDICATED" established:87 refused:0 state:ready
                          LOCAL SERVER
                          Service "XDB" has 1 instance(s).
                          Instance "HCM912", status READY, has 1 handler(s) for this service...
                          Handler(s):
                          "D000" established:0 refused:0 current:0 max:1022 state:ready
                          DISPATCHER <machine: hcm, pid: 3553>
                          (ADDRESS=(PROTOCOL=tcp)(HOST=hcm)(PORT=31492))
                          The command completed successfully

                          psadm2@hcm /home/psadm2> ps -ef | grep -i pmon
                          oracle 3491 1 0 Dec02 ? 00:00:48 ora_pmon_HCM912
                          psadm2 30547 28771 0 11:46 pts/1 00:00:00 grep -i pmon
                          • 10. Re: ORA-12545 when connecting to default (OK when using SID)
                            sb92075
                            It appears that you have at least 2 ORACLE_HOME directories


                            ORA-12154 ALWAYS only occurs on SQL Client & no SQL*Net packets ever leave client system
                            ORA-12154 NEVER involves the listener, the database itself or anything on the DB Server.
                            ORA-12154 occurs when client requests a connection to some DB server system using some connection string.
                            TNS-03505 is thrown by tnsping & is same error as ORA-12154 thrown by sqlplus or others.
                            The lookup operation fails because the name provided can NOT be resolved to any remote DB.
                            The analogous operation would be when you wanted to call somebody, but could not find their name in any phonebook.
                            The most frequent cause for the ORA-12154 error is when the connection alias can not be found in tnsnames.ora.
                            The lookup operation of the alias can be impacted by the contents of the sqlnet.ora file; specifically DOMAIN entry.
                            TROUBLESHOOTING GUIDE: ORA-12154 & TNS-12154 TNS:could not resolve service name [ID 114085.1]
                            http://edstevensdba.wordpress.com/2011/02/26/ora-12154tns-03505/

                            find / -name tnsnames.ora

                            post results from OS command above
                            • 11. Re: ORA-12545 when connecting to default (OK when using SID)
                              Dennis Lovelady
                              @sb92075, You do realize this is about error ORA-12545, and not ORA-012154 and not TNS-03505, right?

                              root@hcm /root # find / -name tnsnames.ora
                              /etc/tnsnames.ora
                              /opt/oracle/psft/vm/tnsnames.ora
                              /opt/oracle/psft/vm-hcm/tnsnames.ora
                              /opt/oracle/psft/pt/oracle-client/11.2.0.x/network/admin/samples/tnsnames.ora
                              /u01/scripts/config/tnsnames.ora
                              /u01/app/oracle/product/11.2.0.x/db_1/network/admin/samples/tnsnames.ora
                              /u01/app/oracle/product/11.2.0.x/db_1/network/admin/tnsnames.ora
                              root@hcm /root # vi /etc/tnsnames.ora
                              • 12. Re: ORA-12545 when connecting to default (OK when using SID)
                                Srini Chavali-Oracle
                                Not sure if there are any special considerations/idiosyncracies for a Peoplesoft install, but pl see if this MOS Doc can help

                                Troubleshooting ORA-12545 / TNS-12545 Connect failed because target host or object does not exist [ID 553328.1]

                                HTH
                                Srini
                                • 13. Re: ORA-12545 when connecting to default (OK when using SID)
                                  Dennis Lovelady
                                  Thank you for your reply. I know before sending that I possibly should know this, but I don't: Can you help me understand what an MOS Doc is, and how I might find it?

                                  Thanks!
                                  • 14. Re: ORA-12545 when connecting to default (OK when using SID)
                                    Srini Chavali-Oracle
                                    MOS = My Oracle Support at https://support.oracle.com - the support website for Oracle customers who have a paid support contract with Oracle.

                                    If you have access to this website, search for this document and it will walk you thru a series of troubleshooting steps

                                    HTH
                                    Srini
                                    1 2 Previous Next