Archive

Archive for April, 2011

Steps to configure ASM without using dbca(10.2.0.5)

April 28, 2011 Leave a comment

In this article i will discuss steps to create ASM instance without using DBCA.

Environment:

OS:Red Hat Enterprise Linux AS release 4 (Nahant Update 8)
*emgcl10g*:/u01/app/root/product/10.2.0/asm=>uname -a
Linux emgcl10g.ukatru.com 2.6.9-89.0.0.0.1.EL #1 Tue May 19 05:21:57 EDT 2009 x86_64 x86_64 x86_64 GNU/Linux

ORACLE_HOME=/u01/app/root/product/10.2.0/asm
ORACLE_SID=+ASM
ORACLE VERSION : 10.2.0.5

Step1)Check CSS(Cluster Sysncronization service) is running or not

*emgcl10g*:/u01/app/root/product/10.2.0/asm/bin=>./crsctl check css
Failure 1 contacting CSS daemon

If it is not running then run the following command to configure the CSS as root user.

$ORACLE_HOME/bin/localconfig add

*emgcl10g*:/home/oracle=>sudo $ORACLE_HOME/bin/localconfig add
/etc/oracle does not exist. Creating it now.
Successfully accumulated necessary OCR keys.
Creating OCR keys for user ‘root’, privgrp ‘root’..
Operation successful.
Configuration for local CSS has been initialized

Adding to inittab
Startup will be queued to init within 30 seconds.
Checking the status of new Oracle init process…
Expecting the CRS daemons to be up within 600 seconds.
CSS is active on these nodes.
emgcl10g
CSS is active on all nodes.
Oracle CSS service is installed and running under init(1M)
*emgcl10g*:/home/oracle=>cd $ORACLE_HOME/bin
*emgcl10g*:/u01/app/root/product/10.2.0/asm/bin=>./crsctl check css
CSS appears healthy

Step2)Configure oracleasm lib
Check oraclelib is installed on the machine by using following command.
rpm -qa | grep -i oracleasm

*emgcl10g*:/u01/app/oracle/admin/+ASM=>rpm -qa | grep -i oracleasm
oracleasm-support-2.1.3-1.el4
oracleasm-2.6.9-89.0.0.0.1.EL-2.0.5-1.el4

[root@emgcl10g ~]# /etc/init.d/oracleasm configure
Configuring the Oracle ASM library driver.

This will configure the on-boot properties of the Oracle ASM library
driver. The following questions will determine whether the driver is
loaded on boot and what permissions it will have. The current values
will be shown in brackets (‘[]’). Hitting without typing an
answer will keep that current value. Ctrl-C will abort.

Default user to own the driver interface []: oracle
Default group to own the driver interface []: dba
Start Oracle ASM library driver on boot (y/n) [y]: y
Scan for Oracle ASM disks on boot (y/n) [y]:
Writing Oracle ASM library driver configuration: done
Initializing the Oracle ASMLib driver: [ OK ]
Scanning the system for Oracle ASMLib disks: [ OK ]

[root@emgcl10g ~]# oracleasm createdisk ASM1 /dev/sdc1
Writing disk header: done
Instantiating disk: done
[root@emgcl10g ~]# oracleasm listdisks
ASM1

Step3)Create the init+ASM.ora file in $ORACLE_HOME/dbs directory.

