Blog | IT Knowledge

Hanh Nguyen

Oct 30, 20151 min read

HACMP – ADD Virtual IP

A. Set the speed to the interface to the same as that set on the switch port. Default is auto. eg. chdev -l entX -a...

0 views0 comments

Hanh Nguyen

Oct 30, 20151 min read

HACMP Command

clstat – show cluster state and substate; needs clinfo. cldump – SNMP-based tool to show cluster state. cldisp – similar to cldump, perl...

3 views0 comments

Hanh Nguyen

Oct 30, 20158 min read

AIX – UNIX DISK SANITIZATION

dd if=/dev/zero of=/path/to/device bs=65536 None rootvg : for disk in $(lspv | awk ‘{print $1}’) ; do dd if=/dev/zero of=/dev/r${disk}...

0 views0 comments

Hanh Nguyen

Oct 30, 20155 min read

AIX Command

oslevel shows the actual BOS level oslevel -r shows the TL level (or earlier ML)...

0 views0 comments

Hanh Nguyen

Oct 30, 20153 min read

Network command for AIX

# lsdev –Cc adapter # lsdev –Cc if Where If stands for the Interface. This command will check how many interfaces are available. Each...

0 views0 comments

Hanh Nguyen

Oct 30, 201526 min read

AIX Basic command for Administrator

1. Daily command Find . -name “*.*” -size +1024k -print | xargs /usr/bin/ls -lrt 1.1 Increse file size...

0 views0 comments

Hanh Nguyen

Oct 24, 20153 min read

How to Rename or Move Datafiles and Logfiles

Scope This bulletin gives instructions to: I. RENAME OR MOVE DATAFILE(S) WITH THE DATABASE OPEN II. RENAME AND OR MOVE DATAFILE(S) WITH...

0 views0 comments

Hanh Nguyen

Oct 24, 20158 min read

Performing Basic Tasks in Oracle Multitenant

Purpose This tutorial covers the steps to perform basic tasks on container databases (CDBs) and pluggable databases (PDBs). Time to...

1 view0 comments

Hanh Nguyen

Oct 24, 20152 min read

Multitenant best Practice and Known issues

Details 1.Consider to always use tnsnames when connecting to either Container or Pluggable instance The tnsnames.ora should be configured...

0 views0 comments

Hanh Nguyen

Oct 24, 20151 min read

How To Automate The Opening Of Pluggable Databases After The CDB Starts Up

How to automate the opening of pluggable databases after the Container DataBase (CDB) starts up? Solution Create a database startup...

1 view0 comments

Hanh Nguyen

Oct 24, 20153 min read

Applying a 12c GI PSU With opatchauto in GI Cluster or Standalone Environment

Steps 1. Download the latest 12.1 version of opatch patch 6880880 and unzip to all 12.1 homes as corresponding owner. In this example,...

0 views0 comments

Hanh Nguyen

Oct 24, 20152 min read

Applying a 12c GI PSU With opatchauto in non-rolling Mode

Steps 1. Download the latest 12.1 version of opatch patch 6880880 and unzip to all 12.1 homes as corresponding owner. In this example,...

1 view0 comments

Hanh Nguyen

Oct 22, 20151 min read

How to Restrict User from Connecting to Database Through Specific Ip Address

The example below explains how to restrict user shy from accessing database from IP address 159.09.208.953 Step 1:- Create the following...

0 views0 comments

Hanh Nguyen

Oct 22, 20158 min read

Oracle Solaris 11 – General Administration

Installation Automated Installer (AI) is the new network based multi-client provisioning system on Oracle Solaris 11. AI provides...

0 views0 comments

Hanh Nguyen

Oct 22, 201512 min read

AIX Hardening using aixpert – CIS for AIX 6.1

From root account, # aixpert -f aixpert_aix6.1.xml Content of aixpert_aix6.1.xml <?xml version=”1.0″ encoding=”UTF-8″?> <!– CIS AIX 6.1...

0 views0 comments

Hanh Nguyen

Oct 8, 20151 min read

Auto startup/shutdown Oralce DB in AIX

Auto start database (call emas) To auto start Edit oratab and change from emas:/u01/app/oracle/product/11.2.0/dbhome_1:N to ...

0 views0 comments

Hanh Nguyen

Oct 4, 20153 min read

Steps to perform for Rolling forward a standby database using RMAN incremental backup when primary a

Solution 1) On the standby database, stop the managed recovery process (MRP) SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;...

0 views0 comments

Hanh Nguyen

Oct 4, 20153 min read

How To Open Physical Standby For Read Write Testing and Flashback

Solution Using a combination of Data Guard, restore points, and Flashback Database, a physical standby database can be opened temporarily...

1 view0 comments

Hanh Nguyen

Oct 4, 20153 min read

How to Rename or Move Datafiles and Logfiles

How to Rename or Move Datafiles and Logfiles: ============================================= NOTE: To rename or relocate datafiles in the...

0 views0 comments

Hanh Nguyen

Oct 4, 201513 min read

How to Perform a Health Check on the Database

Scope and Application Parameter file 2. Controlfiles 3. Redolog files 4. Archiving 5. Datafiles 5.1 Autoextend 5.2 Location 6....

5 views0 comments