×

TNS-12541: TNS:no listener Use another port number Listener ORA-12528: TNS:listener: all appropriate instances are blocking new connections TNS-01155: Incorrectly specified SID_LIST_LISTENER parameter in LISTENER.ORA Disabling virbr0 interface on RHEL

☰ Service Startup Issues

×

RMAN-04006 :-- RMAN Duplicate Standby Creation Active Database To import tables from 11g to 10g Using External Table

☰ Backup and Recovery

×

DATA GUARD BROKER :-- ORA - 16826 LOG SHIPPING CHECK & MANUAL SWITCHOVER PHYSICAL STANDBY Data Guard Broker :-- Switchover and failover physical standby Active Data Guard and Snapshot Standby Database Converting Physical to standby when flashback is not on Converting physical to standby when flashback is on

☰ Data Guard

×

Configuring DNS for resolving SCAN IP in VM RAC Two Node Cluster Not able to ping Network Manager Issue in RHEL 7 D: Drive became Inaccessible How to Install rpm package on Linux How to change hostname in Linux ASM Disk Issue Oracle Database Installation Guide for Linux Oracle Database Post – Installation Task

☰ Installation

×

Locks in Oracle Database Oracle Wait Class Definition STATSPACK (Definition , Installation & Generation Report) STATSPACK ADMINISTRATION SAMPLE STATSPACK REPORT Reading statspack Report – P1 Reading statspack Report – P2 Parallel Processing Knowledge facts Update statement taking time to complete Enabling flashback, restore point and restore point in database Undo Table Analysis List of Oracle Wait Events 11.2.0.3 List of Oracle enqueue ORA-01031: insufficient privileges RDA :-- Remote Diagnostic Agent Oracle Wait Class Definition How to read statspack report Oracle Performance Tuning

☰ Performance tuning

×

Cluster verification Utility Sample Output Output of OCRCHECK Cluster startup error Adding node to 11gR2 Deleting a Node from 3 Node RAC

☰ RAC

×

Upgrading Oracle database 11.2.0.2 to 11.2.0.4 Oracle Database 11gR2 Version 11.2.0.3 Installation

☰ Database Upgradation

×

Scope Oracle Database 10g Some Useful Command Cluster Commands for 11gR2 Release 11.2.0.3 Common Oracle DBA Tasks Oracle Database Security

☰ Miscellaneous

Oracle Database Security

1)       Database Auditing

2)       Native Network Encryption

3)       String authentication (PKI,KERBEROS,RADIUS)

4)       Database Encryption

5)       Virtual Private Database (8i)

6)       Global Roles

7)       Enterprise User Security

8)       Proxy Authentication

9)       Oracle Label Security

10)    Client Identifier/Identity Propagation

11)    Secure Application Roles

12)    Fine Grained Auditing (9i)

13)    EM Configuration Scanning

14)    Transparent Data Encryption

15)    DB Security Evaluation

16)    Oracle Database Vault

17)    Oracle Audit Vault

18)    Data Redaction

19)    Oracle Key Vault

Common Oracle DBA Tasks

1)      Installing Oracle Software

2)      Creating Oracle database

3)      Performing upgrades of the database and software to new release levels

4)      starting and shutting down database instances

5)      Managing the storage structure of the databases

6)      Managing users and security

7)      Managing database objects such as tables,indexes and views

8)      Backing up the database and performing recovery operation when necessary

9)      Monitoring the state of the database and performing the recovery operation when necessary

10)   Monitoring and tuning database performance

11)   Diagnosing and reporting critical errors to oracle support services

Tools for Administering the database

1)      OUI :-- Oracle Universal Installer .. Install Oracle software and options .

2)      DBCA :-- Database Configuration Assistant .. For creating database , Managing Instance

3)      DBUA :-- Database Upgarde Assistant .. Guides you to install database from exisiting version to new version

4)      NETCA :-- Network Configuration Assistant ..enables to configures listeners and naming methods

5)      Oracle Enterprise Manager Database Control :-- Web Based Oracle Database Management Tool

Oracle Database 11gR2 Version 11.2.0.3 Installation