asm_diskstring=’/dev/oracleasm/disks/*’
asm_power_limit=1
instance_type=’asm’
large_pool_size=12M
USER_DUMP_DEST=/u01/app/oracle/admin/+ASM/udump
BACKGROUND_DUMP_DEST=/u01/app/oracle/admin/+ASM/bdump
CORE_DUMP_DEST=/u01/app/oracle/admin/+ASM/cdump
remote_login_passwordfile=’EXCLUSIVE’

create all admin directories

*emgcl10g*:/u01/app/oracle/admin=>mkdir -p +ASM
*emgcl10g*:/u01/app/oracle/admin=>cd +ASM
*emgcl10g*:/u01/app/oracle/admin/+ASM=>mkdir -p adump
*emgcl10g*:/u01/app/oracle/admin/+ASM=>mkdir -p adump
*emgcl10g*:/u01/app/oracle/admin/+ASM=>mkdir -p udump
*emgcl10g*:/u01/app/oracle/admin/+ASM=>mkdir -p bdump
*emgcl10g*:/u01/app/oracle/admin/+ASM=>mkdir -p scripts
*emgcl10g*:/u01/app/oracle/admin/+ASM=>mkdir -p pfile

*emgcl10g*:/u01/app/root/product/10.2.0/asm/dbs=>ls -tlr
total 28
-rw-r—– 1 oracle oinstall 8385 Sep 11 1998 init.ora
-rw-r–r– 1 oracle oinstall 12920 May 3 2001 initdw.ora
lrwxrwxrwx 1 oracle oinstall 45 Apr 28 17:52 init+ASM.ora -> /u01/app/oracle/admin/+ASM/pfile/init+ASM.ora

Now start the oracle asm.

export ORACLE_SID=+ASM

*emgcl10g*:/u01/app/root/product/10.2.0/asm/bin=>sqlpluss / as sysdba

SQL*Plus: Release 10.2.0.5.0 – Production on Thu Apr 28 17:54:32 2011

Copyright (c) 1982, 2010, Oracle. All Rights Reserved.

Connected to an idle instance.

SQL> startup
ASM instance started

Total System Global Area 130023424 bytes
Fixed Size 2094544 bytes
Variable Size 102763056 bytes
ASM Cache 25165824 bytes
ORA-15110: no diskgroups mounted

Create spfile from pfile.

SQL> create spfile from pfile;

File created.

*emgcl10g*:/u01/app/root/product/10.2.0/asm/dbs=>ls -tlr *ASM*ora*
lrwxrwxrwx 1 oracle oinstall 45 Apr 28 17:52 init+ASM.ora -> /u01/app/oracle/admin/+ASM/pfile/init+ASM.ora
lrwxrwxrwx 1 oracle oinstall 47 Apr 28 17:56 spfile+ASM.ora -> /u01/app/oracle/admin/+ASM/pfile/spfile+ASM.ora

Now add the following entry in /etc/oratab file.

+ASM:/u01/app/root/product/10.2.0/asm:N

ORA-15110: no diskgroups mounted

This error can be safely ignored, when creating a new diskgroup, the diskgroup name will be
added automatically to the asm_diskgroups parameter and we will not get this error again.

Create ASM diskgroup:

SQL> create diskgroup DATA1 EXTERNAL REDUNDANCY disk ‘/dev/oracleasm/disks/ASM1’;

Diskgroup created.

SQL> select state ,header_status,substr(name,1,12) Name,path from v$asm_disk;

STATE HEADER_STATU NAME
——– ———— ————
PATH
——————————————————————————–
NORMAL MEMBER DATA1_0000 /dev/oracleasm/disks/ASM1

Categories: oracle asm Tags: , ,

Enterprise Manager 10g Grid Control Release 2 Installation Steps

April 28, 2011 Leave a comment

This article describes step-by-step installation of  Enterprise Manager 10g Grid Control Release 2  software on Red Hat Enterprise Linux 4.

Os Name :

emgcl10g<oracle:>:/etc=>cat redhat-release
Red Hat Enterprise Linux AS release 4 (Nahant Update 8)
emgcl10g<oracle:>:/etc=>uname -r
2.6.9-89.0.0.0.1.EL

Repository Database Version : 10.2.0.5 with ASM as storage.

$ ./sqlplus / as sysdba

SQL*Plus: Release 10.2.0.5.0 – Production on Tue Apr 26 20:59:45 2011

Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 – 64bit Production
With the Partitioning, Data Mining and Real Application Testing options

###########Download following two zip files from oracle#################

###########################################################

********Prerequisites for Enterprise Manager 10g Grid Control Using an Existing Database**********

job_queue_processes=10
db_block_size=8192
timed_statistics=TRUE
open_cursors=300
session_cached_cursors=200
aq_tm_processes=1
undo_retention=10800
processes=150
log_buffer=1048576
statistics_level=TYPICAL (Note that this value is specific only to Enterprise Manager 10g Repository Database release and later.)

*********************************************************************************************

Now invoke runInstaller from staging area

$ ./runInstaller
Starting Oracle Universal Installer…

Checking installer requirements…

Checking operating system version: must be redhat-3, redhat-4, SuSE-9 or asianux-2
Passed

Checking swap space: must be greater than 150 MB.   Actual 2551 MB    Passed
Checking Temp space: must be greater than 300 MB.   Actual 8435 MB    Passed

All installer requirements met.

Preparing to launch Oracle Universal Installer from /tmp/OraInstall2011-04-26_09-34-22PM. Please wait …——————————————————-
Total args: 23
Command line argument array elements .

[root@emgcl10g u01]# /u01/app/oracle/product/oms10g/allroot.sh

Starting to execute allroot.sh ………

Starting to execute /u01/app/oracle/product/oms10g/root.sh ……
Running Oracle10 root.sh script…
The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME=  /u01/app/oracle/product/oms10g

Enter the full pathname of the local bin directory: [/usr/local/bin]:
The file “dbhome” already exists in /usr/local/bin.  Overwrite it? (y/n)
[n]:
The file “oraenv” already exists in /usr/local/bin.  Overwrite it? (y/n)
[n]:
The file “coraenv” already exists in /usr/local/bin.  Overwrite it? (y/n)
[n]:

Adding entry to /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.sh script.
Now product-specific root actions will be performed.
Finished execution of  /u01/app/oracle/product/oms10g/root.sh ……

Starting to execute /u01/app/oracle/product/agent10g/root.sh ……
Running Oracle10 root.sh script…

The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME=  /u01/app/oracle/product/agent10g

Enter the full pathname of the local bin directory: [/usr/local/bin]:
The file “dbhome” already exists in /usr/local/bin.  Overwrite it? (y/n)
[n]:
The file “oraenv” already exists in /usr/local/bin.  Overwrite it? (y/n)
[n]:
The file “coraenv” already exists in /usr/local/bin.  Overwrite it? (y/n)
[n]:

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.sh script.
Now product-specific root actions will be performed.
Finished product-specific root actions.

Finished execution of  /u01/app/oracle/product/agent10g/root.sh ……

*emgcl10g*<oracle:>:/u01/app/oracle/=>cat /u01/app/oracle/product/agent10g/sysman/setupinfo.txt
See below for information pertaining to your Enterprise Manager Installation:
1. Use the following URL to access the Enterprise Manager Grid Control:

https://emgcl10g.ukatru.com:1159/em

2. The Enterprise Manager installation includes an Oracle Application Server instance, which is administered using a special “ias_admin” user account. The following information was defaulted for the embedded Application Server instance:

Instance Name:    EnterpriseManager0.emgcl10g.ukatru.com
ias_admin password: This password is the same the SYSMAN account.

3. The connection details for the Enterprise Manager Repository are:

Host: emgcl10g.ukatru.com
Port: 1521
SID: NO_VALUE

4. The Enterprise Manager Release Notes are located at:

/u01/app/oracle/product/agent10g/relnotes/README_EM.htm

Issues faced during installation:

The installation failed at the “OMS Configuration” step with the following error:

The opmn.log will report the following errors, indicating that Oracle Management Service failed to start:

opmnctl: starting opmn and all managed processes…

FINE: oracle.sysman.emCfg.logger.CfmLogger: log: oracle.sysman.top.oms:PerformSecureCommand:runCmd:Command
Output stderr:

================================================================================
opmn id=emgcl10g.ukatru.com:6501
5 of 6 processes started.
ias-instance id=EnterpriseManager1.emgcl10g.ukatru.com
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ias-component/process-type
/process-set:
HTTP_Server/HTTP_Server/HTTP_Server
Error
–> Process (pid=18346)
failed to start a managed process after the maximum retry limit
Log:
/u01/app/oracle/product/oms10g/opmn/logs/HTTP_Server~1

FINE: oracle.sysman.emCfg.logger.CfmLogger: log: oracle.sysman.top.oms:OmsPlugIn:Requested Configuration
Step 5 have been completed with status=false

The Apache Web server log will report error (28750) as follows:

[Wed Apr 27 09:10:28 2011] [error] mod_ossl: Init: Server emgcl10g.ukatru.com:4898: SSL setup
failed: call to nzos_OpenWallet returned error 28750
[Wed Apr 27 09:10:28 2011] [error] mod_ossl: Unknown error
[Wed Apr 27 09:10:30 2011] [error] mod_ossl: Init: Server emgcl10g.ukatru.com:4898: SSL setup
failed: call to nzos_OpenWallet returned error 28750
[Wed Apr 27 09:10:30 2011] [error] mod_ossl: Unknown error

According to Metalink Article How to Recover From Enterprise Manager Grid Control 10g Base Releases (10.2.0.x.0) Installation Errors after 31-Dec-2010 [ID 1228103.1]

I follwed  below steps and restarted the configuration.

NOTE: Keep the installation session open with the error dialog. At the end of these recovery actions, you can retry the failed steps.

1. Apply Patch 8430622 to the Oracle Management Service installation.

2. After applying the patch, stop the Oracle Management Service (oms) process with the following command:

<ORACLE_HOME>/opmn/bin/opmnctl stopall

3. Re-secure Oracle Management Service with the following command:

<OMS_HOME>/bin/emctl secure oms -reset

emgcl10g*<oracle:>:/u01/app/oracle/product/oms10g/bin=>ure oms -reset        <
Oracle Enterprise Manager 10g Release 3 Grid Control
Copyright (c) 1996, 2007 Oracle Corporation.  All rights reserved.
Enter Enterprise Manager Root Password :
Enter Agent Registration password :
OPMN processes already stopped…   Done.
Securing central oms…   Started.
Checking Repository…   Done.
Checking Em Key…   Done.
Checking Repository for an existing Enterprise Manager Root Key…
WARNING! An Enterprise Manager Root Key already exists in
the Repository. This operation will replace your Enterprise
Manager Root Key.
All existing Agents that use HTTPS will need to be
reconfigured if you proceed. Do you wish to continue and
overwrite your Root Key
(Y/N) ?
Y
Are you sure ? Reset of the Enterprise Manager Root Key
will mean that you will need to reconfigure each Agent
that is associated with this OMS before they will be
able to upload any data to it. Monitoring of Targets
associated with these Agents will be unavailable until
after they are reconfigured.
(Y/N) ?
Y
Generating Enterprise Manager Root Key (this takes a minute)…   Done.
Fetching Root Certificate from the Repository…   Done.
Generating Registration Password Verifier in the Repository…   Done.
Generating Oracle Wallet Password for Enterprise Manager OMS…   Done.
Generating Oracle Wallet for Enterprise Manager OMS…   Done.
Generating Oracle Wallet for iAS HTTP Server…   Done.
Updating HTTPS port in emoms.properties file…   Done.
Generating HTTPS Virtual Host for Enterprise Manager OMS…   Done.
Securing central oms…   Ended.

4. Re-start Oracle Management Service by executing the following command:

<OMS_HOME>/bin/emctl start oms

5. Retry the failed step from the error dialog to complete the installation.

Configuring Linux Hugepages for Oracle Database

April 21, 2011 Leave a comment

In this article we are going to discuss setting up hugapages on linux and using it for oracle instance.

*dbslcert*:/home/oracle/admin/diag/rdbms/oradv1/oradv1/trace=>grep Huge /proc/meminfo
HugePages_Total: 0
HugePages_Free: 0
HugePages_Rsvd: 0
Hugepagesize: 2048 kB

Each huge page size is 2MB and for 512MB sga we need 256 huge pages.

Add following entry in /etc/sysctl.conf and reboot the system.

I am adding only 160 pages and will test different scenarios by using init.ora file to start oracle instance.
vm.nr_hugepages = 160

cat /proc/meminfo
HugePages_Total: 160
HugePages_Free: 160
HugePages_Rsvd: 0
Hugepagesize: 2048 kB

Scenario 1:

Hugepages is not support with AMM

use_large_pages=only
memory_max_target=800M
memory_target=800M

SQL> HOST date
Wed Apr 20 21:44:35 PDT 2011

SQL> startup force pfile=./initoradv1.ora
ORA-27125: unable to create shared memory segment
Linux-x86_64 Error: 2: No such file or directory

Error:

Wed Apr 20 21:40:44 2011
Starting ORACLE instance (normal)
******************************************************************
Huge Pages are not compatible with specified SGA memory parameters
use_large_pages = “ONLY” cannot be used with memory_target,
memory_max_target, or use_indirect_data_buffers parameters
Huge Pages are compatible with sga_target and shared_pool_size

scenario 2:

AMM is disabled by setting memory_max_target = 0
Starting ORACLE instance (normal)
****************** Huge Pages Information *****************
Huge Pages memory pool detected (total: 160 free: 160)
Huge Pages allocation failed (free: 160 required: 257)
Startup will fail as use_large_pages is set to “ONLY”
******************************************************
Summary:

use_large_pages is a must-set parameter if we need hugepages. With initialization parameters like use_large_pages, configuring hugepages for Oracle Database is very easy.

RAC One Node Database–11.2.0.1

April 6, 2011 Leave a comment
In this article I will discuss how to use rac one node option in 11.2.0.1.


Step1)Apply Patch #9004119 to enable rac one option in 11.2.0.1 database release.

*racnode1*:/u01/app/oracle/product/11.2.0.1/db_1/bin=>ls -tlr racone*
-rwxr-xr-x 1 oracle oinstall  7461 Oct 22  2009 raconestatus
-rwxr-xr-x 1 oracle oinstall 20268 Oct 22  2009 raconeinit
-rwxr-xr-x 1 oracle oinstall 25719 Oct 22  2009 raconefix
-rwxr-xr-x 1 oracle oinstall 12396 Oct 22  2009 racone2rac



Step2)Execute raconeinit script to initialize rac one ndoe database configuration.

*racnode1*:/u01/app/oracle/product/11.2.0.1/db_1/bin=>./raconeinit

Candidate Databases on this cluster:

 #      Database        RAC One Node    Fix Required
===     ========        ============    ============
[1]       racone             NO              N/A
[2]      uk11201             NO              N/A
Enter the database to initialize [1]: 2

Database uk11201 is now running on server racnode1

Candidate servers that may be used for this DB:  racnode2

Enter the names of additional candidate servers where this DB may run (space delimited): racnode2

 Please wait, this may take a few minutes to finish…….

Database configuration modified.

*racnode1*:/u01/app/oracle/product/11.2.0.1/db_1/bin=>./raconestatus

RAC One Node databases on this cluster:

  Database UP Fix Required        Current Server                    Candidate Server Names
  ======== == ============ ==============================  ========================================
   uk11201  Y       N                            racnode1                         racnode1 racnode2

Available Free Servers:

Step3)Relocate racone database to another server using Omotion. 




*racnode1*:/u01/app/oracle/product/11.2.0.1/db_1/bin=>Omotion

RAC One Node databases on this cluster:

 #      Database                    Server                      Fix Required
===     ========        ==============================          ============
[1]      uk11201                              racnode1                N

Enter number of the database to migrate [1]: 1

Specify maximum time in minutes for migration to complete (max 30) [30]: 30


Available Target Server(s) :
 #            Server            Available
===     ==================      =========
[1]               racnode2          Y

Enter number of the target node [1]: 1

Omotion Started…
Starting target instance on racnode2…

Error num: 2
ERROR: Unable to start the new instance of uk11201 on racnode2.
Run raconefix and run Omotion again.
Exiting…

*racnode1*:/u01/app/oracle/product/11.2.0.1/db_1/bin=>./raconefix

RAC One Node databases on this cluster:

 #      Database                    Server                      Fix Required
===     ========        ==============================          ============
[1]      uk11201                     racnode1 racnode2                Y

Enter number of the database to fix [1]: 1

This database needs to be fixed.

RACOne Database uk11201 fixed.

Issue : 

no available public threads to mount, go to pnp wait
no available public threads to mount, go to pnp wait
ORA-1620 signalled during: ALTER DATABASE MOUNT /* db agent *//* {1:8141:2280} */…
Wed Apr 06 11:01:54 2011
Shutting down instance (abort)


