Profile

Cover photo
Shony Thomas
95 followers|27,753,358 views
AboutPostsPhotosVideos

Stream

Shony Thomas

Shared publicly  - 
 
Steps to Recover Database from RMAN Backup TAG
RMAN Script Hear the
RMAN tag is TAG='TAG20160921T013645' run { allocate channel ch1 device type DISK; allocate channel ch2 device type DISK; restore database from TAG='TAG20160921T013645'; } Execution Steps $ > rman target / RMAN> shutdown
immediate; datab...
1
Add a comment...

Shony Thomas

Shared publicly  - 
 
Steps to Setup Data Guard Broker (DG BROKER) in Oracle 12c RAC Database with ASM
Assumption You have
setup the data guard in your primary & standby database and apply is
working properly. Steps
to Setup Data Guard Primary Configuration 1.       Create the
directory structure in Primary ASM as follows. Login as grid/oracle whichever
is t...
1
Add a comment...

Shony Thomas

Shared publicly  - 
 
ORA-16693: requirements not met for enabling fast-start failover
Error Description Even after
setting up all parameters, the data guard enable fast_start failover gives
following error. DGMGRL> enable fast_start failover Error:
ORA-16693: requirements not met for enabling fast-start failover Failed. Solution Description ...
1
Add a comment...

Shony Thomas

Shared publicly  - 
 
Fix OEM emctl Error: Backend WLS or EM application seems to be down
Problem Description Unable to
launch the OEM as it gives error Backend
WLS or EM application seems to be down   Solution Description Looks like
somewhere it is stuck even though it’s process running on the server. We have
to stop all related process and ref...
1
Add a comment...

Shony Thomas

Shared publicly  - 
 
How to Install Wireshark in RedHat Linux
These are the basic 3 steps to install wireshark software in RedHat
Linux. One of the basic use of wireshark software is we can monitor the port packet
transfer to verify the encryption etc. Note: you will
have to enable the xwindows (xming) in your server ...
1
Add a comment...

Shony Thomas

Shared publicly  - 
 
Fix DGMGRL Error: ORA-16698: LOG_ARCHIVE_DEST_n parameter set for object to be added
Error Description Dgmgrl
Create configuration command failed with following error DGMGRL>
CREATE CONFIGURATION 'DG_Conf' AS PRIMARY DATABASE IS 'CMLPROD' CONNECT
IDENTIFIER IS 'CMLPROD'; Error: ORA-16698: LOG_ARCHIVE_DEST_n
parameter set for object to be ad...
1
Add a comment...

Shony Thomas

Shared publicly  - 
 
Steps to Enable fast_start failover (automatic) in Data Guard(DG) Broker
Assumption: You have
setup the data guard and broker successfully and the apply is working properly Steps
to Setup Data Guard Steps
To Setup DG Broker Steps 1.       Enable the
flashback on both primary and standby database using following commands. SQL> Se...
1
Add a comment...

Shony Thomas

Shared publicly  - 
 
Steps to Setup / Configure Data Guard and Broker on Oracle 12c RAC ASM Multi Node Database
Assumptions Primary Scan              : CLUSCANPROD01 DB Name           : ADMPROD DB Unique Name    : ADMPROD Instances         : ADMPROD1
& ADMPROD2 PORT              : 1521 Version & Storage :
Oracle 12c with ASM Standby Scan              : CLUSCANSTY01 D...
1
Add a comment...

Shony Thomas

Shared publicly  - 
 
RMAN Restore Failed RMAN-06100: no channel to restore a backup or copy of datafile n
Problem Description Rman
restore command failed with following error. RMAN-06100: no channel to
restore a backup or copy of datafile RMAN> run { set newname for database to new; restore database; } executing command: SET NEWNAME Starting restore at 07-NOV-1...
1
Add a comment...

Shony Thomas

Shared publicly  - 
 
Fix ORA-15045 ORA-15120 ORA-27090: Unable to reserve kernel resources for as
Error Description Alter system
command fails with ORA-27090: Unable to reserve kernel resources for as SQL> alter system set db_securefile=PERMITTED scope=both
sid='*'; alter system set db_securefile=PERMITTED scope=both sid='*' * ERROR at line 1: ORA-01565...
1
Add a comment...

Shony Thomas

Shared publicly  - 
 
Fix (wireshark:29484): Pango-WARNING *: failed to choose a font, expect ugly output. engine-type='PangoRenderFc', script='latin'*
Error Description: Wireshark
software fails with following error. # wireshark (wireshark:29484):
Pango-WARNING **: failed to choose a font, expect ugly output.
engine-type='PangoRenderFc', script='latin' Solution Description Install the
liberation-sans-font...
1
Add a comment...

Shony Thomas

Shared publicly  - 
 
Golden Gate ggsci start manager: ERROR: Parameter file mgr.prm does not exist.
Error Description Oracle
GoldenGate ggsci start manager command fails with following error. [oracle@Node1 gogarep]$ ./ggsci GGSCI (Node1) 1> start manager ERROR: Parameter file /u01/app/oracle/product/12.1.0/gogarep/dirprm/mgr.prm does not exist. Solution D...
1
Add a comment...
Story
Tagline
Oracle Admin Professional
Introduction
Professionally Oracle Database Admin 
Basic Information
Gender
Male
Work
Occupation
IT Professional
Employment
  • Oracle Admin
Links
Contributor to