This discussion is archived
1 2 3 Previous Next 34 Replies Latest reply: Sep 28, 2012 12:33 PM by 72370 RSS

not able to configure emctl in 11gr2 rac

OraDB Newbie
Currently Being Moderated
Friends,

DB: Oracle 11gR2 (11.2.0.3) 64 bit
OS(rac1): OEL 6.3 64 bit in virtual box 4.2

DB: Oracle 11gR2 (11.2.0.3) 64 bit
OS(rac2): OEL 6.3 64 bit in virtual box 4.2

Just now installed 2 node rac db...the db is working fine...and the em also working fine before i restart the server.
after restarting...em is not starting automatically.
[oracle@rac1 ~]$ echo $GRID_HOME 
/u01/app/11.2.0/grid
[oracle@rac1 ~]$ echo $ORACLE_HOME 
/u01/app/oracle/product/11.2.0/db_1
[oracle@rac1 ~]$ 
[oracle@rac1 ~]$ emctl status dbconsole
Can't locate CompEMdbconsole.pm in @INC (@INC contains: %s_javapOracleHome%/sysman/admin/scripts %s_javapOracleHome%/bin /u01/app/11.2.0/grid/perl/lib/5.10.0/x86_64-linux-thread-multi /u01/app/11.2.0/grid/perl/lib/5.10.0 /u01/app/11.2.0/grid/perl/lib /u01/app/11.2.0/grid/perl/lib/site_perl/5.10.0/x86_64-linux-thread-multi /u01/app/11.2.0/grid/perl/lib/site_perl/5.10.0 /u01/app/11.2.0/grid/perl/lib/site_perl /u01/app/11.2.0/grid/perl/libwww-perl/lib /u01/app/11.2.0/grid/perl/ext/POSIX /u01/app/11.2.0/grid/perl/URI /u01/app/11.2.0/grid/perl/HTML_Parser /u01/app/11.2.0/grid/perl/HTML-Parser/lib /u01/app/11.2.0/grid/sysman/admin/scripts /u01/app/11.2.0/grid/bin /u01/app/11.2.0/grid/sysman/admin/scripts/Net-DNS-0.48/lib/ /u01/app/11.2.0/grid/sysman/admin/scripts/libnet-1.19/ .) at /u01/app/11.2.0/grid/bin/EmctlCommon.pm line 598.
[oracle@rac1 ~]$ echo $ORACLE_HOME 
/u01/app/11.2.0/grid
[oracle@rac1 ~]$ dg_env
-bash: dg_env: command not found
[oracle@rac1 ~]$ db_env
[oracle@rac1 ~]$ echo $ORACLE_HOME 
/u01/app/oracle/product/11.2.0/db_1
[oracle@rac1 ~]$ emctl status dbconsole
OC4J Configuration issue. /u01/app/oracle/product/11.2.0/db_1/oc4j/j2ee/OC4J_DBConsole_rac1_rac not found. 
[oracle@rac1 ~]$ 
[oracle@rac1 ~]$ emca -config dbcontrol db -repos recreate -cluster

STARTED EMCA at Sep 23, 2012 3:55:18 PM
EM Configuration Assistant, Version 11.2.0.3.0 Production
Copyright (c) 2003, 2011, Oracle.  All rights reserved.

Enter the following information:
Database unique name: rac
Service name: rac1
Listener port number: 1521
Listener ORACLE_HOME [ /u01/app/11.2.0/grid ]: /u01/app/oracle/product/11.2.0/db_1
Password for SYS user:  
Sep 23, 2012 3:55:58 PM oracle.sysman.emcp.ParamsManager setConfiguredNodeSidList
WARNING: Error determining the nodes associated with cluster database rac
Sep 23, 2012 3:55:58 PM oracle.sysman.emcp.ParamsManager setConfiguredNodeSidList
WARNING: Error determining the nodes associated with cluster database rac
Sep 23, 2012 3:56:00 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineRemotely
WARNING: Error during db connection : ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

Sep 23, 2012 3:56:06 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineRemotely
WARNING: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

Password validation failed. Some of the possible reasons may be:
 
