This discussion is archived
1 2 Previous Next 16 Replies Latest reply: Nov 29, 2012 2:00 AM by 976940 RSS

ORA-12547: TNS:lost contact

959603 Newbie
Currently Being Moderated
Hi,
I'm installing oracle database instance for the asm ,but when i run dbca , I got the following erro:

+$ dbca -silent -responseFile /U01/installer/database/response/trainee_dbca.rsp+
Enter SYS user password:
Enter SYSTEM user password:
Look at the log file "/U01/app/oracle/cfgtoollogs/dbca/orcl11g9.log" for further details.

+$ cat /U01/app/oracle/cfgtoollogs/dbca/orcl11g9.log+
Could not connect to ASM due to following error:
ORA-12547: TNS:lost contact

The dbca.rsp:
+[GENERAL]+
RESPONSEFILE_VERSION = "11.2.0"
OPERATION_TYPE = "createDatabase"
+[CREATEDATABASE]+
GDBNAME = "orcl11g.us.oracle.com"
SID = "trainee"
TEMPLATENAME = "General_Purpose.dbc"
STORAGETYPE = "ASM"
DISKGROUPNAME=VOL1
CHARACTERSET = "ZHS16GBK"
NATIONALCHARACTERSET= "UTF8"
AUTOMATICMEMORYMANAGEMENT = "TRUE"