Fix :


create undo tablespace UNDOTBS2 datafile ‘+DATA1’ size 250M autoextend off;

alter database add logfile thread 2 group 4 ‘+DATA1’ size 50M;
alter database add logfile thread 2 group 5 ‘+DATA1’ size 50M;
alter database add logfile thread 2 group 6 ‘+DATA1’ size 50M;

*racnode1*:/u01/app/oracle/product/11.2.0.1/db_1/bin=>./Omotion

RAC One Node databases on this cluster:

 #      Database                    Server                      Fix Required
===     ========        ==============================          ============
[1]      uk11201                              racnode1                N

Enter number of the database to migrate [1]: 1

Specify maximum time in minutes for migration to complete (max 30) [30]:

Available Target Server(s) :
 #            Server            Available
===     ==================      =========
[1]               racnode2          Y

Enter number of the target node [1]: 1

Omotion Started…
Starting target instance on racnode2…
Migrating sessions…
Stopping source instance on racnode1…
Omotion Completed…

=== Current Status ===
Database uk11201 is running on node racnode2



Categories: oracle-install

RAC One Node Database–11.2.0.2

April 4, 2011 Leave a comment
Oracle Real Application Clusters One Node (Oracle RAC One Node) is a single instance of an Oracle Real Application Clusters (Oracle RAC) database that runs on one node in a cluster.

 Major Changes in 11.2.0.2 database version:

 1)OUI has a new option to select RAC One Installation.
 2)DBCA is now capable of configuring RAC One database.
  SRVCTL is capable of configuring and administering RAC One database. (In 11.2.0.1 this was  performed using scripts like “Omotion”, “raconestatus” etc).
 3)DBUA is RAC One aware.

 Administrating a RAC One Database:

