Oracle 11g: Use Direct NFS for Datafiles

Oracle 11g (11.1.1) : Use Direct NFS for Datafiles: -

With Oracle Database 11g release 1 (11.1), instead of using the operating system kernel NFS client, you can configure Oracle Database to access NFS V3 servers directly using an Oracle internal Direct NFS client.

To enable Oracle Database to use Direct NFS, the NFS file systems must be mounted and available over regular NFS mounts. The mount options used are not relevant, as Direct NFS manages settings after installation.

You can use optional oranfstab (in eighter/etc or to $ORACLE_HOME/dbs.) to specify additional paths for a mount point.   

Direct NFS determines mount point settings to NFS storage devices based on the configurations in /etc/mtab, which are changed with configuring the /etc/fstab file.
Direct NFS searches for mount entries in the following order:

1. $ORACLE_HOME/dbs/oranfstab
2. /etc/oranfstab
3. /etc/mtab

Direct NFS uses the first matching entry found.

Direct NFS can use up to four network paths defined in the oranfstab file for an NFS server. The Direct NFS client performs load balancing across all specified paths. If a specified path fails, then Direct NFS reissues I/O commands over any remaining paths

Complete the following procedure to enable Direct NFS:

1. Create an oranfstab file
2. use an ODM library, libnfsodm11.so, to enable Direct NFS

1. Sample oranfstab file

server:  MyDataServer1
path:  132.34.35.12
path:  132.34.35.13
export: /vol/oradata1 mount: /mnt/oradata1
 
server: MyDataServer2
path:  NfsPath1
path:  NfsPath2
path:  NfsPath3
path:  NfsPath4
export: /vol/oradata2 mount: /mnt/oradata2
export: /vol/oradata3 mount: /mnt/oradata3
export: /vol/oradata4 mount: /mnt/oradata4
export: /vol/oradata5 mount: /mnt/oradata5

2. Steps to use ODM NFS Library.

1. Change directory to $ORACLE_HOME/lib.
2. Enter the following commands:
   

   mv libodm11.so libodm11.so_stub
   ln -s libnfsodm11.so libodm11.so

TNS-12502: TNS:listener received no CONNECT_DATA from client

TNS-12502: "TNS:listener received no CONNECT_DATA from client"

*Cause:  No CONNECT_DATA was passed to the listener.

*Action: Check that the service name resolved from TNSNAMES.ORA has the CONNECT_DATA component of the connect descriptor.

If you getting this error while registering database services with listener using local_listener or remote_listener problem might be with sqlnet.ora and tnsnames.ora setting not implemented by current instance and restarting the instance again after setting TNS_ADMIN parameter might resolve the problem.

Case Study : Implementing TCPS authentication
1. Once you have create all the configuartion and Listener to use TCPS connection and if listener is running on non default port, you would have to set local_listener parameter to register your database with new listener (TCPS). When you creating TNS alias for local_listener, you don't specify connect_data parameter as its not required for service register, however service registration will fail with  TNS-12502 in listener.log until database instance is bounced.
Bouncing/Restarting the instance will read sqlnet.ora , tnsnames.ora with new security config and listener will be able to register the new service on TCPS port.

Install Weblogic Server 10.3.2.0 for Grid Control 11gR1

To Install Weblogic Server 10.3.2 on Linux X64 , download wls1032_generic.jar from oracle.com


$lynx http://download.oracle.com/otn/nt/middleware/11g/wls/wls1032_generic.jar

$ java -jar wls1032_generic.jar

Extracting 0%....................................................................................................100%

Unable to instantiate GUI, defaulting to console mode. - Weblogic Install

$ ./wls1032_linux32.binExtracting 0%....................................................................................................100%


Unable to instantiate GUI, defaulting to console mode.
<---------------------------------------------------------- Oracle Installer - WebLogic 10.3.2.0 --------------------------------------------------------->
Welcome:
--------
This installer will guide you through the installation of WebLogic 10.3.2.0. Type "Next" or enter to proceed to the next prompt. If you want to changedata entered previously, type "Previous". You may quit the installer at any time by typing "Exit".
Enter [Exit][Next]>

Solution :

Required java is missing on the server or weblogic server installer is failed to find one.
Install SUN JDK 1.6_18 or higher from sun/Oracle Website.

http://www.oracle.com/technetwork/java/javase/downloads/jdk6-jsp-136632.html

If problem persists.
Set JAVA_HOME

$java -fullversion

java full version "1.6.0_21-b06"

& Try Installing again.

Oracle Grid Control 11g Installation

