Rman: Ora-01008 When Connecting To Target in 11.2.0.2

Metalink note : [ID 1280447.1]

symptons

DBGSQL:     TARGET> select  nvl(max(al.recid), '0'),nvl(max(al.recid), 0)   into  :txtparmvalue, :parmvalue   from  v$archived_log al  where  al.status in ('X', 'A')    and  al.is_recovery_dest_file = 'YES'    and  al.creator = 'RMAN'

DBGSQL:        sqlcode = 1008

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of backup plus archivelog command at 04/26/2011 19:00:15

RMAN-03014: implicit resync of recovery catalog failed

ORA-01008: not all variables bound

Cause

It's a bug with a patch

Solution

It's a bug with a patch. Workaround is to :

SQL> alter system flush shared_pool;

Hope this helps! Rupam

diagnostic_dest, ADR_BASE_LISTENER, ADR_BASE

Changing the default location of logs and trace files in 11g

setting the diagnostic destination for 11gR2 servers to /oramisc01/oracle -

Make the following changes:

/ora01/oracle/admin/network/sqlnet.ora - added the line 'ADR_BASE=/oramisc01/oracle'

/ora01/oracle/admin/network/listener.ora - added the line 'ADR_BASE_LISTENER=/oramisc01/oracle'  

   (may not take effect until the listener is restarted or reloaded)

ASM instance - set the init value 'diagnostic_dest='/oramisc01/oracle'

Database – set the init value 'diagnostic_dest='/oramisc01/oracle'

Agent11gHome/network/admin/sqlnet.ora - added the line 'ADR_BASE=/oramisc01/oracle'

Hope this helps! Rupam

Oracle11g Upgrade

Oracle11g Workshop

Notes from 11g Oracle workshop

ADR_BASE_LISTENER for listener log adn trace files

ADR_BASE_LISTENER directory

To Change the adr directory for listener from default

Make Changes in listener.ora file

 e.g. ADR_BASE_LISTENER = /oralog/oracle

example:

/oralog/oracle/oradiag_oracle/diag/clients/user_oracle/

Hope this helps. Regards Rupam

change adrci destination

How to change adrci diagnostics destination in 11g.

Steps :

1. sqlplus as sysdba

2. check current diagonostic destination

adrci alert

ADRCI  alert

 

Log into the oracle user.

Set Oracle database environment, using

. oraenv

Start the ADR command line interpreter(ADRCI) by issuing the following command in the database directory:

adrci purge

ADRCI  purge

The automated purge policy for Diagnostic data includes incident and problem descriptions, trace files, dumps, health monitor reports, alert log entries, and more are governed by policy setting. 

Cleanup is done by MMON background process.

adrci commands

ADRCI  commands

Log into the oracle user.

Set Oracle database environment, using

. oraenv

Start the ADR command line interpreter(ADRCI) by issuing the following command in the database directory:

adrci

ADRCI: Release 11.2.0.2.0

ADR base = "/ora01/oracle"

adrci

ADR command line interpreter(ADRCI)

ADRCI enables you to:

• View diagnostic data within the Automatic Diagnostic Repository (ADR).
• View Health Monitor reports.
• Package incident and problem information into a zip file for transmission to Oracle Support.
  

Oracle Active Data Guard

How Oracle Active Data Guard can help your organization ?

Check this Video on Youtube

Duplicate Database Using RMAN Active Database

New Feature in Oracle 11g

Overview

Oracle Database 11g RMAN introduces the FROM ACTIVE DATABASE capability to the DUPLICATE command.

Oracle Database Release

Oracle Database 11g Release 2
Standard Edition, Standard Edition One, and Enterprise Edition

Reference :  Oracle Database Software Downloads

Oracle Restart

New Feature in Oracle 11g

     
Use Oracle Restart to Automatically Restart Your Database 
 

Oracle Restart is a new feature included in this release to enhance the availability of Oracle databases in a single-instance environment. 

If you install Oracle Restart, and there is a temporary failure of any part of the Oracle Database software stack, including the database, listener, and Oracle ASM instance, Oracle Restart automatically restarts the failed component. In addition, Oracle Restart starts all these components when the database host computer is restarted. The components are started in the proper order, taking into consideration the dependencies among components.