Verifying an existing RAC One database:
 
*racnode1*:/home/oracle=>srvctl config database -d racone
Database unique name: racone
Database name: racone
Oracle home: /u01/app/oracle/product/11.2.0.2/db_1
Oracle user: oracle
Spfile: +DATA01/racone/spfileracone.ora
Domain: ukatru.com
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: racone
Database instances:
Disk Groups: DATA01
Mount point paths: /u01/app/oracle
Services: onedv.ukatru.com
Type: RACOneNode
Online relocation timeout: 30
Instance name prefix: racone
Candidate servers: racnode1,racnode2
Database is administrator managed
*racnode1*:/home/oracle=>srvctl status database -d racone
Instance racone_1 is running on node racnode1
Online relocation: INACTIVE

*racnode1*:/home/oracle=>srvctl status database -d racone
Instance racone_1 is running on node racnode1
Online relocation: INACTIVE

Step1)Performing relocation: 


*racnode1*:/home/oracle=>srvctl relocate database -h

Initiate online relocation of the RAC One Node database.

Usage: srvctl relocate database -d {[-n ] [-w ] | -a [-r]} [-v]
    -d       Unique name of database to relocate
    -n               Target node to which to relocate database
    -w              Online relocation timeout in minutes
    -a                       Abort failed online relocation
    -r                       Remove target node of failed online relocation request from the candidate server list of administrator-managed RAC One Node database
    -v                       Verbose output
    -h                       Print usage



