ols.pl – A script to display GI/RAC Flex Cluster

Oracle Clusterware command olsnodes displays node number/status/type/VIP, this is useful but not enough. To clearly display a node’s functional role in 12c, including but not limited to CRSD PE Master/Standby, CTSS/UI/ONS Master as well as Leaf-to-Hub connections etc, ols.pl is written to automatically present this info in a clear and handy way. You can download the […]

Read More

Missing braces on \o{} at clonedb.pl line 245, near “$lne’ , ‘$clonedbdir”

There is a known issue with clonedb.pl script,  you might end-up with “Missing braces on \o{} at clonedb.pl line 245, near “$lne’ , ‘$clonedbdir”  Especially if you are using perl Vv5.10.1. Actual Line: print OUTFILE1 “dbms_dnfs.clonedb_renamefile(‘$lne’,’$clonedbdir/\ora_data_$cldbname$i.dbf’); \n”;    lets Verify You will get the Error when this Line of code  executed and “\o” is the […]

Read More

Backup&Recovery(RMAN restore problem)

I took rman backup from RAC server to restore to another (new) RAC server.   This post is about some issues occurs face in RAC environment during the restore. RMAN> restore database; Starting restore at 09-OCT-15 using target database control file instead of recovery catalog allocated channel: ORA_DISK_1.1 channel ORA_DISK_1.1: sid=108 instance=prod1 devtype=DISK allocated channel: ORA_DISK_2.1 channel ORA_DISK_2.1: sid=107 […]

Read More

Safe Harbor Statement – Oracle

Safe Harbor Statement The following is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing […]

Read More

Display the sql_id for a query in Oracle 18c

The SET FEEDBACK command has an SQL_ID option to display the sql_id for the currently executed SQL or PL/SQL statements. The sql_id will be assigned to the predefined variable SQL_ID. Displays the number of records returned by a script when a script selects at least n records. SQL_ID returns the sql_id for the SQL or PL/SQL […]

Read More

SET LINESIZE window in Oracle 18c

Sets the total number of characters that SQL*Plus displays on one line before beginning a new line. WINDOW adjusts the linesize and pagesize for the formatted output according to the width and height of the screen. If the output is longer than the screen width, then the output is wrapped accordingly

To dynamically change […]

Read More

Oracle Database 18c and it’s features

Finally, Oracle officially released Oracle Database 18c with Oracle Documentation available on Oracle Public Cloud(OPC).  To get more detailed on Oracle 18c release read Oracle Support Document 2285040.1. List of some new features in Oracle 18c: Data Guard Oracle Data Guard Multi-Instance Redo Apply Supports Use of Block Change Tracking Files for RMAN Backups Automatic Correction […]

Read More

Network link in expdp

The export operation is performed with data that is consistent up to the specified SCN. If the NETWORK_LINK parameter is specified, then the SCN refers to the SCN of the source database. Follow following steps to the export database using network-link. Source database: demo Target database: uat Database platform : 11.2.0.4.0 Step 1 : Create a tnsnames.ora […]

Read More

Fast Application Notification [FAN] overview

As the Oracle docs say, The Oracle RAC, FAN, Oracle 12c Fast Application Notification (FAN) feature provides a simplified API for accessing FAN events through a callback mechanism. This mechanism enables third-party drivers, connection pools, and containers to subscribe, receive and process FAN events. These APIs are referred to as Oracle RAC FAN APIs. If […]

Read More