Oracle & Linux Blog

Datapatch in a Multitenant Environment: When datapatch is run to invoke any SQL actions in a Multitenant environment, datapatch only applies the changes to the ROOT, SEED and any open PDBs based on the pending actions.  For any PDB that is not currently open, the SQL patch will not be applied.  When such a PDB is reopened, it will be opened in restricted mode as there will be a patch level mismatch between the PDB and the ROOT. Call DBMS_PDB.CHECK_PLUG_COMPATIBILITY on 12.1.0.1. PDB xml file will return these two violations, which are expected.   SQL Patch              ERROR   SQL patch  bug #  mismatch: Installed in the PDB but not in the CDB.   Install the SQL patch in the PDB or the CDB This error can be cleared by running datapatch again and closing and reopening the affected PDB(s) 1)    Invoke datapatch: % cd $ORACLE_HOME/OPatch % datapatch 2) ...

Here we are renaming the database from “DB001” to “DB002”.This method can be used for the database on lower versions (than 11gR2) also. [oracle@rac1~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Tue Apr 21 00:57:47 2015 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to an idle instance. SQL> startup ORACLE instance started. Total System Global Area 535662592 bytes Fixed Size 1345376 bytes Variable Size 364906656 bytes Database Buffers 163577856 bytes Redo Buffers 5832704 bytes Database mounted. Database opened. SQL> show parameter instance_name NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ instance_name string DB001 SQL> show parameter db_name NAME TYPE VALUE ------------------------------------ ----------- -----------...

[oracle@rac2 bin]$tnsping oradb001 TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 30-Nov-2012 01:52:34 Copyright (c) 1997, 2009, Oracle.  All rights reserved. Used parameter files: /oracle/11gdb/network/admin/sqlnet.ora Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.1)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = oradb001))) TNS-12543: TNS:destination host unreachable Diagnosis process: ------------------- Please use the oerr utility to get the more information on this error. oracle@rac2 $ oerr ora 12543 12543, 00000, "TNS:destination host unreachable" *Cause: Contact can not be made with remote party. *Action: Make sure the network driver is functioning and the network is up. Solution: --------- Reason : Firewall was enabled on both the servers(rac1 & rac2). ----------------------------------------------------------------- I disabled the f...

Environment : Oracle database 11.2.0.3, Oracle Linux 6.2 I was debugging a possible network problem on a Oracle Linux server with a fresh installation of Oracle 11gR2, when I noticed the following: $ netstat -s Tcp: 1178980 active connections openings 273496 passive connection openings 911657 failed connection attempts The number of “failed connection attempts” increased by one for every 2 seconds. So, something was clearly trying to connect to something else and this failed for some reason. I didn’t find how I could further debug this problem with netstat. However, I had free access to the server, so I tried to shut down the Oracle services one by one to see if this would stop the growing number of failed connection attempts. When I stopped the Oracle listener service, it did… Listener logging was on and there were a lot of warnings in the  listener.log  file: WARNING: Subscription for node down event still pending I did a search on My Oracle Support and I...