Note :-- # is root user
               $ is oracle user

Enviornment

1)      OS RHEL 5.8

2)      Database Version 11.2.0.3

3)      Filesystem

Steps

1)      Execute below command for pre-install the requisite
# yum install oracle-rdbms-server-11gR2-preinstall

2)      After transferring the software to server .unzip and set DISPLAY value

[oracle@rac4 software]$ export DISPLAY=192.168.56.1:0.0

[oracle@rac4 software]$ cd database

[oracle@rac4 database]$ pwd

/u03/software/database

[oracle@rac4 database]$ ls -ltr

total 64

-rwxr-xr-x  1 oracle oinstall  5466 Aug 22  2011 welcome.html

drwxr-xr-x 12 oracle oinstall  4096 Sep 18  2011 doc

-rwxr-xr-x  1 oracle oinstall  3226 Sep 22  2011 runInstaller

drwxr-xr-x  2 oracle oinstall  4096 Sep 22  2011 rpm

drwxr-xr-x  2 oracle oinstall  4096 Sep 22  2011 response

drwxr-xr-x  4 oracle oinstall  4096 Sep 22  2011 install

drwxr-xr-x 14 oracle oinstall  4096 Sep 22  2011 stage

drwxr-xr-x  2 oracle oinstall  4096 Sep 22  2011 sshsetup

-rwxr-xr-x  1 oracle oinstall 28122 Sep 22  2011 readme.html

 

3)      Execute runInstaller

[oracle@rac4 database]$ ./runInstaller

Starting Oracle Universal Installer...

 

Checking Temp space: must be greater than 120 MB.   Actual 8955 MB    Passed

Checking swap space: must be greater than 150 MB.   Actual 10236 MB    Passed

Checking monitor: must be configured to display at least 256 colors.    Actual 16777216    Passed

Preparing to launch Oracle Universal Installer from /tmp/OraInstall2015-04-16_05-22-12PM. Please wait ...[oracle@rac4 database]$

 

4)      Uncheck the “I wish to receive …”

5)      Click next .. Check Skip software updates

6)      Check install software only

7)      Check single instance database installation

8)      Select Language English

9)      select enterprise edition

10)   Specify path

11)   select value

12)   Fix any error or warning . If not click install

13)   Installation in progress

14)   Run the script as root user

[root@rac4 ~]# /u01/app/oracle/product/11.2.0/dbhome_2/root.sh

Performing root user operation for Oracle 11g

 

The following environment variables are set as:

    ORACLE_OWNER= oracle

    ORACLE_HOME=  /u01/app/oracle/product/11.2.0/dbhome_2

 

Enter the full pathname of the local bin directory: [/usr/local/bin]:

   Copying dbhome to /usr/local/bin ...

   Copying oraenv to /usr/local/bin ...

   Copying coraenv to /usr/local/bin ...

 

 

Creating /etc/oratab file...

Entries will be added to the /etc/oratab file as needed by

Database Configuration Assistant when a database is created

Finished running generic part of root script.

Now product-specific root actions will be performed.

Finished product-specific root actions.

[root@rac4 ~]#

15)   Look for the below message

The installation of oracle database was successful

16)   Run dbca after setting oracle home

17)   select create a database

18)   select general purpose or transaction processing

19)   provide database name

20)   click next for couple of screen and provide input as asked

 

Day 53.1:-- 04/15/2015

Cluster Commands for 11gR2 Release 11.2.0.3

Note :-- In Command database name is db and instance are db1,db2,db3
               $ ->> oracle user
               # ->> root user

After Cluster start execute below command to check cluster status

1)      crsctl check cluster –all

2)      crsctl status resource –t

Checking status of different component

1)      Checking CRS of specific node

n  $ crsctl check crs

2)      Checking database status

n  $ srvctl status database –d db

3)      Checking the instance status

n  $ srvctl status instance -d db -i db1,db2,db3

4)      service status

n  $ srvctl status service –d db

5)      nodeapps status

n  $ srvctl status nodeapps

6)      asm status

n  $ srvctl status asm

7)      type status

n  $ crsctl status type

8)      ip status

