ANIL VEJENDLA

These messages are related to the Oracle TNS Listener's default subscription to the Oracle Notification Service (ONS). In a non-RAC environment it is recommended to disable this subscription.   This feature was introduced in Oracle 10g. SOLUTION Set the following parameter in the listener.ora: SUBSCRIBE_FOR_NODE_DOWN_EVENT_<listener_name>=OFF Where <listener_name> should be replaced with the actual listener name configured in the LISTENER.ORA file. SUBSCRIBE_FOR_NODE_DOWN_EVENT_<listener_name> parameter is to be placed by itself on an empty line. It will be necessary to restart or reload the listener following the addition of this parameter. This will prevent the messages from being written to the log file and may also prevent the TNS Listener from hanging periodically.  See (10g only) NOTE 340091.1 Intermittent TNS Listener Hang, New Child Listener Process Forked Please Note: Setting SUBSCRIBE_FOR_NODE_DOWN_<liste...

Login to OEM server <OMS server> follow the procedure :     Create a keystore :     $ cd /<base>/Middleware/jdk16/jdk/bin     ./keytool -genkey -alias <host name>  -keyalg RSA -keystore <host name>.jks  -keysize 2048     Fill the details :     Enter keystore password:  Re-enter new password:  What is your first and last name?    [Unknown]:  <host name>​  What is the name of your organizational unit?    [Unknown]:  Secure-24  What is the name of your organization?    [Unknown]:  Secure-24  What is the name of your City or Locality?    [Unknown]:  Southfield  What is the name of your State or Province?    [Unknown]:  Michigan  What is the two-letter country code for this unit?    [Unknown]:  US  Is CN=<host name>, O...

SQL> select * from  V$RECOVERY_PROGRESS order by START_TIME; START_TIME         TYPE            ITEM                      UNITS           SOFAR      TOTAL TIMESTAMP          COMMENTS            CON_ID ------------------ --------------- ------------------------- ---------- ---------- ---------- ------------------ --------------- ---------- 26-APR-16          Media Recovery  Active Apply Rate         KB/sec            878        878                                             0 26-APR-16          Media Recovery  Redo Applied     ...

Make all instances in a RAC environment switching the logfile with one single command: ALTER SYSTEM SWITCH ALL LOGFILE; In single Instance : ALTER SYSTEM SWITCH  LOGFILE;

Character set Change from AL32UTF8 to WE8MSWIN1252 I tested below procedure successfully in Test Environment . Case 1: Simple alter statement does not work in this case.. SYS@S2411S > ALTER DATABASE CHARACTER SET WE8MSWIN1252; ALTER DATABASE CHARACTER SET WE8MSWIN1252 * ERROR at line 1: ORA-12712: new character set must be a superset of old character set Case 2: Steps to Change CHARACTER SET ***************************** Step 1:  Install CSSCAN cd $ORACLE_HOME/rdbms/admin sqlplus “/as sysdba” @csminst.sql Find log file for sample result for this execution. ********************* Step 2: Run csscan from command line. csscan sys/Welcome123 fromchar= al32utf8  tochar= we8mswin1252 full=y [oracle@s24-oratl15 admin]$ csscan \"sys as sysdba\" full=y fromchar=al32utf8  tochar=we8mswin1252 Character Set Scanner v2.2 : Release 11.2.0.4.0 - Production on Tue Apr 19 15:54:13 2016 Copyright (c) 1982, 2011, Oracle and/or its affiliates. ...

Agent is up and running fine ..but Upload is Failing with   EMD upload error:full upload has failed: Upload Recent Sending Statistics  Note:  Tried installation multiple times but stuck with same error..No communication or Port issue with OMS .. No Known issue. Here is my Agent status: ./emctl status agent  Oracle Enterprise Manager Cloud Control 12c Release 4  Copyright (c) 1996, 2014 Oracle Corporation. All rights reserved.  ---------------------------------------------------------------  Agent Version : 12.1.0.4.0  OMS Version : 12.1.0.4.0  Protocol Version : 12.1.0.1.0  Agent Home : /usr/lib/oracle/agent_drm/agent_inst  Agent Log Directory : /usr/lib/oracle/agent_drm/agent_inst/sysman/log  Agent Binaries : /usr/lib/oracle/agent_drm/core/12.1.0.4.0  Agent Process ID : 2199  Parent Process ID : 2118  Agent URL : https://test-oradl11:3873/emd/main/  Local Agent URL in NAT : https://tes...

TFA Failed to start listening for commands on one of the Rac Node : As a root user /etc/init.d/init.tfa  start Starting TFA.. start: Job is already running: oracle-tfa Waiting up to 100 seconds for TFA to be started.. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Successfully started TFA Process.. . . . . . TFA-00002 : Oracle Trace File Analyzer (TFA) is not running TFA Failed to start listening for commands Solution : run synctfanodes.sh  if you have root password . if no root password copy below files to TFA Failed node and try to restart TFA .. Please check whether these 4 files exist on all nodes are similar. TFA_HOME/server.jks TFA_HOME/client.jks TFA_HOME/internal/ssl.properties   TFA_HOME/internal/ portmapping.txt If not similar just copy these files to TFA Failing node and try TFA Restart ..It Worked for me .   [root@host01]# ./tfactl  -v "debug" start Starting TFA...

If you wish to enable DDL logging for your database by setting the parameter enable_ddl_logging to true , you must first license the Oracle Change Management Pack. If you set the enable_ddl_logging parameter to true, the instance will record the DDL changes in the log.xml file. If you don't set this parameter to true, Oracle won't record these changes to the log.xml or the alert log. SQL> sho parameter enable_ddl_logging NAME                                 TYPE        VALUE ------------------------------------ ----------- ------------------------------ enable_ddl_logging                   boolean     TRUE SQL> Log file location:  /u01/app/oracle/diag/rdbms/oracmdb/ORACMDB/log/ddl

Issue  :   While taking expdp backup using system user in 12c Databases.. we are getting following errors.. ORA-31693: Table data object "SYS"."KU$_USER_MAPPING_VIEW" failed to load/unload and is being skipped due to error: ORA-01031: insufficient privileges ORA-31693: Table data object "SYS"."FGA_LOG$FOR_EXPORT" failed to load/unload and is being skipped due to error: ORA-01031: insufficient privileges ORA-31693: Table data object "SYS"."AUDTAB$TBS$FOR_EXPORT" failed to load/unload and is being skipped due to error: ORA-01031: insufficient privileges ORA-31693: Table data object "SYS"."DBA_SENSITIVE_DATA" failed to load/unload and is being skipped due to error: ORA-01031: insufficient privileges ORA-31693: Table data object "SYS"."DBA_TSDP_POLICY_PROTECTION" failed to load/unload and is being skipped due to error: ORA-01031: insufficient privileges ORA-31693: Table data ob...