thanks
  • 1. Re: ORA-12547: TNS:lost contact
    450155 Explorer
    Currently Being Moderated
    Did you check whether the ASM instance is up and all diskgroup are mounted. Check the load on the server.
  • 2. Re: ORA-12547: TNS:lost contact
    onedbguru Pro
    Currently Being Moderated
    is this RAC or Standalone?

    I do not know what some of you are doing where you think you need to manually create ASM in 11gR2. I have installed LOTS of 11gR2 RAC and Stand-alone ASM, and I have never had to manually create ASM. The installer does all of the setup, then the root.sh actually starts it. How did you install the software?

    If you are using Linux you can use VNC (it is included in MOST Linux distros.) Using VNC (vncserver -geometry 1280x1024 ) and on desktop vncviewer - this allows you to do the install on "the console" such that should your client get disconnected, the install is still running. I also use this for long-running operations where I know it will be running overnight. I can logoff and reconnect to VNC in the morning and see what is the status.
  • 3. Re: ORA-12547: TNS:lost contact
    450155 Explorer
    Currently Being Moderated
    And I don't see where anyone in this post said ASM should be created manually.

    Regards,
    ST
  • 4. Re: ORA-12547: TNS:lost contact
    onedbguru Pro
    Currently Being Moderated
    Really???

    His first sentence is:
    I'm installing oracle database instance for the asm ,but when i run dbca , I got the following erro:
    Again, the Grid (RAC and STANDALONE) installer creates the ASM instance automagically. Why is he trying to create it by using dbca - if the installation was done correctly he would not be doing this.
  • 5. Re: ORA-12547: TNS:lost contact
    450155 Explorer
    Currently Being Moderated
    Well done.

    What I understand in his post is that he is trying to create a database on ASM (probably he got an type error there)

    1) DB name is not a ASM instance specification or type (So I believe that it is DB configuration)
    2) secondly there is definition for STORAGE type and DISKGROUP Name specified in the dbca response file.
    3) The error message shows that dbca is not able to connect to the ASM instance.

    By these consideration I said to check him whether the ASM instance is configured correctly and the diskgroup is mounted for creating the database.

    I hope I am not wrong :)

    Regards,
    ST
  • 6. Re: ORA-12547: TNS:lost contact
    959603 Newbie
    Currently Being Moderated
    to ST:
    just like you said: 1),2),3)
    The error message shows that dbca is not able to connect to the ASM instance.

    to all:
    SQL> select NAME,STATE,TYPE,VOTING_FILES from v$asm_diskgroup;

    NAME STATE TYPE VOT
    --------------------------------------------------------------------------------
    DATA MOUNTED NORMAL N

    SQL> select INSTANCE_NAME,HOST_NAME,status,DATABASE_STATUS,ACTIVE_STATE from v$instance;

    INSTANCE_NAME HOST_NAME STATUS DATABASE_STATUS ACTIVE_STATE
    --------------------------------------------------- ---------------------------
    +ASM                  trainee_asm_ip     STARTED          ACTIVE                 NORMAL

    ASM instance's tnsnames.ora:

    LISTENER_ASM =+
    +(ADDRESS = (PROTOCOL = TCP)(HOST = trainee_asm_ip)(PORT = 1522))+

    ASM's listener.ora:
    LISTENER =
    +(DESCRIPTION_LIST =+
    +(DESCRIPTION =+
    +(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1522))+
    +(ADDRESS = (PROTOCOL = TCP)(HOST = trainee_asm_ip)(PORT = 1522))+
    +)+
    +)+
    ADR_BASE_LISTENER = /U01/app/oracle
    ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON              # line added by Agent

    DB's tnsnames.ora and listener.ora is null

    thanks
  • 7. Re: ORA-12547: TNS:lost contact
    959603 Newbie
    Currently Being Moderated
    it's Standalone
  • 8. Re: ORA-12547: TNS:lost contact
    585179 Expert
    Currently Being Moderated
    956600 wrote:

    NAME STATE TYPE VOT
    --------------------------------------------------------------------------------
    DATA MOUNTED NORMAL N

    thanks
    Hi,

    First of all your output above shows your diskgroup is DATA but in your template you defined 'VOL1'

    Second run

    $ > ls -al $GRID_HOME/bin/oracle
    $ > ls -al $ORACLE_HOME/bin/oracle

    if it is not showing '-rwsr-s--x' then change it by running

    cd $GRID_HOME/bin
    chmod 6751 oracle
    cd $ORACLE_HOME/bin
    chmod 6751 oracle


    Hope it helps


    Cheers
  • 9. Re: ORA-12547: TNS:lost contact
    959603 Newbie
    Currently Being Moderated
    sorry , i've reinstall asm for many times....
    now the diskgroup is DATA.

    in $ORACLE_HOME/bin :
    # ll | egrep -i 'root|asm'
    -rwsr-x--- 1 root oinstall 1098750 Sep 4 14:17 extjob
    -rwsr-x--- 1 root oinstall 32378 Sep 4 14:17 jssu
    -rws--x--- 1 root oinstall 28122 Sep 4 14:17 nmb
    -rws--x--- 1 root oinstall 80384 Sep 4 14:17 nmhs
    -rws--x--- 1 root oinstall 34710 Sep 4 14:17 nmo
    -rwsr-x--- 1 root oinstall 76418 Sep 18 2011 oradism

    # ll oracle
    -rwsr-s--x 1 oracle asmadmin 192296337 Sep 4 14:18 oracle
    # chown oracle:oinstall oracle
    # ll oracle
    -rwxr-x--x 1 oracle oinstall 192296337 Sep 4 14:18 oracle

    i'll try again

    thanks
  • 10. Re: ORA-12547: TNS:lost contact
    450155 Explorer
    Currently Being Moderated
    Hi,


    Check what is the output of

    1) lsnrctl status
    2) lsnrctl services

    Regards,
    ST
  • 11. Re: ORA-12547: TNS:lost contact
    959603 Newbie
    Currently Being Moderated
    oracle version is 11.2.0.3

    for asm :
    LSNRCTL> status
    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1522)))
    STATUS of the LISTENER
    ------------------------
    Alias LISTENER
    Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production
    Start Date 04-SEP-2012 13:20:02
    Uptime 0 days 0 hr. 10 min. 58 sec
    Trace Level off
    Security ON: Local OS Authentication
    SNMP OFF
    Listener Parameter File /U01/app/oracle/product/11.2.3/grid/network/admin/listener.ora
    Listener Log File /U01/app/oracle/diag/tnslsnr/trainee_asm_10/listener/alert/log.xml
    Listening Endpoints Summary...
    (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1522)))
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=trainee_asm_ip)(PORT=1522)))
    Services Summary...
    Service "+ASM" has 1 instance(s).
    Instance "+ASM", status READY, has 1 handler(s) for this service...
    The command completed successfully


    for DB instance:
    LSNRCTL> status
    Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
    STATUS of the LISTENER
    ------------------------
    Alias LISTENER
    Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production
    Start Date 04-SEP-2012 14:27:02
    Uptime 0 days 0 hr. 0 min. 1 sec
    Trace Level off
    Security ON: Local OS Authentication
    SNMP OFF
    Listener Log File /U01/app/oracle/diag/tnslsnr/trainee_asm_10/listener/alert/log.xml
    Listening Endpoints Summary...
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=trainee_asm_10.11.54.223)(PORT=1521)))
    The listener supports no services
    The command completed successfully

    and , the os has been reinstalled.........thank you very much,
    i'll do it in the VMware to resolve the problem
  • 12. Re: ORA-12547: TNS:lost contact
    450155 Explorer
    Currently Being Moderated
    Hi,

    In an oracle restart or RAC configuration usually only the grid listener will be configured. so configure only one listener on the grid home on 1521 you installation will be successful.

    Regards,
    ST
  • 13. Re: ORA-12547: TNS:lost contact
    959603 Newbie
    Currently Being Moderated
    Hi, ST,
    i want to find some documents about asm &how to install asm , but i haven't find it.........

    thanks
  • 14. Re: ORA-12547: TNS:lost contact
    585179 Expert
    Currently Being Moderated
    956600 wrote:
    Hi, ST,
    i want to find some documents about asm &how to install asm , but i haven't find it.........
    Hi,

    Its all documented here http://docs.oracle.com/cd/E11882_01/install.112/e22489/toc.htm


    Cheers
1 2 Previous Next

Legend

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