*racnode1*:/home/oracle=>srvctl relocate database -d racone -n racnode2


Status during Relocation:



*racnode1*:/home/oracle=>srvctl status database -d racone
Instance racone_1 is running on node racnode1
Instance racone_2 is running on node racnode2
Online relocation: ACTIVE
Source instance: racone_1 on racnode1
Destination instance: racone_2 on racnode2



Once the migration is completed, we should see the sessions moved to the remote instance.

*racnode1*:/home/oracle=>srvctl status database -d racone
Instance racone_2 is running on node racnode2
Online relocation: INACTIVE



Step2:)Converting a RAC One database to RAC or vice versa

Example commands : 


srvctl convert database -d -c RAC [-n ]


srvctl convert database -d racone -c RAC -n racnode1

To convert a database from RAC to RACOne:

command: srvctl convert database -d -c RACONENODE -i -w

Eg:  srvctl convert database -d racone -c RACONENODE -w 30 -i racone







Categories: oracle-install

Oracle Database 11g Express Edition (11.2) Beta

April 3, 2011 Leave a comment
In this article we will learn how to install 11g Express edition 11.2 Beta on linux x86_64 bit.

Limitations:

1.If Oracle Database XE is installed on a computer with more than one CPU (including dual-core CPUs), then it will consume, at most, processing resources equivalent to one CPU

