This discussion is archived
1 2 Previous Next 19 Replies Latest reply: Dec 11, 2012 7:33 PM by 971118 RSS

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

971118 Newbie
Currently Being Moderated
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 Oracle ACE
    Currently Being Moderated
    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)
    971118 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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)
    971118 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Oracle ACE
    Currently Being Moderated
    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)
    971118 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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)
    971118 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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)
    971118 Newbie
    Currently Being Moderated
    @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 Oracle ACE Director
    Currently Being Moderated
    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)
    971118 Newbie
    Currently Being Moderated
    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 Oracle ACE Director
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points