Modern Oracle DBA

  Check the status and process id for the concurrent request select oracle_process_id ,decode(status_code,'R','Running','D','Canceled','E','Error','X','Terminated','G','Warning','T','Terminating')"Status_code",phase_code,to_char(actual_start_date,'DD-MON-YYYY=>hh24:mi:ss') "Login Time" from apps.fnd_concurrent_requests where request_id='&Enter_conn_req_id'   Collect SID and serial# from process id select s.sid,s.serial#,module,s.status from v$session s,v$process p where s.paddr=p.addr and p.spid=&oracle_process_id   Backup from fnd_consurrent_requests table and run the update command and please make sure database session for the request id is killed SQL> update apps.fnd_concurrent_requests set status_code='X',Phase_code='C' where request_id=’1234567’; 1 row ...

 If we try to connect PDB getting below error SQL> alter session set container="dev2"; ERROR: ORA-03114: not connected to ORACLE Solution: Check listener is working normally Below action plan no need application bounce   Close and reopen the PDB SQL> alter pluggable database "dev2" close; Pluggable database altered. SQL> alter pluggable database "dev2" open; Pluggable database altered. SQL> alter session set container="dev2"; Session altered. If “alter pluggable database "dev2" close” command taking time Please check how many users connected database ps -ef |grep -i local=no If more user connected open duplicate session connect sqlplus and startup force command. But startup force command is not recommended based on the scenarios we can use it. 

  Summary What is Data Guard What is primary database What is standby database:- Standby database types:- Data guard services:- Oracle Data guard Production mode:   What is Data Guard:- Oracle Data guard is provide the a comprehensive set of services that high availability, data production and distorter recovery Oracle Data guard maintain the standby database its copy for the production database. If production DB is unavailable because planned/unplanned activity standby database will become a production database role. Planned (Switchover / Switchback) Unplanned (Failover)   What is primary database:- Primary database is our production database It can be either single instance/RAC database.   What is standby database:- Standby database is copy of the production database.   Standby database types:- Physical standby Database Logical standby Database Snapshot standby Database   Physical standby Database Phys...