2.Only one installation of Oracle Database XE can be performed on a single computer

3.The maximum amount of user data in an Oracle Database XE database cannot exceed 11 gigabytes

4.The maximum amount of RAM that an Oracle Database XE database uses cannot exceed 1 gigabyte, even if more is available

Oracle Database XE is a great starter database for:
  • Developers working on PHP, Java, .NET, XML, and Open Source applications
  • DBAs who need a free, starter database for training and deployment
  • Independent Software Vendors (ISVs) and hardware vendors who want a starter database to distribute free of charge
  • Educational institutions and students who need a free database for their curriculum

Installing Oracle Database XE:

Log on to your computer with root permissions.

[root@oraexpress u01]# id
uid=0(root) gid=0(root) groups=0(root),1(bin),2(daemon),3(sys),4(adm)

Run the Oracle Database XE executable oracle-xe-11.2.0-0.5.x86_64.rpm to install Oracle Database XE.

[root@oraexpress u01]# rpm -ivh oracle-xe-11.2.0-0.5.x86_64.rpm
Preparing…                ########################################### [100%]
   1:oracle-xe              ########################################### [100%]
Executing post-install steps…

You must run ‘/etc/init.d/oracle-xe configure’ as the root user to configure the database.
[root@oraexpress u01]# /etc/init.d/oracle-xe configure

