This discussion is archived
1 2 Previous Next 25 Replies Latest reply: Dec 20, 2012 2:07 AM by 970402 RSS

" ORA-03114: not connected to ORACLE " error with Oracle DB installation

970402 Newbie
Currently Being Moderated
Hi All,

I am getting "ORA-03114: not connected to ORACLE" while installing "Oracle Database 11GR2" on "Oracle RAC 11R2" cluster setup. I am getting this error at the time of "Oracle Database Configuration Assistant" configuration reaches till 39% on HP-UX 11.31 IA64 platform. Please let me know if any one of you aware of this type of issue.

-Ashish
  • 1. Re: " ORA-03114: not connected to ORACLE " error with Oracle DB installation
    nnarimanov Newbie
    Currently Being Moderated
    Is there enough tmp, swap space? Pls provide mode info from installation log
  • 2. Re: " ORA-03114: not connected to ORACLE " error with Oracle DB installation
    970402 Newbie
    Currently Being Moderated
    Hi i am new to Oracle, could you please clarify exactly what logs you need ... i'll paste it for your ref.

    What do you mean by "mode info from installation log" ?

    /dev/vg00/lvol5 5128192 920872 4175448 18% /tmp

    bash-4.2# /usr/sbin/swapinfo -a
    Kb Kb Kb PCT START/ Kb
    TYPE AVAIL USED FREE USED LIMIT RESERVE PRI NAME
    dev 8388608 0 8388608 0% 0 - 1 /dev/vg00/lvol2
    reserve - 2869392 -2869392
    memory 15851192 3883180 11968012 24%

    Thanks.
  • 3. Re: " ORA-03114: not connected to ORACLE " error with Oracle DB installation
    nnarimanov Newbie
    Currently Being Moderated
    OUI (Oracle Universal Installer) shows current log file during installation. Please refer to this log
  • 4. Re: " ORA-03114: not connected to ORACLE " error with Oracle DB installation
    71617 Newbie
    Currently Being Moderated
    hi,

    Are you try to install a stay-alone database or Oracle RAC? Are you using ASM or HPUX file system?

    -KC
  • 5. Re: " ORA-03114: not connected to ORACLE " error with Oracle DB installation
    970402 Newbie
    Currently Being Moderated
    It's a Oracle RAC cluster setup with ASM on HP-UX file system.
  • 6. Re: " ORA-03114: not connected to ORACLE " error with Oracle DB installation
    71617 Newbie
    Currently Being Moderated
    hi,

    Please make sure your ASM+ is running without problem. If problem not on ASM, it probably on your network preparation.
    your cluster SCAN address should be configured through DNS to resolve to 3 IP addresses. Please check your installation log.

    before start installation:
    1. You should be able to ping node1, node2, node1-ic, node2-ic
    2. You should NOT able to ping node1-vip, node2-vip, and scan-vip
    3. You should be able to resolve the IP (/etc/hosts or DNS) for node1-vip, node2-vip, and scan-vip.

    -KC
  • 7. Re: " ORA-03114: not connected to ORACLE " error with Oracle DB installation
    LaserSoft Journeyer
    Currently Being Moderated
    Hi

    If you have metalink support, there is a step by step installation document for Oracle 11g R2 RAC for HP_UX. Please refer the below DOC ID.

    "RAC and Oracle Clusterware Best Practices and Starter Kit (HP-UX) [ID 811303.1]"

    Thanks
    LaserSoft
  • 8. Re: " ORA-03114: not connected to ORACLE " error with Oracle DB installation
    970402 Newbie
    Currently Being Moderated
    Hi Chen,

    ASM is configured & up-n-running. I have two nodes lclc148 & lclc150 see the below output,

    Here i have created two ASM DG's "DATA" for grid & "ORA_DATA" for oracle database.

    lclc148$ srvctl status asm
    ASM is running on lclc148,lclc150

    =================================

    lclc148$ srvctl status diskgroup -g DATA
    Disk Group DATA is running on lclc148,lclc150

    lclc148$ srvctl status diskgroup -g ORA_DATA
    Disk Group ORA_DATA is running on lclc148,lclc150

    =================================

    lclc150$ lsnrctl status

    LSNRCTL for HPUX: Version 11.2.0.1.0 - Production on 07-DEC-2012 11:10:38

    Copyright (c) 1991, 2009, Oracle. All rights reserved.

    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
    STATUS of the LISTENER
    ------------------------
    Alias LISTENER
    Version TNSLSNR for HPUX: Version 11.2.0.1.0 - Production
    Start Date 07-DEC-2012 10:03:43
    Uptime 0 days 1 hr. 6 min. 55 sec
    Trace Level off
    Security ON: Local OS Authentication
    SNMP OFF
    Listener Parameter File /var/RAC/11.2.0/grid/network/admin/listener.ora
    Listener Log File /var/RAC/grid/diag/tnslsnr/lclc150/listener/alert/log.xml
    Listening Endpoints Summary...
    (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.155.222)(PORT=1521)))
    Services Summary...
    Service "+ASM" has 1 instance(s).
    Instance "+ASM1", status READY, has 1 handler(s) for this service...
    The command completed successfully

    ======================

    lclc148$ lsnrctl status

    LSNRCTL for HPUX: Version 11.2.0.1.0 - Production on 07-DEC-2012 11:00:35

    Copyright (c) 1991, 2009, Oracle. All rights reserved.

    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
    STATUS of the LISTENER
    ------------------------
    Alias LISTENER
    Version TNSLSNR for HPUX: Version 11.2.0.1.0 - Production
    Start Date 07-DEC-2012 10:16:48
    Uptime 0 days 0 hr. 43 min. 47 sec
    Trace Level off
    Security ON: Local OS Authentication
    SNMP OFF
    Listener Parameter File /var/RAC/11.2.0/grid/network/admin/listener.ora
    Listener Log File /var/RAC/grid/diag/tnslsnr/lclc148/listener/alert/log.xml
    Listening Endpoints Summary...
    (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.155.221)(PORT=1521)))
    Services Summary...
    Service "+ASM" has 1 instance(s).
    Instance "+ASM2", status READY, has 1 handler(s) for this service...
    The command completed successfully

    =================================

    lclc148$ srvctl status vip -n lclc148
    VIP lclc148-vip is enabled
    VIP lclc148-vip is running on node: lclc148

    lclc148$ srvctl status vip -n lclc150
    VIP lclc150-vip is enabled
    VIP lclc150-vip is running on node: lclc150

    =================================

    lclc148$ crsctl check cluster -all
    **************************************************************
    lclc148:
    CRS-4537: Cluster Ready Services is online
    CRS-4529: Cluster Synchronization Services is online
    CRS-4533: Event Manager is online
    **************************************************************
    lclc150:
    CRS-4537: Cluster Ready Services is online
    CRS-4529: Cluster Synchronization Services is online
    CRS-4533: Event Manager is online
    **************************************************************


    Also i am able to ping and resolve all the IP's, VIP's & Private IP's using "/etc/hosts" file as below;

    ===============================================

    127.0.0.1 lclc148.lss.emc.com lclc148 localhost.localdomain localhost

    # Public
    xxx.xxx.xxx.148 lclc148.lss.emc.com lclc148
    xxx.xxx.xxx.150 lclc150.lss.emc.com lclc150

    # Private
    80.0.0.1 lclc148-priv.lss.emc.com lclc148-priv
    80.0.0.2 lclc150-priv.lss.emc.com lclc150-priv

    # Virtual
    xxx.xxx.xxx.221 lclc148-vip.lss.emc.com lclc148-vip
    xxx.xxx.xxx.222 lclc150-vip.lss.emc.com lclc150-vip

    # SCAN
    xxx.xxx.xxx.225 lclc-scan.lss.emc.com lclc-scan
    xxx.xxx.xxx.226 lclc-scan.lss.emc.com lclc-scan
    xxx.xxx.xxx.227 lclc-scan.lss.emc.com lclc-scan

    ===============================================

    I am not sure if the loopback entry in hosts file is correct as shown below !

    127.0.0.1 lclc148.lss.emc.com lclc148 localhost.localdomain localhost

    Let me know if you need to checkout some more log or output from these nodes. :)


    -Thanks
  • 9. Re: " ORA-03114: not connected to ORACLE " error with Oracle DB installation
    970402 Newbie
    Currently Being Moderated
    Hi LaserSoft,

    I don't have metalink support could you please send me this document on my personal email ID ? It's just a testing purpose we have to setup Oracle RAC.

    -Ashish
  • 10. Re: " ORA-03114: not connected to ORACLE " error with Oracle DB installation
    970402 Newbie
    Currently Being Moderated
    Adding,

    bash-4.2$ crsctl stat resource -t
    --------------------------------------------------------------------------------
    NAME TARGET STATE SERVER STATE_DETAILS
    --------------------------------------------------------------------------------
    Local Resources
    --------------------------------------------------------------------------------
    ora.DATA.dg
    ONLINE ONLINE lclc148
    ONLINE ONLINE lclc150
    ora.LISTENER.lsnr
    ONLINE ONLINE lclc148
    ONLINE ONLINE lclc150
    ora.ORA_DATA.dg
    ONLINE ONLINE lclc148
    ONLINE ONLINE lclc150
    ora.asm
    ONLINE ONLINE lclc148 Started
    ONLINE ONLINE lclc150 Started
    ora.eons
    ONLINE ONLINE lclc148
    ONLINE ONLINE lclc150
    ora.gsd
    OFFLINE OFFLINE lclc148
    OFFLINE OFFLINE lclc150
    ora.net1.network
    ONLINE ONLINE lclc148
    ONLINE ONLINE lclc150
    ora.ons
    ONLINE ONLINE lclc148
    ONLINE ONLINE lclc150
    --------------------------------------------------------------------------------
    Cluster Resources
    --------------------------------------------------------------------------------
    ora.LISTENER_SCAN1.lsnr
    1 ONLINE ONLINE lclc148
    ora.LISTENER_SCAN2.lsnr
    1 ONLINE ONLINE lclc150
    ora.LISTENER_SCAN3.lsnr
    1 ONLINE ONLINE lclc150
    ora.lclc148.vip
    1 ONLINE ONLINE lclc148
    ora.lclc150.vip
    1 ONLINE ONLINE lclc150
    ora.oc4j
    1 OFFLINE OFFLINE
    ora.scan1.vip
    1 ONLINE ONLINE lclc148
    ora.scan2.vip
    1 ONLINE ONLINE lclc150
    ora.scan3.vip
    1 ONLINE ONLINE lclc150


    as well.
  • 11. Re: " ORA-03114: not connected to ORACLE " error with Oracle DB installation
    970402 Newbie
    Currently Being Moderated
    While creating & configuring new database using "dbca" i am getting some errors in "/var/RAC/oracle/cfgtoollogs/dbca/odb/trace.log" file,

    ================================================

    [Thread-331] [ 2012-12-07 13:12:14.937 IST ] [StepContext$ModeRunner.run:2657] ---- Progress Needed:=true
    [Thread-331] [ 2012-12-07 13:12:14.942 IST ] [BasicStep.execute:202] Executing Step : CLONE_DB_CREATION
    [Thread-331] [ 2012-12-07 13:12:14.942 IST ] [StepErrorHandler.setFatalErrors:322] setting Fatal Error: ORA-01503
    [Thread-331] [ 2012-12-07 13:12:14.942 IST ] [StepErrorHandler.setFatalErrors:322] setting Fatal Error: ORA-01034
    [Thread-331] [ 2012-12-07 13:12:14.943 IST ] [StepErrorHandler.setFatalErrors:322] setting Fatal Error: ORA-01092
    [Thread-331] [ 2012-12-07 13:12:14.943 IST ] [StepErrorHandler.setFatalErrors:322] setting Fatal Error: ORA-03113
    [Thread-331] [ 2012-12-07 13:12:14.943 IST ] [StepErrorHandler.setFatalErrors:322] setting Fatal Error: ORA-03114
    [Thread-331] [ 2012-12-07 13:12:14.943 IST ] [StepErrorHandler.setIgnorableErrors:250] setting Ignorable Error: ORA-01109
    [Thread-331] [ 2012-12-07 13:12:14.943 IST ] [StepErrorHandler.setIgnorableErrors:250] setting Ignorable Error: ORA-12712
    [Thread-331] [ 2012-12-07 13:12:14.943 IST ] [StepErrorHandler.setIgnorableErrors:250] setting Ignorable Error: ORA-00942
    [Thread-331] [ 2012-12-07 13:12:14.944 IST ] [StepErrorHandler.setIgnorableErrors:250] setting Ignorable Error: ORA-04043
    [Thread-331] [ 2012-12-07 13:12:14.944 IST ] [StepErrorHandler.setIgnorableErrors:250] setting Ignorable Error: ORA-44304
    [Thread-331] [ 2012-12-07 13:12:14.944 IST ] [StepErrorHandler.setIgnorableErrors:250] setting Ignorable Error: ORA-44305
    [Thread-331] [ 2012-12-07 13:12:14.944 IST ] [StepErrorHandler.setIgnorableErrors:250] setting Ignorable Error: ORA-06512
    [Thread-331] [ 2012-12-07 13:12:14.944 IST ] [StepErrorHandler.setIgnorableErrors:250] setting Ignorable Error: ORA-06510
    [Thread-331] [ 2012-12-07 13:12:14.944 IST ] [StepErrorHandler.setIgnorableErrors:250] setting Ignorable Error: ORA-01403
    [Thread-331] [ 2012-12-07 13:12:14.945 IST ] [BasicStep.configureSettings:304] messageHandler being set=oracle.sysman.assistants.util.UIMessageHandler@59d794d
    [Thread-460] [ 2012-12-07 14:05:48.227 IST ] [SQLEngine.done:2167] Done called
    [AWT-EventQueue-0] [ 2012-12-07 14:05:59.562 IST ] [DBCAWizard.onFinish:1134] m_bFinishClicked: false
    [TaskScheduler timer] [ 2012-12-07 14:05:59.566 IST ] [OCRTree.init:214] calling OCRTree.init
    [TaskScheduler timer] [ 2012-12-07 14:05:59.566 IST ] [OCRTree.isDatabaseConfigured:691] Acquiring shared CSS lock SRVM.DATABASE.DATABASES
    [TaskScheduler timer] [ 2012-12-07 14:05:59.622 IST ] [OCR.keyExists:688] OCR.keyExists(DATABASE.DATABASES.odb.lss.emc.com)
    [TaskScheduler timer] [ 2012-12-07 14:05:59.692 IST ] [OCR.keyExists:688] OCR.keyExists(DATABASE.DATABASES.odb.lss.emc.com)
    [TaskScheduler timer] [ 2012-12-07 14:05:59.696 IST ] [OCRTree.isDatabaseConfigured:721] Releasing shared CSS lock SRVM.DATABASE.DATABASES
    [TaskScheduler timer] [ 2012-12-07 14:05:59.699 IST ] [Verifier.getDbNameError:1757] PRCD-1027 : Failed to retrieve database odb.lss.emc.com
    PRCR-1031 : Resource attribute NAME value ora.odb.lss.emc.com.db is not valid
    PRCD-1027 : Failed to retrieve database odb.lss.emc.com
    PRCR-1031 : Resource attribute NAME value ora.odb.lss.emc.com.db is not valid
    at oracle.cluster.impl.database.DatabaseFactoryImpl.getDatabase(DatabaseFactoryImpl.java:405)
    at oracle.cluster.database.DatabaseFactory.getDatabase(DatabaseFactory.java:251)
    at oracle.sysman.assistants.util.hasi.HADatabaseUtils.isDataBaseExist(HADatabaseUtils.java:494)
    at oracle.sysman.assistants.dbca.backend.Verifier.getDbNameError(Verifier.java:1747)
    at oracle.sysman.assistants.dbca.backend.Verifier.validate(Verifier.java:872)
    at oracle.sysman.assistants.dbca.backend.Verifier.validate(Verifier.java:790)
    at oracle.sysman.assistants.dbca.backend.Host.validate(Host.java:4548)
    at oracle.sysman.assistants.dbca.ui.DBCAWizard$1.runTask(DBCAWizard.java:1158)
    at oracle.ewt.thread.TaskScheduler.runTask(Unknown Source)
    at oracle.ewt.thread.TaskScheduler.processTask(Unknown Source)
    at oracle.ewt.thread.TaskScheduler$TaskQueue.run(Unknown Source)
    at oracle.ewt.timer.Timer.doRun(Unknown Source)
    at oracle.ewt.timer.Timer.run(Unknown Source)
    at java.lang.Thread.run(Thread.java:595)
    Caused by: PRCR-1031 : Resource attribute NAME value ora.odb.lss.emc.com.db is not valid
    at oracle.cluster.impl.database.DatabaseImpl.<init>(DatabaseImpl.java:253)
    at oracle.cluster.impl.database.DatabaseFactoryImpl.getDatabase(DatabaseFactoryImpl.java:379)
    ... 13 more


    ================================================

    Can we ignore these errors ?

    Is the "/var/RAC/oracle/cfgtoollogs/dbca/odb/trace.log" only log file related to DBCA configuration ?


    In the "/var/RAC/oracle/cfgtoollogs/dbca/odb/cloneDBCreation.log" it's showing below output;


    ================================================

    Import: Release 11.2.0.1.0 - Production on Fri Dec 7 13:07:03 2012

    Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.


    IMP-00030: failed to create file +ORA_DATA/odb/example01.dbftts_example_imp.log for write
    IMP-00000: Import terminated unsuccessfully
    +ORA_DATA/odb/controlfile/current.276.801407539
    ORA-01109: database not open


    Database dismounted.
    ORACLE instance shut down.
    ORACLE instance started.
    Total System Global Area 6814535680 bytes
    Fixed Size 2182744 bytes
    Variable Size 3539993000 bytes
    Database Buffers 3254779904 bytes
    Redo Buffers 17580032 bytes
    +ORA_DATA/odb/controlfile/current.276.801407573
    USERS

    specify password for SYS as parameter 1:

    specify password for HR as parameter 2:

    specify password for OE as parameter 3:

    specify password for PM as parameter 4:

    specify password for IX as parameter 5:

    specify password for SH as parameter 6:

    specify password for BI as parameter 7:

    specify INPUT metadata import file as parameter 8:

    specify INPUT database backup file for tablespace EXAMPLE as parameter 9:

    specify OUTPUT database file for tablespace EXAMPLE as parameter 10:

    specify OUTPUT log directory as parameter 11:

    Sample Schemas are being plugged in ...

    SP2-0606: Cannot create SPOOL file "+ORA_DATA/odb/example01.dbfmkplug_v3_odb2.log"

    20121207 01:13:04

    1 row selected.

    old 1: CREATE USER hr IDENTIFIED BY &&password_hr
    new 1: CREATE USER hr IDENTIFIED BY ley

    User created.

    old 1: CREATE USER oe IDENTIFIED BY &&password_oe
    new 1: CREATE USER oe IDENTIFIED BY change_on_install

    User created.

    old 1: CREATE USER ix IDENTIFIED BY &&password_ix
    new 1: CREATE USER ix IDENTIFIED BY change_on_install

    User created.

    old 1: CREATE USER sh IDENTIFIED BY &&password_sh
    new 1: CREATE USER sh IDENTIFIED BY change_on_install

    User created.

    old 1: CREATE USER pm IDENTIFIED BY &&password_pm
    new 1: CREATE USER pm IDENTIFIED BY change_on_install

    User created.

    old 1: CREATE USER bi IDENTIFIED BY &&password_bi
    new 1: CREATE USER bi IDENTIFIED BY change_on_install

    User created.


    Directory created.


    Directory created.


    Directory created.


    Grant succeeded.

    Grant succeeded.

    PL/SQL procedure successfully completed.

    PL/SQL procedure successfully completed.


    Grant succeeded.
    .
    .
    .

    Grant succeeded.


    PL/SQL procedure successfully completed.


    PL/SQL procedure successfully completed.


    Grant succeeded.
    .
    .
    .

    Grant succeeded.


    20121207 01:13:05

    1 row selected.

    old 30: dbms_backup_restore.restoreDataFileTo(data_file_id,'&data_file_name');
    new 30: dbms_backup_restore.restoreDataFileTo(data_file_id,'/var/RAC/oracle/ODB/assistants/dbca/templates/example01.dfb');
    old 33: dbms_backup_restore.restoreBackupPiece('&data_file_backup', done);
    new 33: dbms_backup_restore.restoreBackupPiece('/var/RAC/oracle/ODB/assistants/dbca/templates/example.dmp', done);
    ERROR:
    ORA-03114: not connected to ORACLE

    ================================================


    Please let me know your suggestions .

    Thanks,
    Ashish
  • 12. Re: " ORA-03114: not connected to ORACLE " error with Oracle DB installation
    71617 Newbie
    Currently Being Moderated
    hi,

    Looking your error:

    Quick questions:
    You did have two Oracle home setup? two user id ?
    Is this your first installation? or you have failed before and try to re-install again?
  • 13. Re: " ORA-03114: not connected to ORACLE " error with Oracle DB installation
    970402 Newbie
    Currently Being Moderated
    Hi Chen,

    Last time grid installation was failed when i tried with my 1st node "lclc148", the problem i faced at that time was after installation of grid root.sh script get's failed every time, then i deinstalled grid after deconfiguring setup. When i tried with another node "lclc150" it's finished smoothly. i was able to run grid's root.sh on both the hosts with errors. And now i have finished Oracle Clustered database but while creating new database i am getting these errors.

    Both the time of grid installation i have used same directory structure & users.

    Please let me know your view on this. Is it possible for you to post a guide for Step By Step Oracle RAC 11gR2 installation on HP-UX 11.31 IA64 OS. I don't have access to meta links. :(

    -Ashish
  • 14. Re: " ORA-03114: not connected to ORACLE " error with Oracle DB installation
    970402 Newbie
    Currently Being Moderated
    Btw Chen, if you don't mind. Could you please verify the steps of Oracle RAC 11GR2 installation on HP-UX 11.31 IA64 host ? I have already posted these steps in to another thread as below.

    Are these steps are fine for grid installation on 2 HP-UX hosts ?

    Here in above thread i have mentioned the grid installation steps & prerequisite setup.

    Please point me if i have missed something in between.


    Thanks,

    Ashish
1 2 Previous Next

Legend

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