n  $ crsctl status ip -A {<IP_name>|<IP_address>}

9)      server status

n  $ crsctl status server

10)   serverpool status

n  $ crsctl status serverpool

11)   testdns status

n  $ crsctl status testdns

12)   cvu status

n  $ srvctl status cvu

13)   Datagroup status

n  $ srvctl status diskgroup -g data_dg1

14)   filesystem status

n  $ srvctl status filesystem -d db

15)   gns status

n  $ srvctl status gns

16)   home status

n  # srvctl status home -o /u02/app/11.2.0.3/grid -s as -n rac1

17)   Listener status

n  $ srvctl status listener

18)   oc4j status

n  $ srvctl status oc4j

19)   SCAN VIP status

n  $ srvctl status scan

20)   scan_listener status

n  $ srvctl status scan_listener

21)   srvpool status

n  $ srvctl status srvpool

22)   vip status

n  $ srvctl status vip –n rac1

Check Configuration of different component

23)   config database

n  $ srvctl config database –d db

24)   config service

n  $ srvctl config service –d db

25)   config nodeapps

n  $ srvctl config nodeapps

26)   config asm

n  $ srvctl config asm

27)   config listener

n  $ srvctl config listener

28)   config has

n  # crsctl config has

29)   config cvu

n  $ srvctl config cvu

30)   config filesystem

n  $ srvctl config filesystem –d db

31)   config gns

n  $ srvctl config gns

32)   config oc4j

n  $ srvctl config oc4j

33)   config scan-vip

n  $ srvctl config scan

34)   config scan listener

n  $ srvctl config scan_listener

35)   config srvpool

n  $ srvctl config srvpool

36)   config vip

n  $ srvctl config vip –n rac1

Checking getenv of different component

37)   getenv asm

n  $ srvctl getenv asm

38)   getenv database

n  $ srvctl getenv database -d db

39)   getenv listener

n  $ srvctl getenv listener

40)   getenv nodeapps

n  $ srvctl getenv nodeapps

 

Deleting a Node from 3 Node RAC

Note :-- command are marked as orange

Enviornment

1)      RHEL 5.8

2)      Database/Cluster Version 11.2.0.3

3)      GRID_HOME and ORACLE_HOME not shared across node

Steps

1)      login to node 1  rac1 and run the below command

2)      olsnodes –s –t

[oracle@rac1 ~]$ /u02/app/11.2.0.3/grid/bin/olsnodes -s -t

rac1    Active  Unpinned

rac2    Active  Unpinned

rac3    Active  Unpinned

 

If the node is pinned, then run the crsctl unpin css command. Otherwise, proceed to the next step.

3)      Login to the node which needs to be deleted stop emagent

4)      /u01/app/oracle/product/11.2.0.3/db_1/bin/emctl stop dbconsole

5)      login to node 3 which needs to be deleted . Run below command for stopping the cluster running on node3

login as root user
# /u02/app/11.2.0.3/grid/crs/install/rootcrs.pl –deconfig –force

6)      login to node 1 and run the following command as root user

# /u02/app/11.2.0.3/grid/bin/crsctl delete node –n rac3

7)      login to node 3 as grid user say oracle run the below command

$/u02/app/11.2.0.3/grid/oui/bin/runInstaller -updateNodeList ORACLE_HOME=Grid_home "CLUSTER_NODES={rac3}" CRS=TRUE -silent –local

8)      login to node 3run the command  as grid user say “oracle”
$/u02/app/11.2.0.3/grid/deinstall/deinstall –local

9)      login to node 1 and run the below command as grid user say “oracle”

$/u02/app/11.2.0.3/grid/oui/bin/runInstaller -updateNodeList ORACLE_HOME=Grid_home "CLUSTER_NODES={rac1,rac2}" CRS=TRUE –silent

10)   Run the command from node 1 as grid user say “oracle”

$ /u02/app/11.2.0.3/grid//bin/cluvfy stage -post nodedel -n rac3

Reference Link :-- http://docs.oracle.com/cd/E11882_01/rac.112/e41959/adddelclusterware.htm#CWADD90995