Error :

Caused by: java.sql.SQLException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

•         Hostname – xxxxxxxdb41/42
•         Scan – xxxxxxxdb-sc
•         Port – 1525
•         Container DB – Cxxxx06P
•         Pluggable DB – Pxxxxx06

TNS Entry is as below

XXX06 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = hqixxxxdb-sc)(PORT = 1525))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = XXXX06)
    )
  )

Solution :


If we are using service name to connect use "/" and in case of SID use ":"


Connect via SERVICE_NAME :
username/password@host:port/SERVICE_NAME


Connect via SID :


username/password@host:port:SID


Url :

Url for application to connect : jdbc:oracle:thin:@xxxxxxxdb-sc:1525/XXXX06

How partition reads are important in explain plan ?

What are wait events DBA must look at ?

Why wait events are important in Oracle  ?

Application restart was giving timeout error for http, oacore and oafm services.

        ERROR : Timed out( 100000 ): Interrupted Exception
        You are running adoafmctl.sh version 120.6.12000000.2
        Starting OPMN managed OAFM OC4J instance  ...

• Ran autoconfig on all node starting from db , ap and cm to sink all xml and config files of application. 

• Increase parameter in $ORA_CONFIG_HOME/10.1.3/opmn/conf/opmn.xml  file to fix timeout error in oacore and oafm.

    <start timeout="600" retry="2"/>    changed to <start timeout="1800" retry="2"/>

• Post timeout parameter change error is “adoacorectl.sh: exiting with status 150”  and  “adoafmctl.sh: exiting with status 150  “

Part of log.....

Program : /u001/SACH/apps/apps_st/appl/fnd/12.0.0/patch/115/bin/txkChkFormsDeployment.pl completed @ Thu Jul 21 05:45:42 2016

Perl script txkChkFormsDeployment.pl got executed successfully

adformsctl.sh: exiting with status 150

adformsctl.sh: check the logfile /u001/SACH/inst/apps/SACH_hqidlsachap01/logs/appl/admin/log/adformsctl.txt for more information ...


.end std out.
*** ALL THE FOLLOWING FILES ARE REQUIRED FOR RESOLVING RUNTIME ERRORS
*** Log File = /u001/SACH/inst/apps/SACH_hqidlsachap01/logs/appl/rgf/TXK/txkChkFormsDeployment_Thu_Jul_21_05_45_32_2016/txkChkFormsDeployment_Thu_Jul_21_05_45_32_2016.log

.end err out.

****************************************************


Executing service control script:
/u001/SACH/inst/apps/SACH_hqidlsachap01/admin/scripts/adoafmctl.sh start
script returned:
****************************************************

You are running adoafmctl.sh version 120.8

Starting OPMN managed OAFM OC4J instance  ...

adoafmctl.sh: exiting with status 150

adoafmctl.sh: check the logfile /u001/SACH/inst/apps/SACH_hqidlsachap01/logs/appl/admin/log/adoafmctl.txt for more information ...


.end std out.

.end err out.

Log file has below details 

  Root Service                                                                                                                 Enabled
  Root Service               Oracle Process Manager                                adopmnctl.sh     Started
  Web Entry Point Services                                                                                             Enabled
  Web Entry Point Services   Oracle HTTP Server                             adapcctl.sh          Failed
  Web Entry Point Services   OracleTNSListener                               adalnctl.sh           Started
  Web Application Services                                                                 Enabled
  Web Application Services   OACORE OC4J Instance                     adoacorectl.sh     Failed
  Web Application Services   FORMS OC4J Instance                        adformsctl.sh       Started
  Web Application Services   OAFM OC4J Instance                          adoafmctl.sh        Failed
  Batch Processing Services                                                                                             Disabled

• Deleted  “httpd.pid”  at   /u001/SACH/inst/apps/SACH_hqidlsachap01/pids/10.1.3/Apache  and   “.opmndat”  at  /oracle/apps/VIS/inst/apps/<CONTEXT>/ora/10.1.3/opmn/logs/states

• cleaned persistant directory for oacore , oafm and forms and restarted application and database still unable to start ebiz

• NFS share mounted on hqidlsachap01 is also being used by other servers,

• Observe rpciod deadlock on other server. periodically the rpciod is going into D state i.e uninterruptible sleep state.

• Load average and iowait% is also very high on these servers. 

• Finally rebooted all servers having common NFS and restarted application service to resolve the issue.

Different errors while changing dbid during clone

            

•  NID-00106: LOGIN to target database failed with Oracle error:
•  ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

NID-00106  followed by  ORA-12514 occurs If tnsname.ora does not have entry for both Rac database nodes. put entry in tnsname.ora for both database nodes

•         NID-00106: LOGIN to target database failed with Oracle error:
•         ORA-01031: insufficient privileges

        If password file is not present in $ORACLE_HOME/dbs directory we will get this error.
         Create password file using command "orapwd".

               orapwd  file=file_name   password=password 

Place the password file on both nodes  in directory $ORACLE_HOME/dbs .           

•              NID-00131: Control file is not current

          After control file creation during clone database was not open with reset logs. Open database     with reset logs and change dbid.
       

•          NID-00600: Internal Error - [17] [1] [0] [0]

       Check status of all table space in a  database, one of them is in offline mode.
       change the status of tablespace from offline to online and then change the dbid.