CONFIGURACION LISTENER CLUSTER ORACLE RAC

grid@USBLDDB1010:/u02/scripts/cluster$ srvctl status scan_listener
SCAN Listener LISTENER_SCAN1 is enabled
SCAN listener LISTENER_SCAN1 is not running
SCAN Listener LISTENER_SCAN2 is enabled
SCAN listener LISTENER_SCAN2 is running on node usblddb2011
SCAN Listener LISTENER_SCAN3 is enabled
SCAN listener LISTENER_SCAN3 is running on node usblddb2011
grid@USBLDDB1010:/u02/scripts/cluster$ srvctl start scan_listener -i 1
grid@USBLDDB1010:/u02/scripts/cluster$ srvctl status scan_listener
SCAN Listener LISTENER_SCAN1 is enabled
SCAN listener LISTENER_SCAN1 is running on node usblddb1010
SCAN Listener LISTENER_SCAN2 is enabled
SCAN listener LISTENER_SCAN2 is running on node usblddb2011
SCAN Listener LISTENER_SCAN3 is enabled
SCAN listener LISTENER_SCAN3 is running on node usblddb2011
grid@USBLDDB1010:/u02/scripts/cluster$ srvctl status scan_listener
SCAN Listener LISTENER_SCAN1 is enabled
SCAN listener LISTENER_SCAN1 is running on node usblddb1010
SCAN Listener LISTENER_SCAN2 is enabled
SCAN listener LISTENER_SCAN2 is running on node usblddb2011
SCAN Listener LISTENER_SCAN3 is enabled
SCAN listener LISTENER_SCAN3 is running on node usblddb2011
grid@USBLDDB1010:/u02/scripts/cluster$

srvctl stop scan_listener -i 1
srvctl stop scan_listener -i 2
crsctl status resource ora.LISTENER_SCAN1.lsnr -f

cat listener.ora

LISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER))))            # line added by Agent
LISTENER_SCAN3=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN3))))                # line added by Agent
LISTENER_SCAN2=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN2))))                # line added by Agent
LISTENER_SCAN1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1))))                # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1=ON                # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN2=ON                # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN3=ON                # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON              # line added by Agent


srvctl start scan_listener -i 1

PARA MODIFICAR PARAMETROS

crsctl modify resource "ora.asm" -attr "CHECK_TIMEOUT=120"

ZFS ORACLE SOLARIS 11

# zpool list

root@USBLDDB1010:~# echo ::memstat | mdb -k
Page Summary                 Pages             Bytes  %Tot
----------------- ----------------  ----------------  ----
Kernel                     1821920             13.8G    7%
Guest                            0                 0    0%
ZFS Metadata                855113              6.5G    3%
ZFS File Data             16590634            126.5G   61%
Anon                       5709759             43.5G   21%
Exec and libs                64078            500.6M    0%
Page cache                   30399            237.4M    0%
Free (cachelist)              4021             31.4M    0%
Free (freelist)            2187052             16.6G    8%
Total                     27262976              208G
You have new mail in /var/mail/root

In case the amount of ZFS File Data is too high on the system, you might to consider to limit the ARC cache
by setting zfs:zfs_arc_max in /etc/system
set zfs:zfs_arc_max = [size]
i.e. limit the cache to 1 GB in size
set zfs:zfs_arc_max = 1073741824

CLOUD CONTROL

u01/app/Middleware/oms/bin$ ./emctl start oms
Oracle Enterprise Manager Cloud Control 12c Release 4 
Copyright (c) 1996, 2014 Oracle Corporation.  All rights reserved.
Starting Oracle Management Server...
Starting WebTier...
WebTier Successfully Started
Oracle Management Server Already Started
Oracle Management Server is Up

./emctl status oms -details

alter profile

ALTER PROFILE default LIMIT
  PASSWORD_VERIFY_FUNCTION null;

DUPLICATE NOREDO

RMAN-05541: no archived logs found in target database

Problem:

You are getting  RMAN-05541 error when duplicating database from a consistent (cold) RMAN backup.

Error Message:

RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of Duplicate Db command at 07/08/2014 18:12:40 RMAN-05501: aborting duplication of target database RMAN-05541: no archived logs found in target database

Solution:

The error should be resolved by using NOREDO clause for your duplicate command.

Example:

run { set until time "to_date('08-OCT-2014 10:15:00','DD-MON-YYYY HH24:MI:SS')"; DUPLICATE DATABASE TO targetDB BACKUP LOCATION '/backup_Location' NOREDO;

AIX Comandos

How to get network interface info in AIX?

# entstat (for AIX)