This discussion is archived
1 2 3 4 5 6 Previous Next 79 Replies Latest reply: Mar 13, 2013 8:36 AM by EdStevens Go to original post RSS
  • 30. Re: Cant connect my database using net service_name
    sb92075 Guru
    Currently Being Moderated
    969352 wrote:
    ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
    edit file /u01/app/oracle/product/10.2.0/db_1/network/log/listener_orcl.log

    find records that contain the value "12514"

    post back here the records that contain value "12514" & a few records above & below the records containing "12514"
  • 31. Re: Cant connect my database using net service_name
    TSharma-Oracle Guru
    Currently Being Moderated
    can you connect to your second (orclprod) using network service ?
  • 32. Re: Cant connect my database using net service_name
    972355 Newbie
    Currently Being Moderated
    Are you able to connect to your second instance using network service ?
    This is another database >>
    $ sqlplus /nolog

    SQL*Plus: Release 10.2.0.1.0 - Production on Sat Mar 9 21:07:33 2013

    Copyright (c) 1982, 2005, Oracle. All rights reserved.

    SQL> conn u2/u2@ORCLMYPROD
    Connected.

    SQL> show user;
    USER is "U2"
    SQL> startup
    ORA-01031: insufficient privileges

    NOTE : but u2 having sysdba privilege.
  • 33. Re: Cant connect my database using net service_name
    972355 Newbie
    Currently Being Moderated
    find records that contain the value "12514"

    post back here the records that contain value "12514" & a few records above & below the records containing "12514"

    - I am checking.

    09-MAR-2013 20:24:01 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=linuxserver)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=(ADDRESS=(PROTOCOL=TCP)(HOST=linuxserver)(PORT=1521)))(VERSION=169869568)) * status * 0
    09-MAR-2013 20:24:13 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcltest)(CID=(PROGRAM=sqlplus)(HOST=linuxserver)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=36543)) * establish * orcltest * 12514
    TNS-12514: TNS:listener does not currently know of service requested in connect descriptor


    Thanks sb ..
  • 34. Re: Cant connect my database using net service_name
    972355 Newbie
    Currently Being Moderated
    Hello Experts ;

    None .. I will continue ..
  • 35. Re: Cant connect my database using net service_name
    sb92075 Guru
    Currently Being Moderated
    post results of following OS commands


    uname -a
    hostname
    cat /etc/hosts
    ping linuxserver

    COPY the results from above then PASTE all back here
  • 36. Re: Cant connect my database using net service_name
    972355 Newbie
    Currently Being Moderated
    *$ uname -a*
    Linux linuxserver 2.6.9-42.0.0.0.1.ELsmp #1 SMP Sun Oct 15 14:02:40 PDT 2006 i686 athlon i386 GNU/Linux

    *[oracle@linuxserver ~]$ cat /etc/hosts*
    # Do not remove the following line, or various programs
    # that require network functionality will fail.
    127.0.0.1 linuxserver localhost.localdomain localhost

    *[oracle@linuxserver ~]$ ping linuxserver*
    PING linuxserver (127.0.0.1) 56(84) bytes of data.
    64 bytes from linuxserver (127.0.0.1): icmp_seq=0 ttl=64 time=0.103 ms
    64 bytes from linuxserver (127.0.0.1): icmp_seq=1 ttl=64 time=0.044 ms
    64 bytes from linuxserver (127.0.0.1): icmp_seq=2 ttl=64 time=0.023 ms
    64 bytes from linuxserver (127.0.0.1): icmp_seq=3 ttl=64 time=0.024 ms
    64 bytes from linuxserver (127.0.0.1): icmp_seq=4 ttl=64 time=0.063 ms
    64 bytes from linuxserver (127.0.0.1): icmp_seq=5 ttl=64 time=0.024 ms
    64 bytes from linuxserver (127.0.0.1): icmp_seq=6 ttl=64 time=0.024 ms
    64 bytes from linuxserver (127.0.0.1): icmp_seq=7 ttl=64 time=0.070 ms
    64 bytes from linuxserver (127.0.0.1): icmp_seq=8 ttl=64 time=0.023 ms
    64 bytes from linuxserver (127.0.0.1): icmp_seq=9 ttl=64 time=0.024 ms
    64 bytes from linuxserver (127.0.0.1): icmp_seq=10 ttl=64 time=0.024 ms
    64 bytes from linuxserver (127.0.0.1): icmp_seq=11 ttl=64 time=0.025 ms
    64 bytes from linuxserver (127.0.0.1): icmp_seq=12 ttl=64 time=0.025 ms
    64 bytes from linuxserver (127.0.0.1): icmp_seq=13 ttl=64 time=0.025 ms
    64 bytes from linuxserver (127.0.0.1): icmp_seq=14 ttl=64 time=0.020 ms
    64 bytes from linuxserver (127.0.0.1): icmp_seq=15 ttl=64 time=0.024 ms
    64 bytes from linuxserver (127.0.0.1): icmp_seq=16 ttl=64 time=0.023 ms
    64 bytes from linuxserver (127.0.0.1): icmp_seq=17 ttl=64 time=0.061 ms
    64 bytes from linuxserver (127.0.0.1): icmp_seq=18 ttl=64 time=0.023 ms
    64 bytes from linuxserver (127.0.0.1): icmp_seq=19 ttl=64 time=0.024
  • 37. Re: Cant connect my database using net service_name
    sb92075 Guru
    Currently Being Moderated
    969352 wrote:
    *$ uname -a*
    Linux linuxserver 2.6.9-42.0.0.0.1.ELsmp #1 SMP Sun Oct 15 14:02:40 PDT 2006 i686 athlon i386 GNU/Linux

    *[oracle@linuxserver ~]$ cat /etc/hosts*
    # Do not remove the following line, or various programs
    # that require network functionality will fail.
    127.0.0.1 linuxserver localhost.localdomain localhost
    just FYI - no remote client can ever connect to DB Server using 127.0.0.1

    post results from OS command below

    ps -ef | grep lsnr
  • 38. Re: Cant connect my database using net service_name
    972355 Newbie
    Currently Being Moderated
    Hello Sb;

    Already you mentioned , i am using unsupported version.

    - I don't know what's the exact problem from my database.
    May i update my database [ applying patch ] ? >>
  • 39. Re: Cant connect my database using net service_name
    972355 Newbie
    Currently Being Moderated
    just FYI - no remote client can ever connect to DB Server using 127.0.0.1

    post results from OS command below

    ps -ef | grep lsnr

    *[oracle@linuxserver ~]$ ps -ef | grep lsnr*
    oracle 11696 1 0 16:31 ? 00:00:00 /u01/app/oracle/product/10.2.0/db_1/bin/tnslsnr LISTener_ORcl -inherit
    oracle 4666 22992 0 21:37 pts/4 00:00:00 grep lsnr
  • 40. Re: Cant connect my database using net service_name
    972355 Newbie
    Currently Being Moderated
    just FYI - no remote client can ever connect to DB Server using 127.0.0.1

    I did n't set ip in /etc/hosts file.

    Can i  update ip address  in that file ?
  • 41. Re: Cant connect my database using net service_name
    sb92075 Guru
    Currently Being Moderated
    969352 wrote:
    just FYI - no remote client can ever connect to DB Server using 127.0.0.1

    I did n't set ip in /etc/hosts file.

    Can i  update ip address  in that file ?
    For now, there is no need to change /etc/host file. It can only be done by OS root user.

    It bothers me that the tnsnames.ora file specifies SERVICE_NAME while listener.ora specifies SID.
    IMO, both should use the same; either both use SID or both use SERVICE_NAME.
  • 42. Re: Cant connect my database using net service_name
    972355 Newbie
    Currently Being Moderated
    I will change (what you mentioned in your reply ).

    Sure - I will com back  tomorrow.  I will take deep look  and come back.

    Thanks sb for kind help ;
  • 43. Re: Cant connect my database using net service_name
    972355 Newbie
    Currently Being Moderated
    Good Morning to all ;
    It bothers me that the tnsnames.ora file specifies SERVICE_NAME while listener.ora specifies SID.
    IMO, both should use the same; either both use SID or both use SERVICE_NAM
    - I am very sorry for disturbing  sb AS per your suggestion i changed both name as MYDB.TEST.ORCLTEST.COM ( listener.ora ,tnsnames.ora)

    Could you please guide me how can i connect my DB ?

    Still i am trying but i can't succeed but i hope to solve my problem.

    Thanks ..
  • 44. Re: Cant connect my database using net service_name
    sb92075 Guru
    Currently Being Moderated
    Humor me & do the following steps because the listener will start & run when no listener.ora file exists

    cd /u01/app/oracle/product/10.2.0/db_1/network/admin/
    mv listener.ora listsner.ora.sav

    Above saves the original listener.ora with a new & different name.

    now reboot the system
    restart Oracle DB & the listener & wait 60+ seconds then issue OS commands below

    lsnrctl status
    lsnrctl service

    COPY the results from above then PASTE all back here

Legend

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