MS-Excel Trick

Say you have value raheel syed in cell E.g A1=raheel syed and your requirement is to have single quote before and after with comma as for E.g ‘raheel syed’, so how do you do it ? Use this formula in MS-excel

In cell A1=raheel syed then in adjacent cell use formula =”‘”&A1&”‘,” now the new value would be ‘raheel syed’,

If you need the value in UPPERCASE , use =UPPER(“‘”&A1&”‘,”) the new value would be ‘RAHEEL SYED’,

Hope this helps !!

Cheers

Raheel

TNS-12557 TNS-12560 TNS-00527

 

As part of Security enhancement on TEST database Server (Linux 64 bit) SA changed the permission on /tmp/.oracle to drwxrwx— after the change, listener stopped working, though the process is alive I could see the process id but unable to connect from the client.

 

Oracle MOS ID: 343253.1  helped us to resolve this issue

 

LSNRCTL> status

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))

TNS-12557: TNS:protocol adapter not loadable

TNS-12560: TNS:protocol adapter error

  TNS-00527: Protocol Adapter not loadable

 

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=test)(PORT=1521)))

TNS-12557: TNS:protocol adapter not loadable

TNS-12560: TNS:protocol adapter error

  TNS-00527: Protocol Adapter not loadable

 

Solution:  As root user

$ cd /tmp

$ ls -ld .oracle

 

$ chmod 01777 .oracle

If owner and group has also changed during the security enhancement implementation then revert it to root:root

 

Cheers !!!

Raheel

Oracle Configuration Manager – Is it installed or configured ?

To identify if OCM is installed or configured for databases

cd $ORACLE_HOME/ccr/bin and locate file emCCR, if emCCR exists, then OCM is configured.

If emCCR doesn’t exists then OCM is installed but not configured.

If you need to configure OCM then follow OCM Quick start Guide.

If you don’t need OCM then remove OCM from the database using the SQL Script

Source: MOS Doc ID: 736837.1 and OCM quick start guide

Cheers !!!

Raheel

Switchover and Failover with TIME Delay

To protect against application corrupted or erroneous data to the standby database, DELAY (minutes) option can be used in LOG_ARCHIVE_DEST_n to delay applying of archived log at standby database. (It does not delay transport of redo data to standby instead time lag begin when redo data is completely archived at standby)

At primary site set init parameter as follows

SQL> alter system set log_archive_dest_2='SERVICE=stdby DELAY=240'; (4 hrs time delay)

Switchover with TIME delay

• Switchover will not begin until standby database applies all archived log files.

            Lift DELAY by using NODELAY keyword on Physical Standby as

SQL> alter database recover managed standby database nodelay disconnect from
session through last switchover;

• Users Logoff from Primary and Standby database
• Switch Primary to Standby

SQL> alter database commit to switchover to physical standby with session shutdown;

SQL> shutdown normal

SQL> startup mount

  

The above statement does the following:

1. Closes the primary database, terminating any active sessions
2. Transmits any unarchived redo log files and applies them to the standby database
3. Adds an end-of-redo marker to the header of the last log file being archived
4. Creates a backup of the current control file
5. Converts the current control file into a standby control file

• Switch original standby to Primary role

SQL> alter database commit to switchover to primary database;

SQL> shutdown

SQL> startup

Failover with TIME delay

Failover to a physical standby database for which the application of archived redo log files is delayed. By doing so, you transition the standby database to the primary role at a point before the problem occurred, but you will likely incur some data loss

• On Physical Standby:

SQL> alter database recover managed standby database cancel;

SQL> alter database activate physical standby database;

SQL> shut immediate

SQL> startup

ACTIVATE immediately transitions the standby db to primary role without applying additional redo that might exist at standby site.

NOTE: Potential data loss

• Then re-create standby from this new primary db

Cancel Delay:

SQL> alter database recover managed standby database nodelay;

NOTE: For real time apply DELAY is ignored

Data Guard – Concepts

Refer the link for Data Guard – Concepts

Oracle Product Licensing – Where to look ?

Look here for price list of Oracle Products such as Oracle Databases, Management Packs etc

NOTE: The Document is the property of Oracle Corporation, cannot be reproduced JUST for educational purpose only and subject to change without notice.

Sangam12 – I’m Attending … How about you ?

This is the most awaited event in India and specially this year its all about Performance. So don’t miss it Guys!!!

I’m attending ..  Register Now !! @
http://www.sangam12.info/

 

 

 

 

 

 

Cheers

Raheel