Oracle 11g Grid Control no longer run on Oracle application server, you have to install Middleware Infrastructure Weblogic Server 10.3.2 before GC 11g.

We Can use the following sequence to Install the Grid Control Environment.

1  Install ORacle 11.2.0.1 database and Patches
2. Create database to be used for Grid Repository
3. Install Weblogic Server 10.3.2 and patches.
4. Install Grid Control Software.
5. Install Grid Agent on all the Servers.



1.1 Install RDBMS Software 11.2.0.1
1.2 Install patch.
NON RAC -  9654983  - Opatch apply - Oracle user
GI + RAC - 9655006  - Opatch auto  - root user

1.3 Create Listener with PORT 1521 or


2.1 Create Database  using DBCA or sqlplus command Line.


2.2 If you have created the database with default parameters, change the following parameters to ensure its meet minimum requirement for OMS.

sqlplus "/ as sysdba"
alter system set session_cached_cursors=210 scope=spfile;
alter system set processes=550 scope=spfile;

Ensure Undo tablespace is aleast 200m size;

-- bounce the database to ensure parameter are effective.
Startup force;

2.3 Deconfigure the EM REporsitory to avoid any failure.

$ORACLE_HOME/bin/emca -deconfig dbcontrol db -repos drop -sys_PWD -SYSMAN_PWD

Enter the following Information :
Database SID:
Listener port number :
Password for SYS user:

3.1 WLS 10.3.2
Install WLS and JDK 1.6

3.2 Apply Patches. using $BASE/Middleware/utils/bsu

$./bsu.sh

8990616, 9100465, and 9221722

4.0 Install Management Server. ( Grid Control Server).

4.1 Unzip Grid control Installer
4.2 run Installer

./runInstaller


Complete Install by running allroot.sh  from Middleware/oms11g/allroot.sh

5. Install Grid Agent on all the Servers.

cd /u03/app/product

32 bit Linux :-
wget http://host1.servers.com:4889/agent_download/11.1.0.0.0/linux/agentDownload.linux  --no-check-certificate

chmod +x agentDownload.linux

./agentDownload.linux -b /u02/agent11gr2 -m servername.domain. -r 4489

64bit Linux :- 

wget http://host1.servers.com:4889/agent_download/11.1.0.0.0/linux_x64/agentDownload.linux_x64  --no-check-certificate

chmod +x agentDownload.linux_x64

./agentDownload.linux_x64 -b /u02/agent11gr2 -m servername.domain. -r 4489 

Note :You might need to use -y option to ensure , agent registration password prompt you.

Oracle 11g OCM - Oracle Database 11g Certified Master Exam

Exam Topics:

Oracle 11g OCM upgrade exam will be covering Eight Scenario's covering the following in 2 Full day Exam :

Server Configuration [  ] Create the database [  ] Determine and set sizing parameters for database structures [  ] Create and manage temporary, permanent, and undo tablespaces [  ] Stripe data files across multiple physical devices and locations [  ] Configure the database environment to support optimal data access performance [  ] Create and manage database configuration files [  ] Create and manage bigfile tablespaces [  ] Create and Manage a tablespace that uses NFS mounted file system file [  ] Create and manage multiple network configuration files [  ] Create and configure a listener [  ] Configure the database instance to support shared server connections [  ] Set up network tracing [  ] Manage Oracle network processes [  ] Configure the network environment to allow connections to multiple databases [  ] Use configurationless connections [  ] Use Grid Infrastructure to manage oracle databases and other resources. Enterprise Manager Grid Control [  ] Install and Patch Enterprise Manager Grid Control software [  ] Configure the Enterprise Manager repository [  ] Create Enterprise Manager Grid Control users [  ] Use Enterprise Manager to modify a database configuration [  ] Configure Enterprise Manager to modify a database availability [  ] Create and manage jobs [  ] Create and monitor alerts [  ] Create notifications [  ] Implement Grid Control and Database Control [  ] Choose the appropriate tablespace type for the intended use [  ] Create Scheduler jobs [  ] Create schedules [  ] Assign jobs to windows [  ] Create programs [  ] Create job classes [  ] Install the Enterprise Manager Grid Control infrastructure [  ] Deploy Enterprise Manager Grid Control agents [  ] Configure Grid Control for business requirements  For more detail Follow :-