Oracle Restart runs periodic check operations to monitor the health of these components. If a check operation fails for a component, the component is shut down and restarted.

Oracle Restart is used in standalone server (non-clustered) environments only. For Oracle Real Application Clusters (Oracle RAC) environments, the functionality to automatically restart components is provided by Oracle Clusterware.

Viewing the Oracle Restart Configuration for a Component

srvctl config database              # list databases on the server

srvctl config database -d orcl   # view restart configuration

Viewing Component Status

srvctl status database -d orcl

Creating and Deleting Database Services with SRVCTL

srvctl add service -d db_unique_name -s service_name [options]

srvctl remove service -d db_unique_name -s service_name [-f] 

srvctl add service -d dbcrm -s crmbatch -l PHYSICAL_STANDBY  # Role-Based Database Service

Reference: http://download.oracle.com/docs/cd/E11882_01/server.112/e17120/restart002.htm#BABHJFIH

SCAN Listener

SCAN Listener

New Feature in Oracle 11g

Single Client Access Name (SCAN) allows clients to use one name in connection string to connect to the cluster as a whole.  

Why SCAN listener?

1. Removes the requirements to change the client connect if cluster changes were made

2. Load Balance across the instance providing a service

3. Failover between moved instance

Note: REMOTE_LISTERNER register the instance with all SCAN listeners.

 

How to Configure SCAN listener in RAC?

# Prerequite

the SCAN name with three ip addresses assigned via DNS in round robin fashion

# Configure

In the step 4 of 16 of Oracle Grid Instrastructure/Install and Configure Grid Infrastructure of a grid

# listener.ora

LISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER))))

   

LISTENER_SCAN1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))) 

LISTENER_SCAN2=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN2)))) 

LISTENER_SCAN3=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN3)))) 

ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1=ON      
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN2=ON      
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN3=ON          

ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON                     

# endpoints_listener.ora
   LISTENER_LNX200=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=lnx200-vip)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=10.10.10.10)(PORT=1521)(IP=FIRST))))           # line added by Agent

# tnsnames.ora

ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = ORACL01.com)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )

# start/stop sequence

srvctl start listener

srvctl start scan

srvctl start scan_listener

stop in the same order as above

# How to check config

srvctl config  listener

srvctl config  scan

srvctl config  scan_listener

# How to check status

srvctl status listener

srvctl status scan

srvctl status scan_listener

crs_stat in 11g

Check 11g Grid Status, shows RAC database Up/Down Status

#!/usr/bin/ksh

#  works on linux

# Description:

# - Returns formatted version of crs_stat -t, in tabular

# format, with the complete rsc names and filtering keywords

# - The argument, $RSC_KEY, is optional and if passed to the script, will

# limit the output to HA resources whose names match $RSC_KEY.

# Requirements:

# - $ORA_CRS_HOME should be set in your environment

# Modifications

# 5/2010 - use oraenv to set the environment, grid must be in oratab

# - check if search argument is null and substitute .* to create a valid syntax for Solaris

ORACLE_SID=grid;ORAENV_ASK=NO;. oraenv;ORAENV_ASK=YES

# If search argument is null, substitute .*, meaning match anything

if [[ -z $1 ]]; then

RSC_KEY='.*'

else

RSC_KEY=$1

fi

#QSTAT=-u

QSTAT=-l

AWK=/bin/awk

$ORACLE_HOME/bin/crs_stat $QSTAT | $AWK \

'BEGIN {printf "%-45s %-10s %-18s\n", "HA Resource", "Target", "State";

printf "%-45s %-10s %-18s\n", "-----------", "------", "-----";

FS="="; state = 0 }

$1~/NAME/ && $2~/'$RSC_KEY'/ { appname=$2; state=1}

state == 0 {next}

$1~/TARGET/ && state == 1 {apptarget = $2; state=2}

$1~/STATE/ && state == 2 {appstate = $2; state=3}

state == 3 {printf "%-45s %-10s %-18s\n", appname, apptarget, appstate; state=0}'