1) Invalid username/password. 
2) Database is not up. 
3) Scan listener not up. 
4) Database service is not registered with scan listener. 
5) Password file may be missing or configured incorrectly. 

Password for SYS user: [oracle@rac1 ~]$ 
[oracle@rac1 ~]$ 
[root@rac1 ~]# cemutlo -n
rac
SQL> show parameter db_uniqu

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_unique_name                       string      orcl
SQL> 
[oracle@rac1 ~]$ lsnrctl status

LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 23-SEP-2012 15:59:45

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

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                23-SEP-2012 11:41:35
Uptime                    0 days 4 hr. 18 min. 9 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/11.2.0/grid/network/admin/listener.ora
Listener Log File         /u01/app/grid/diag/tnslsnr/rac1/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.3)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.4)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
  Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "orcl.sathy.net" has 1 instance(s).
  Instance "rac11", status READY, has 1 handler(s) for this service...
Service "rac1XDB.sathy.net" has 1 instance(s).
  Instance "rac11", status READY, has 1 handler(s) for this service...
The command completed successfully
[oracle@rac1 ~]$ 
i tried with +ASM1, rac1, rac11 for the service name.
and the database unique name is rac....
i gone thru document for dropping and creating the em...but not succeeded...
  • 1. Re: not able to configure emctl in 11gr2 rac
    Osama_Mustafa Oracle ACE
    Currently Being Moderated
    Check the following :
    -Password File on both node .
    -local Listener parameter .
    -Remote Listener
  • 2. Re: not able to configure emctl in 11gr2 rac
    KuljeetPalSingh Guru
    Currently Being Moderated
    Password for SYS user:
    Sep 23, 2012 3:56:06 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineRemotely
    WARNING: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
    makesure you've enter correct sys password, also ensure password should not contain @ symbol
  • 3. Re: not able to configure emctl in 11gr2 rac
    OraDB Newbie
    Currently Being Moderated
    password is correct...

    asm password files are in grid home

    database password files are in db home.

    from which home i have to run emctl command to start the db console.?
    from grid home or from db home?

    also which sid i have set ...+ASM1 or rac11 or rac12? to run the emctl...emctl is for db ... so obviously it should be in db home (correct me if i am wrong)

    password file details of +ASM1 sid...from rac1
    [oracle@rac1 ~]$ grid_env
    [oracle@rac1 ~]$ export ORACLE_SID=+ASM1
    [oracle@rac1 ~]$ sss
    
    SQL*Plus: Release 11.2.0.3.0 Production on Sun Sep 23 17:41:27 2012
    
    Copyright (c) 1982, 2011, Oracle.  All rights reserved.
    
    
    Connected to:
    Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
    With the Real Application Clusters and Automatic Storage Management options
    
    SQL> select * from gv$pwfile_users;
    
       INST_ID USERNAME                       SYSDB SYSOP SYSAS
    ---------- ------------------------------ ----- ----- -----
             1 SYS                            TRUE  TRUE  TRUE
             1 ASMSNMP                        TRUE  FALSE FALSE
             2 SYS                            TRUE  TRUE  TRUE
             2 ASMSNMP                        TRUE  FALSE FALSE
    
    SQL> show parameter pass
    
    NAME                                 TYPE        VALUE
    ------------------------------------ ----------- ------------------------------
    remote_login_passwordfile            string      EXCLUSIVE
    
    [oracle@rac1 ~]$ cd $ORACLE_HOME/dbs
    [oracle@rac1 dbs]$ ls
    ab_+ASM1.dat  hc_+ASM1.dat  init.ora  orapw+ASM
    
    [oracle@rac1 dbs]$ pwd
    /u01/app/11.2.0/grid/dbs
    password file details of sid "rac11" in rac1
    [oracle@rac1 dbs]$ db_env
    [oracle@rac1 dbs]$ export ORACLE_SID=rac11
    [oracle@rac1 dbs]$ sss
    
    SQL*Plus: Release 11.2.0.3.0 Production on Sun Sep 23 17:47:27 2012
    
    Copyright (c) 1982, 2011, Oracle.  All rights reserved.
    
    
    Connected to:
    Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
    With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
    Data Mining and Real Application Testing options
    
    SQL> select * from gv$pwfile_users;
    
       INST_ID USERNAME                       SYSDB SYSOP SYSAS
    ---------- ------------------------------ ----- ----- -----
             1 SYS                            TRUE  TRUE  FALSE
             2 SYS                            TRUE  TRUE  FALSE
    
    SQL> show parameter pass
    
    NAME                                 TYPE        VALUE
    ------------------------------------ ----------- ------------------------------
    remote_login_passwordfile            string      EXCLUSIVE
    SQL> exit
    Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
    With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
    Data Mining and Real Application Testing options
    
    [oracle@rac1 dbs]$ cd /u01/app/oracle/product/11.2.0/db_1/dbs/
    [oracle@rac1 dbs]$ pwd
    /u01/app/oracle/product/11.2.0/db_1/dbs
    [oracle@rac1 dbs]$ ls
    hc_rac11.dat  init.ora  initrac11.ora  orapwrac11
    [oracle@rac1 dbs]$ 
    local listener and remote listener details of rac1.....for both sid's
    [oracle@rac1 dbs]$ grid_env
    [oracle@rac1 dbs]$ export ORACLE_SID=+ASM1
    [oracle@rac1 dbs]$ sss
    
    SQL*Plus: Release 11.2.0.3.0 Production on Sun Sep 23 17:54:39 2012
    
    Copyright (c) 1982, 2011, Oracle.  All rights reserved.
    
    
    Connected to:
    Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
    With the Real Application Clusters and Automatic Storage Management options
    
    SQL> show parameter local_listener
    
    NAME                                 TYPE        VALUE
    ------------------------------------ ----------- ------------------------------
    local_listener                       string      (DESCRIPTION=(ADDRESS_LIST=(AD
                                                     DRESS=(PROTOCOL=TCP)(HOST=192.
                                                     168.1.4)(PORT=1521))))
    SQL> show parameter remote_listener
    
    NAME                                 TYPE        VALUE
    ------------------------------------ ----------- ------------------------------
    remote_listener                      string
    SQL> exit
    Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
    With the Real Application Clusters and Automatic Storage Management options
    [oracle@rac1 dbs]$ db_env
    [oracle@rac1 dbs]$ export ORACLE_SID=rac11
    [oracle@rac1 dbs]$ sss
    
    SQL*Plus: Release 11.2.0.3.0 Production on Sun Sep 23 17:55:11 2012
    
    Copyright (c) 1982, 2011, Oracle.  All rights reserved.
    
    
    Connected to:
    Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
    With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
    Data Mining and Real Application Testing options
    
    SQL> show parameter local_listener
    
    NAME                                 TYPE        VALUE
    ------------------------------------ ----------- ------------------------------
    local_listener                       string      (DESCRIPTION=(ADDRESS_LIST=(AD
                                                     DRESS=(PROTOCOL=TCP)(HOST=192.
                                                     168.1.4)(PORT=1521))))
    SQL> show parameter remote_listener
    
    NAME                                 TYPE        VALUE
    ------------------------------------ ----------- ------------------------------
    remote_listener                      string      sathy-scan.sathy.net:1521
    SQL> 
    password file,locallister,remotelistener details of +ASM1 sid and rac12 sid from rac2
    [oracle@rac2 admin]$ grid_env
    [oracle@rac2 admin]$ cd $ORACLE_HOME/dbs
    [oracle@rac2 dbs]$ ls
    ab_+ASM2.dat  hc_+ASM2.dat  init.ora  orapw+ASM
    [oracle@rac2 dbs]$ cd /u01/app/11.2.0/grid/network/admin/
    [oracle@rac2 admin]$ ls
    endpoints_listener.ora  listener.ora  listener.ora.bak.rac2  samples  shrept.lst  sqlnet.ora
    [oracle@rac2 admin]$ export ORACLE_SID=+ASM2
    [oracle@rac2 admin]$ sss
    
    SQL*Plus: Release 11.2.0.3.0 Production on Sun Sep 23 17:59:43 2012
    
    Copyright (c) 1982, 2011, Oracle.  All rights reserved.
    
    
    Connected to:
    Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
    With the Real Application Clusters and Automatic Storage Management options
    
    SQL> select * from gv$pwfile_users;
    
       INST_ID USERNAME                       SYSDB SYSOP SYSAS
    ---------- ------------------------------ ----- ----- -----
             2 SYS                            TRUE  TRUE  TRUE
             2 ASMSNMP                        TRUE  FALSE FALSE
             1 SYS                            TRUE  TRUE  TRUE
             1 ASMSNMP                        TRUE  FALSE FALSE
    
    SQL> show parameter remote_listener
    
    NAME                                 TYPE        VALUE
    ------------------------------------ ----------- ------------------------------
    remote_listener                      string
    SQL> show parameter local_listener
    
    NAME                                 TYPE        VALUE
    ------------------------------------ ----------- ------------------------------
    local_listener                       string      (DESCRIPTION=(ADDRESS_LIST=(AD
                                                     DRESS=(PROTOCOL=TCP)(HOST=192.
                                                     168.1.6)(PORT=1521))))
    SQL> exit
    Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
    With the Real Application Clusters and Automatic Storage Management options
    [oracle@rac2 admin]$ db_env
    [oracle@rac2 admin]$ cd $ORACLE_HOME/dbs
    [oracle@rac2 dbs]$ ls
    hc_rac12.dat  init.ora  initrac12.ora  orapwrac12
    [oracle@rac2 dbs]$ cd /u01/app/oracle/product/11.2.0/db_1/network/admin/
    [oracle@rac2 admin]$ ls
    samples  shrept.lst  tnsnames.ora
    [oracle@rac2 admin]$ export ORACLE_SID=rac12
    [oracle@rac2 admin]$ sss
    
    SQL*Plus: Release 11.2.0.3.0 Production on Sun Sep 23 18:02:22 2012
    
    Copyright (c) 1982, 2011, Oracle.  All rights reserved.
    
    
    Connected to:
    Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
    With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
    Data Mining and Real Application Testing options
    
    SQL> select * from gv$pwfile_users;
    
       INST_ID USERNAME                       SYSDB SYSOP SYSAS
    ---------- ------------------------------ ----- ----- -----
             1 SYS                            TRUE  TRUE  FALSE
             2 SYS                            TRUE  TRUE  FALSE
    
    SQL> show parameter remote_listener
    
    NAME                                 TYPE        VALUE
    ------------------------------------ ----------- ------------------------------
    remote_listener                      string      sathy-scan.sathy.net:1521
    SQL> show parameter local_listener
    
    NAME                                 TYPE        VALUE
    ------------------------------------ ----------- ------------------------------
    local_listener                       string      (DESCRIPTION=(ADDRESS_LIST=(AD
                                                     DRESS=(PROTOCOL=TCP)(HOST=192.
                                                     168.1.6)(PORT=1521))))
    SQL> show parameter password
    
    NAME                                 TYPE        VALUE
    ------------------------------------ ----------- ------------------------------
    remote_login_passwordfile            string      EXCLUSIVE
    SQL> 
  • 4. Re: not able to configure emctl in 11gr2 rac
    Balazs Papp Expert
    Currently Being Moderated
    [oracle@rac1 ~]$ emca -config dbcontrol db -repos recreate -cluster

    STARTED EMCA at Sep 23, 2012 3:55:18 PM
    EM Configuration Assistant, Version 11.2.0.3.0 Production
    Copyright (c) 2003, 2011, Oracle. All rights reserved.

    Enter the following information:
    Database unique name: rac
    Service name: rac1
    Listener port number: 1521
    Service name: rac1
    LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 23-SEP-2012 15:59:45

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

    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 23-SEP-2012 11:41:35
    Uptime 0 days 4 hr. 18 min. 9 sec
    Trace Level off
    Security ON: Local OS Authentication
    SNMP OFF
    Listener Parameter File /u01/app/11.2.0/grid/network/admin/listener.ora
    Listener Log File /u01/app/grid/diag/tnslsnr/rac1/listener/alert/log.xml
    Listening Endpoints Summary...
    (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.3)(PORT=1521)))
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.4)(PORT=1521)))
    Services Summary...
    Service "+ASM" has 1 instance(s).
    Instance "+ASM1", status READY, has 1 handler(s) for this service...
    Service "orcl.sathy.net" has 1 instance(s).
    Instance "rac11", status READY, has 1 handler(s) for this service...
    Service "rac1XDB.sathy.net" has 1 instance(s).
    Instance "rac11", status READY, has 1 handler(s) for this service...
    The command completed successfully
    Service name: orcl
    i tried with +ASM1, rac1, rac11 for the service name.
    And it failed, because service name is orcl(.sathy.net).

    So either use orcl as service name, or check the service_names parameter in the database, and set it accordingly:
    show parameter service_names
    alter system set service_names='rac1';
    alter system register;
    then try again configuring EM
  • 5. Re: not able to configure emctl in 11gr2 rac
    OraDB Newbie
    Currently Being Moderated
    not working....again same error...
    [oracle@rac1 ~]$ echo $ORACLE_HOME 
    /u01/app/oracle/product/11.2.0/db_1
    [oracle@rac1 ~]$ echo $ORACLE_SID
    rac11
    [oracle@rac1 ~]$ sss
    
    SQL*Plus: Release 11.2.0.3.0 Production on Sun Sep 23 21:58:31 2012
    
    Copyright (c) 1982, 2011, Oracle.  All rights reserved.
    
    
    Connected to:
    Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
    With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
    Data Mining and Real Application Testing options
    
    SQL> show parameter service
    
    NAME                                 TYPE        VALUE
    ------------------------------------ ----------- ------------------------------
    service_names                        string      orcl
    SQL> exit
    Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
    With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
    Data Mining and Real Application Testing options
    [oracle@rac1 ~]$ emca -config dbcontrol db -repos recreate -cluster
    
    STARTED EMCA at Sep 23, 2012 9:59:25 PM
    EM Configuration Assistant, Version 11.2.0.3.0 Production
    Copyright (c) 2003, 2011, Oracle.  All rights reserved.
    
    Enter the following information:
    Database unique name: rac
    Service name: orcl
    Listener port number: 1521
    Listener ORACLE_HOME [ /u01/app/11.2.0/grid ]: 
    Password for SYS user:  
    Sep 23, 2012 9:59:38 PM oracle.sysman.emcp.ParamsManager setConfiguredNodeSidList
    WARNING: Error determining the nodes associated with cluster database rac
    Sep 23, 2012 9:59:38 PM oracle.sysman.emcp.ParamsManager setConfiguredNodeSidList
    WARNING: Error determining the nodes associated with cluster database rac
    Sep 23, 2012 9:59:40 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineRemotely
    WARNING: Error during db connection : ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
    
    Sep 23, 2012 9:59:45 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineRemotely
    WARNING: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
    
    Password validation failed. Some of the possible reasons may be:
     
    1) Invalid username/password. 
    2) Database is not up. 
    3) Scan listener not up. 
    4) Database service is not registered with scan listener. 
    5) Password file may be missing or configured incorrectly. 
    
    Password for SYS user: [oracle@rac1 ~]$ 
    [oracle@rac1 ~]$ 
  • 6. Re: not able to configure emctl in 11gr2 rac
    MahirM.Quluzade Guru
    Currently Being Moderated
    WARNING: Error during db connection : ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

    Sep 23, 2012 9:59:45 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineRemotely
    WARNING: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
    Hi,

    I think you must add to TNSNAMES.ora ORCL service using SCAN-NAME.
    and export ORACLE_UNQNAME = ORCL

    and try again.

    Regards
    Mahir M. Quluzade
    www.mahir-quluzade.com
  • 7. Re: not able to configure emctl in 11gr2 rac
    OraDB Newbie
    Currently Being Moderated
    not working....
    tnsnames.ora is inside db home not in grid home.
    inside grid home listener.ora is available.

    tnsnames.ora has...
    [oracle@rac1 admin]$ cat tnsnames.ora 
    # tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0/db_1/network/admin/tnsnames.ora
    # Generated by Oracle configuration tools.
    
    ORCL =
      (DESCRIPTION =
        (ADDRESS = (PROTOCOL = TCP)(HOST = sathy-scan.sathy.net)(PORT = 1521))
        (CONNECT_DATA =
          (SERVER = DEDICATED)
          (SERVICE_NAME = orcl.sathy.net)
        )
      )
    [oracle@rac1 admin]$ emca -config dbcontrol db -repos recreate -cluster
    
    STARTED EMCA at Sep 24, 2012 9:43:32 PM
    EM Configuration Assistant, Version 11.2.0.3.0 Production
    Copyright (c) 2003, 2011, Oracle.  All rights reserved.
    
    Enter the following information:
    Database unique name: orcl
    Service name: orcl
    Listener port number: 1521
    Listener ORACLE_HOME [ /u01/app/11.2.0/grid ]: 
    Password for SYS user:  
    Sep 24, 2012 9:45:08 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineRemotely
    WARNING: Error during db connection : ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
    
    Sep 24, 2012 9:45:15 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineRemotely
    WARNING: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
    
    Password validation failed. Some of the possible reasons may be:
     
    1) Invalid username/password. 
    2) Database is not up. 
    3) Scan listener not up. 
    4) Database service is not registered with scan listener. 
    5) Password file may be missing or configured incorrectly. 
    
    Password for SYS user: [oracle@rac1 admin]$ 
  • 8. Re: not able to configure emctl in 11gr2 rac
    926275 Newbie
    Currently Being Moderated
    Hi ORADB,

    Can you send me the RAC installation doc that you have implemented with ASM to my email id? I want to try at testing environment...

    My email id is
    durai.ramesh2006@gmail.com

    Regards & Thanks
    Ramesh M
    ORACLE DBA
  • 9. Re: not able to configure emctl in 11gr2 rac
    72370 Newbie
    Currently Being Moderated
    What is the output of lsnrctl service?
  • 10. Re: not able to configure emctl in 11gr2 rac
    OraDB Newbie
    Currently Being Moderated
    http://www.oracle-base.com/articles/11g/oracle-db-11gr2-rac-installation-on-oracle-linux-6-using-virtualbox.php
  • 11. Re: not able to configure emctl in 11gr2 rac
    OraDB Newbie
    Currently Being Moderated
    [oracle@rac1 ~]$ lsnrctl service
    
    LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 25-SEP-2012 23:43:41
    
    Copyright (c) 1991, 2011, Oracle.  All rights reserved.
    
    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
    Services Summary...
    Service "+ASM" has 1 instance(s).
      Instance "+ASM1", status READY, has 1 handler(s) for this service...
        Handler(s):
          "DEDICATED" established:0 refused:0 state:ready
             LOCAL SERVER
    Service "orcl.sathy.net" has 1 instance(s).
      Instance "rac11", status READY, has 1 handler(s) for this service...
        Handler(s):
          "DEDICATED" established:0 refused:0 state:ready
             LOCAL SERVER
    Service "rac1XDB.sathy.net" has 1 instance(s).
      Instance "rac11", status READY, has 1 handler(s) for this service...
        Handler(s):
          "D000" established:0 refused:0 current:0 max:1022 state:ready
             DISPATCHER <machine: rac1.sathy.net, pid: 3337>
             (ADDRESS=(PROTOCOL=tcp)(HOST=rac1.sathy.net)(PORT=24631))
    The command completed successfully
  • 12. Re: not able to configure emctl in 11gr2 rac
    72370 Newbie
    Currently Being Moderated
    Your line:
    Service name: orcl
    should then read:
    Service name: orcl.sathy.net
    Can you also check that your global/unique name
    SELECT global_name FROM global_name
    is also correct?
  • 13. Re: not able to configure emctl in 11gr2 rac
    OraDB Newbie
    Currently Being Moderated
    SQL> select global_name from global_name;  
    
    GLOBAL_NAME
    --------------------------------------------------------------------------------
    ORCL.SATHY.NET
  • 14. Re: not able to configure emctl in 11gr2 rac
    72370 Newbie
    Currently Being Moderated
    Can you please re-run and post the output of
    emca -config dbcontrol db -repos recreate -cluster
    When prompted put the following values in:
    Database unique name: ORCL.SATHY.NET
    Service name: ORCL.SATHY.NET
1 2 3 Previous Next

Legend

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