Managing Database Availability [  ] Mantain recovery catalogs. [  ] Configure Recovery Manager [  ] Use Recovery Manager to perform database backups [  ] Use Recover Manager to perform complete database restore and recovery operations [  ] Configure RMAN [  ] Create different types of RMAN backups to cater for different performance and retention requirements [  ] Set Flashback Database parameters [  ] Configure a Fast Recovery Area [  ] Perform various recovery operations using Flashback technology  Data Management [  ] Manage Materialized Views to improve rewrite and refresh performance [  ] Configure and manage distributed materialized views [  ] Create and Manage encrypted tablespaces [  ] Manage Transport of tablespaces across platforms [  ] Configure a schema to support a star transformation query [  ] Administer external tables [  ] Implement Data Pump export and import jobs for data transfer [  ] Implement Data Pump to and from remote databases [  ] Configure and use parallel execution for queries [  ] Use SQL*Loader [  ] Administer, manage and tune parallel execution Data Warehouse Management [  ] Administer partitioned tables and indexes using appropriate methods and keys [  ] Perform partition maintenance operations [  ] Maintain indexes on a partitioned table [  ] Implement securefile LOB [  ] Create and manage LOB segments [  ] Implement fine-grained access control [  ] Create and manage contexts [  ] Administer flashback data archive and schema evolution [  ] Configure and Manage Streams for Capture, Propagation and Apply.

Performance Management [  ] Administer Resource Manager [  ] Use Result Cache [  ] Use multi column statistics [  ] Gather statistics on a specific table without invalidating cursors [  ] Use partitioned indexes [  ] Administer and tune schema object to support various access methods [  ] Interpret execution plan [  ] Use SQL tuning tools and features [  ] Use SQL Tuning Advisor [  ] Use SQL Access Advisor [  ] Use SQL Performance Analyzer [  ] Configure baseline templates [  ] Use SQL Plan Management feature [  ] Implement instance caging Real Application Clusters [  ] Install Oracle Grid Infrastructure [  ] Create ASM Disk Groups [  ] Create and manage as ASM instance [  ] Creating ACFS File System [  ] Start,Stop Configure and Administer Oracle Grid Infrastructure [  ] Install the Oracle Database 11gR2 software [  ] Configure ASM for the shared disks and create a clustered database [  ] Implement ASM failure groups [  ] Configure archiving [  ] Configure Services using both Manual and Policy Managed Methods Data Guard [  ] Create Physical Standby Database with real-time apply. [  ] Configure the data guard environment to reduce overheads of fast incremental backups on the primary database [  ] Configure the Observer [  ] Switchover and switch back [  ] configure connect time failover [  ] Convert the standby to a snapshot standby [  ] Configure archivelog deletion policy for the dataguard configuration

http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=41&p_org_id=&lang=&p_exam_id=11gOCM

Oracle Database 11g Certified Master Upgrade Exam

Exam Topics :

Oracle 11g OCM upgrade exam will be covering four task covering the following.

Database, RMAN, EM and Network Configuration [  ] Configure server-side network [  ] Configure client-side network [  ] Create and Manage encrypted tablespaces [  ] Create and Manage a tablespace that uses NFS mounted file system file [  ] Set up ADR file based repository [  ] Perform cold database backup [  ] Manage user accounts and use case sensitive passwords [  ] Use OPatch to install a patch [  ] Install and configure EM Agent [  ] Create Base Recovery Catalog [  ] Configure RMAN [  ] Perform multisection backup of a datafile [  ] Create an Archival Backup Data Guard [  ] Create Physical Standby Database with real-time apply. [  ] Configure the data guard environment to reduce overheads of fast incremental backups on the primary database [  ] Configure the Observer [  ] Switchover and switch back [  ] Convert the standby to a snapshot standby [  ] Configure archivelog deletion policy for the dataguard configuration

Data and Data Warehouse Management [  ] Troubleshoot fast materialized views to fast refresh and query rewrite [  ] Add a tablespace by using Transportable Tablespace Feature of Data Pump Import (cross platform transportable tablespace) [  ] Configure a schema to support a star transformation query [  ] Configure and use parallel execution for queries [  ] Use and access SecureFile LOBS [  ] Create partitioned tables (includes reference and interval partitioning) [  ] Configure Flashback Data Archive [  ] Use Oracle Streams to capture and propagate changes in a table Performance Management [  ] Set up and configure Resource Manager to control active sessions, number of I/Os, execution time..etc [  ] Use Result Cache [  ] Use multi column statistics [  ] Gather statistics on a specific table without invalidating cursors [  ] Use partitioned indexes [  ] Use SQL Tuning Advisor [  ] Use SQL Access Advisor [  ] Configure baseline templates [  ] Use SQL Plan Management feature [  ] Replay a captured workload