Oracle Database 11g Express Edition Configuration
————————————————-
This will configure on-boot properties of Oracle Database 11g Express
Edition.  The following questions will determine whether the database should
be starting upon system boot, the ports it will use, and the passwords that
will be used for database accounts.  Press to accept the defaults.
Ctrl-C will abort.

Specify the HTTP port that will be used for Oracle Application Express [8080]:8080

Specify a port that will be used for the database listener [1521]:1521

Specify a password to be used for database accounts.  Note that the same
password will be used for SYS and SYSTEM.  Oracle recommends the use of
different passwords for each database account.  This can be done after
initial configuration:
Password can’t be null. Enter password:
Confirm the password:

Do you want Oracle Database 11g Express Edition to be started on boot (y/n) [y]:n

Starting Oracle Net Listener…Done
Configuring database…Done
Starting Oracle Database 11g Express Edition instance…Done
Installation completed successfully.

$ export ORACLE_HOME=/u01/app/oracle/product/11.2.0/xe
$ export ORACLE_SID=XE
$ cd /u01/app/oracle/product/11.2.0/xe/bin
$ ./sqlplus / as sysdba

SQL*Plus: Release 11.2.0.2.0 Beta on Sun Apr 3 12:36:57 2011

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Express Edition Release 11.2.0.2.0 – 64bit Beta

SQL>

Categories: oracle-install

Create 10gR2(10.2.0.5) database on 11gR2 ASM and Cluster

April 3, 2011 Leave a comment
In this article we will look at creating database 10gR2 database on 11gR2 asm and cluster.

Env : Two node Rac 
OS
*racnode1*:/etc=>cat redhat-release
Red Hat Enterprise Linux Server release 5.6 (Tikanga)

Node1:racnode1.ukatru.com
Node2:racnode2.ukatru.com
Scan-Name : racnode-scan.ukatru.com


Step1:Install 10gr2 database and appy 10.2.0.5 patch set(We don’t get any issues while installation)

To run older database on 11gR2 ASM and clusterware we need to create a persistent configuration for the nodes(pinning a node).Cluster configuration in 11gR2 is dynamic.This dynamic configuration is incompatible with older database releases:
If we don’t pinn nodes dbca will not recognize the rac cluster;instead dbca will create a single node database.


Please check metalin for following article if you face any more issues while creating 10gR2 database.


Pre 11.2 Database Issues in 11gR2 Grid Infrastructure Environment [ID 948456.1]


Pinning nodes:


[root@racnode1 bin]# ./crsctl pin css -h
Usage:
  crsctl pin css -n […]
 Pin the nodes (make leases non-expiring).

[root@racnode1 bin]# ./crsctl pin css -n racnode1
CRS-4664: Node racnode1 successfully pinned.
[root@racnode1 bin]# ./crsctl pin css -n racnode2
CRS-4664: Node racnode2 successfully pinned.
[root@racnode1 bin]# ./olsnodes -n -t
racnode1        1       Pinned
racnode2        2       Pinned



*racnode1*:/u01/app/oracle1/product/10.2.0.5/db_1=>export ORACLE_HOME=/u01/app/oracle1/product/10.2.0.5/db_1

export TNS_ADMIN=/u01/app/11.2.0/grid/network/admin
*racnode1*:/u01/app/oracle1/product/10.2.0.5/db_1=>cd bin
*racnode1*:/u01/app/oracle1/product/10.2.0.5/db_1/bin=>./dbca &

now dbca failed with following error:


Encountered file error when copying listeners from home=/u01/app/11.2.0/grid/(The grid home).



sol:Setting $GRID_HOME/network/admin to 775 permisson fixed the problem.

Issues faced:

Solution :


click on Back and select Initialization parameter and changed REMOTE_LISTENER to : racnode-scan.ukatru.com:1521 and set ora10g1.LOCAL_LISTENER and ora10g2.LOCAL_LISTENER to empty values.

 *racnode1*:/u01/app/11.2.0/grid/bin=>/u01/app/oracle1/product/10.2.0.5/db_1/bin/srvctl status database -d ora10g
Instance ora10g1 is running on node racnode1
Instance ora10g2 is running on node racnode2

Advantage : you can use scan name in the tns entries instead of virtual ip from each node.
ORA10G =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = racnode-scan.ukatru.com )(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ora10g.ukatru.com)
    )
  )







Categories: oracle-install
%d bloggers like this: