Installing Oracle 10.2.0.1 on Red Hat Linux AS release 4 Update 5 (Nahant Update)
Table of Contents
1.1 Objectives
1.2 Scope
2 System Configuration
2.1 Architecture
3 System Configuration
3.1 Machine Configuration
3.2 External/Shared Storage
4 Oracle Pre-Installation tasks
4.1 Redhat Pre-Requisite
4.2 Copy Oracle 10.2.0.1 software onto server
4.3 Unpack Files
4.4 Download Patches
4.5 Check kernel and update rpm files
4.6 Creating Required Operating System Groups and Users
4.7 Oracle required directory creation
4.8 Set Kernel Parameters
4.9 Create Oracle Profile
5 Oracle Software Configuration
5.1 Directory Structure
5.2 Download ASM packages
5.3 ASM package install
5.4 Configuring and Loading ASM
5.5 Creating ASM Disks
5.6 Installation
5.6.1 Database Only Installation
5.6.2 Installing the Listener
5.6.3 DBCA : Creating an ASM /Database Instance
1 Executive Summary
1.1 Objectives
The objectives of this document are to: Record the setup and configuration of the 10g Oracle Standalone environment.
The details contained within this document pertain to the installation of a VMWARE Oracle environment including:
- Oracle Software Install.
- Creation of Oracle ASM instance
- Creation Oracle Database instance
2 System Configuration
2.1 Architecture
This document details VMWARE Oracle build as well as a Pre Production database build. Details for these environments are listed at section 6.
The Linux OS was installed for all environments. SAN storage & networking was configured.
It was observed that SAN storage have limited Disk spindles & hence SAN storage for oracle database was split into 2 RAID arrays, RAID 0+1 and RAID 5. RAID 0 +1 was used for +DATA ASM volume while RAID 5 was used for +BACKUP ASM volume.
3 System Configuration
3.1 Machine Configuration
The table below details the specifications for Server.
| Node Name | Devora01 |
| Purpose | Database node |
| Manufacturer | VMware |
| Model | ESX 3.0.2 |
| Operating System | Linux Red Hat Advanced Server |
| OS Version | 4.0 |
| Update Version | Nahant Update 5 |
| OS Patches | See “Check installed packages” section |
| Memory | 16GB |
| Swap | 16GB |
| No Of Processors | 1 |
| No of Oracle Instances | 1 x Database |
The following table details the disk configuration information used to partition the internal disks during the installation process:
| File Type | Size | Mount Point |
| ext3 | 5GB | / |
| ext3 | 99MB | /boot |
| ext3 | 2GB | /home |
| ext3 | 1008MB | /tmp |
| ext3 | In root / | /usr |
| ext3 | 2GB | /var |
| ext3 | 9.9GB | /u01 |
| ext3 | 30GB | /u10 |
| ext3 | 30GB | /u11 |
| ext3 | 30GB | /u12 |
3.2 External/Shared Storage
| Size | Mounted On |
| 120 GB | +DATA |
4 Oracle Pre-Installation tasks
If Red Hat OS is already installed, ensure the packages detailed below are installed before starting the Oracle Install.
.
4.2 Copy Oracle 10.2.0.1 software onto server
Connect to http://edelivery.oracle.com and download Oracle Database for Platform “Linux Intel (64-bit)
Click “Oracle® Database 10g Release 2 (10.2.0.1.0) Media Pack (with Oracle® Enterprise Manager 10g Release 2 Grid Control (10.2.0.1.0) for Linux x86-64”
4.3 Unpack Files
Uncompress the downloaded file(s):
gunzip ship.db.lnxXX.cpio.gz
Unpack ship.db.lnx32.cpio:
$ cpio -idmv < ship.db.lnxXX.cpio
Disk1/stage/Components/oracle.server/10.2.0.1/1
Disk1/stage/Components/oracle.server/10.2.0.1
Disk1/stage/Components/oracle.server
Disk1/stage/Components/oracle.tg/10.2.0.1/1/DataFiles
Disk1/stage/Components/oracle.tg/10.2.0.1/1
Disk1/stage/Components/oracle.tg/10.2.0.1
Disk1/stage/Components/oracle.tg
Disk1/stage/Components/oracle.assistants.dbca/10.2.0.1/1/DataFiles/doc.3.1.jar
Disk1/stage/Components/oracle.assistants.dbca/10.2.0.1/1/DataFiles/class.jar
4.4 Download Patches
Version 10.2.0.1(10g Release 2) so no need for further patches here.
4.5 Check kernel and update rpm files
Install the following packages:
# From RedHat AS4 Disk 2
cd /media/cdrom/RedHat/RPMS
rpm -Uvh setarch-1*
rpm -Uvh compat-libstdc++-33-3*
# From RedHat AS4 Disk 3
cd /media/cdrom/RedHat/RPMS
rpm -Uvh openmotif-2*
rpm -Uvh compat-db-4*
# From RedHat AS4 Disk 4
cd /media/cdrom/RedHat/RPMS
rpm -Uvh compat-gcc-32-3*
rpm -Uvh compat-gcc-32-c++-3*
Most of these files would be there if the installation procedures for Linux have been followed. In that case please ignore rpm error messages.
Check Linux Kernel Version:
# uname –a
Linux ora01.com 2.6.9-55.ELsmp #1 SMP Fri Apr 20 16:36:54 EDT 2007 x86_64 x86_64 x86_64 GNU/Linux
For 10g R2 (64-bit) on RHEL 4 x86_64, you will need following required package versions or higher:
| Required packages | Installed on Devora01 |
| binutils-2.15.92.0.2-18.x86_64 | binutils-2.15.92.0.2-22 (x86_64) |
| compat-db-4.1.25-9.i386 | compat-db-4.1.25-9 (i386) |
| compat-db-4.1.25-9.x86_64 | compat-db-4.1.25-9 (x86_64) |
| control-center-2.8.0-12.x86_64 | control-center-2.8.0-12.rhel4.5 (x86_64) |
| gcc-3.4.3-22.1.x86_64 | gcc-3.4.6-8 (x86_64) |
| gcc-c++-3.4.3-22.1.x86_64 | gcc-c++-3.4.6-8 (x86_64) |
| glibc-2.3.4-2.9.i686 | glibc-2.3.4-2.36 (i686) |
| glibc-2.3.4-2.9.x86_64 | glibc-2.3.4-2.36 (x86_64) |
| glibc-common-2.3.4-2.9.x86_64 | glibc-common-2.3.4-2.36 (x86_64) |
| gnome-libs-1.4.1.2.90-44.1.x86_64 | gnome-libs-1.4.1.2.90-44.1 (x86_64) |
| libstdc++-3.4.3-22.1.i386 | libstdc++-3.4.6-8 (i386) |
| libstdc++-3.4.3-22.1.x86_64 | libstdc++-3.4.6-8 (x86_64) |
| libstdc++-devel-3.4.3-22.1.x86_64 | libstdc++-devel-3.4.6-8 (x86_64) |
| make-3.80-5.x86_64 | make-3.80-6.EL4 (x86_64) |
| pdksh-5.2.14-30.x86_64 | pdksh-5.2.14-30.3 (x86_64) |
| sysstat-5.0.5-1.x86_64 | sysstat-5.0.5-14.rhel4 (x86_64) |
| xscreensaver-4.18-5.rhel4.2.x86_64 | xscreensaver-4.18-5.rhel4.13 (x86_64) |
| libaio-0.3.103-3.i386 | libaio-0.3.105-2 (i386) |
Also ensure to install the libaio-0.3.96 RPM or a newer version! Otherwise the OUI will fail.
To check the RPMs, run:
root# rpm -q –qf ‘%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n’ \
binutils compat-db control-center gcc gcc-c++ glibc glibc-common gnome-libs \
libstdc++ libstdc++-devel make pdksh sysstat xscreensaver libaio
4.6 Creating Required Operating System Groups and Users
Create oinstall and dba groups (not created osoper group as this is optional)
/usr/sbin/groupadd oinstall
/usr/sbin/groupadd dba
Create Oracle user
/usr/sbin/useradd -g oinstall -G dba -d /home/oracle -m oracle
This command will create user “oracle”, with group “oinstall” and supplementary group of “dba”. It will also create the home directory of “/home/oracle”. The default shell will be used – /bin/bash
Set Password
passwd oracle
4.7 Oracle required directory creation
Oracle software will be installed on the internal disk, in file system /u01.
The ASM database file system will be on the external disk and left as RAW.
On server
mkdir -p /u01/app/oracle
mkdir -p /u01/app/oracle/product/10.2.0/db_1
chown -R oracle:oinstall /u01/app/oracle
chmod -R 775 /u01/app/oracle
4.8 Set Kernel Parameters
Kernel parameters were reconfigured to support the Oracle environment. The table below details all Kernel parameter changes.
Add the following lines to the /etc/sysctl.conf file:
kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
Run the following command to change the current kernel parameters: /sbin/sysctl –p
Add the following lines to the /etc/security/limits.conf file:
* soft nproc 2047
* hard nproc 16384
* soft nofile 1024
* hard nofile 65536
Add the following line to the /etc/pam.d/login file, if it does not already exist:
session required /lib/security/pam_limits.so
Disable secure linux by editing the /etc/selinux/config file, making sure the SELINUX flag is set as follows:
SELINUX=disabled
Alternatively, this alteration can be done using the GUI tool (Applications > System Settings > Security Level). Click on the SELinux tab and disable the feature.
Hosts File
The /etc/hosts file must contain a fully qualified name for the server:
127.0.0.1 devora01 localhost.localdomain
4.9 Create Oracle Profile
Login as the oracle user and add the following lines at the end of the .bash_profile file:
# Oracle Settings
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1; export ORACLE_HOME
ORACLE_SID=TSH1; export ORACLE_SID
ORACLE_TERM=xterm; export ORACLE_TERM
PATH=/usr/sbin:$PATH; export PATH
PATH=$ORACLE_HOME/bin:$PATH; export PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH
#LD_ASSUME_KERNEL=2.4.1; export LD_ASSUME_KERNEL
if [ $USER = “oracle” ]; then
if [ $SHELL = “/bin/ksh” ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
fi
5 Oracle Software Configuration
5.1 Directory Structure
The following folders and ASM disk groups were created during the installation process for dbora1 and dbora2.
| Description | Location |
| Oracle Base Directory | /u01/app/oracle |
| Oracle Inventory Directory | /u01/appl/oracle/oraInventory |
| ORACLE_HOME | /u01/app/oracle/product/10.2.0/db_1 |
5.2 Download ASM packages
Oracle ASMLib URL:
http://www.oracle.com/technology/tech/linux/asmlib/index.html
Downloads from “AMD64 / Intel em64t Architecture” section on
http://www.oracle.com/technology/software/tech/linux/asmlib/rhel4.html
The Library and Tools
· oracleasm-support-2.0.3-1.x86_64.rpm
· oracleasmlib-2.0.2-1.x86_64.rpm
And the Drivers for kernel
oracleasm-2.6.9-55.EL-2.0.3-1.x86_64.rpm
5.3 ASM package install
Install 3 ASM packages on both servers using the following command:
· rpm -Uvh oracleasm-support-2.0.3-1.x86_64.rpm \
oracleasmlib-2.0.2-1.x86_64.rpm \
oracleasm-2.6.9-55.EL-2.0.3-1.x86_64.rpm
Preparing… ########################################### [100%]
1:oracleasm-support ########################################### [ 33%]
2:oracleasm-2.6.9-55 ########################################### [ 67%]
3:oracleasmlib ########################################### [100%]
5.4 Configuring and Loading ASM
Using default value 1
Last cylinder or +size or +sizeM or +sizeK (1-26108, default 26108): 11000
Command (m for help): p
Disk /dev/sdb: 214.7 GB, 214748364800 bytes
255 heads, 63 sectors/track, 26108 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Device Boot Start End Blocks Id System
/dev/sdb1 1 11000 88357468+ 83 Linux
Command (m for help): n
Command action
e extended
p primary partition (1-4)
2
Invalid partition number for type `2′
Command action
e extended
p primary partition (1-4)
p
Partition number (1-4): 2
First cylinder (11001-26108, default 11001):
Using default value 11001
Last cylinder or +size or +sizeM or +sizeK (11001-26108, default 26108):
Using default value 26108
Command (m for help): p
Disk /dev/sdb: 214.7 GB, 214748364800 bytes
255 heads, 63 sectors/track, 26108 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Device Boot Start End Blocks Id System
/dev/sdb1 1 11000 88357468+ 83 Linux
/dev/sdb2 11001 26108 121355010 83 Linux
Command (m for help): w
The partition table has been altered!
Calling ioctl() to re-read partition table.
Syncing disks.
You have mail in /var/spool/mail/root
oot@ora01 ~]# fdisk -l
Disk /dev/sda: 32.2 GB, 32212254720 bytes
255 heads, 63 sectors/track, 3916 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Device Boot Start End Blocks Id System
/dev/sda1 * 1 13 104391 83 Linux
/dev/sda2 14 3916 31350847+ 8e Linux LVM
Disk /dev/sdb: 214.7 GB, 214748364800 bytes
255 heads, 63 sectors/track, 26108 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Device Boot Start End Blocks Id System
/dev/sdb1 1 11000 88357468+ 83 Linux
/dev/sdb2 11001 26108 121355010 83 Linux
5.5 Creating ASM Disks
Execute following commands to create ASM disk volume VOL1 & VOL2
[root@wygtrnora01 ~]# /etc/init.d/oracleasm createdisk VOL1 /dev/sdb1
Marking disk “/dev/sdb1” as an ASM disk: [ OK ]
[root@wygtrnora01 ~]# /etc/init.d/oracleasm createdisk VOL2 /dev/sdb2
Marking disk “/dev/sdb2” as an ASM disk: [ OK ]
root@wygtrnora01 ~]# /etc/init.d/oracleasm listdisks
VOL1
VOL2
5.6 Installation
Log into the oracle user. If you are using X emulation then set the DISPLAY environmental variable:
DISPLAY=<machine-name>:0.0; export DISPLAYStart the Oracle Universal Installer (OUI) by issuing the following command in the Disk1 directory:
./runInstaller
During the installation enter the appropriate ORACLE_HOME and name then continue with a “software only” installation.
5.6.1 Database Only Installation
Welcome, click on next:
Specify Home Details.
Product-Specific Prerequisite Checks. Some of these checks like swap space check may fail and could be ignored for installation purposes.
Reason to ignore swap space Error: Oracle calculates swap space as multiple of physical memory. Oracle formula works well for systems having less than 4G physical memory.
For example you have node with 16GB of physical memory. In theory you don’t need >16Gb swap space as oracle wouldn’t use that kind of swap space. Still installer may fail showing swap space is inadequate i.e swap space < (1.5 times Physical memory) or 24GB.
Select the Configuration Option & choose database software only. The database creation will be done later. Click on next:
You are presented with a summary. All seems fine. Click on install:
Installation progresses and the tool bar gives an indication to the percentage of time remaining.
The installation process completes and you are prompted to run the root.sh script. You must be logged in as root in a new console to do this.
5.6.2 Installing the Listener
The DBCA (Database configuration Assistance) needs listener process so please configure it before running DBCA.
Starting up the netca is easy. While logged in with your. oracle user account do the following:
$ netca &
You are presented with several options. Please select “Listener Configuration” and Click on next:
Click “Add” and click on next:
You get a default option “LISTENER” but you can choose whatever name you like. Click on next:
Pick up TCP and click on next:
You can choose other port numbers but try and leave default port 1521. Click on next:
Select “No” when prompted to configure another listener, and Click on next:
Click on next:
5.6.3 DBCA : Creating an ASM /Database Instance
DBCA is a database creation agent. Please check that Oracle env variables like $ORACLE_HOME and $PATH are set properly.
To start the database creation process, login at VNC and run following commands:
# xhost + (As Root User)
The xhost program is used to add and delete host names or user names to the list allowed to make connections to the X server.
Now change back to Oracle user:
# su – oracle
And start the DBCA tool:
$ dbca &
At the Welcome window, click Next.
At the Operations window, make sure Create a Database is selected and click Next.
At the Database Templates window, select Transaction Processing and click Next.
. 
At the Management Options window, accept the defaults and click Next.
At the Database Credentials window, enter a Password and Confirm Password and click Next.
At the Storage Options window, select Automatic Storage Management (ASM) and click Next.
Enter a SYS Password and Confirm SYS Password and click Next.
Click OK to create and start the ASM instance.
When ASM storage selected, message pops up stating need to start CSS as root. This is done by running ‘localconfig add’ in $ORACLE_HOME/bin:-
[root@wygdevora01 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 90 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.
wygdevora01
CSS is active on all nodes.
Oracle CSS service is installed and running under init(1M)
This creates and start ocssd process
Return to Installation and click OK to create and start the ASM instance.
At the ASM Disk Group window, click Create New.
Enter DATA in the Disk Group Name field.
A list of Member Disks which were configured in section “4.5 Creating ASM Disks “ of this document will appear.
The progress window appears, the database is being created.
Note the Enterprise Manager URL. Click Exit.
Start Oracle Enterprise Manager (Desktop icon) by entering the URL
http://10.13.101.11:1158/em/console/
sys/<password> as SYSDBA. Then click Login.
At the Licensing window, scroll down to the bottom and click I Agree.
5.5.4 : Startup Script for Oracle Database/ASM Instance
Most Linux / UNIX users have a script used to start and stop Oracle services on system restart. On UNIX platforms, the convention is to put all start / stop commands in a single shell script named dbora.
Following shell script can used to start all required Oracle services including Oracle Cluster Synchronization Services (CSS), ASM instance, database server(s), and the Oracle TNS listener process.
This script will utilize the Oracle supplied scripts $ORACLE_HOME/bin/dbstart and $ORACLE_HOME/bin/dbshut to handle starting and stopping the Oracle database(s).
The dbora will be run by the UNIX init process, and reads the /etc/oratab file to dynamically determine which database(s) to start and stop.
Create dbora File
Edit /etc/oratab and set flag “N” to “Y” for ASM as well as WYG instance.
Create dbora shell script and place it in the /etc/init.d directory.
# +————————————————————————+
# | FILE : dbora |
# | DATE : 24-Jan-2008 |
# | HOSTNAME : devora01 |
# +————————————————————————+
# +———————————+
# | FORCE THIS SCRIPT TO BE IGNORED |
# +———————————+
# exit
# +———————————+
# | PRINT HEADER INFORMATION |
# +———————————+
echo ” ”
echo “+———————————-+”
echo “| Starting Oracle Database Script. |”
echo “| 0 : $0 |”
echo “| 1 : $1 |”
echo “+———————————-+”
echo ” ”
# +—————————————————–+
# | ALTER THE FOLLOWING TO REFLECT THIS SERVER SETUP |
# +—————————————————–+
HOSTNAME=wygdevora01.wyg-asp.com
ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1
SLEEP_TIME=10
ORACLE_OWNER=oracle
DATE=`date “+%m/%d/%Y %H:%M”`
export HOSTNAME ORACLE_HOME SLEEP_TIME ORACLE_OWNER DATE
# +———————————————-+
# | VERIFY THAT ALL NEEDED SCRIPTS ARE AVAILABLE |
# | BEFORE CONTINUING. |
# +———————————————-+
if [ ! -f $ORACLE_HOME/bin/dbstart -o ! -d $ORACLE_HOME ]; then
echo ” ”
echo “+————————————-+”
echo “| ERROR: |”
echo “| Oracle startup: cannot start |”
echo “| cannot find dbstart |”
echo “+————————————-+”
echo ” ”
exit
fi
# +—————————+
# | START/STOP CASE STATEMENT |
# +—————————+
case “$1″ in
start)
echo ” ”
echo “+—————————————-+”
echo “| ************************************** |”
echo “| >>>>>>>>> START PROCESS <<<<<<<<<< |”
echo “| ************************************** |”
echo “+—————————————-+”
echo ” ”
echo “Going to sleep for $SLEEP_TIME seconds…”
sleep $SLEEP_TIME
echo ” ”
su – $ORACLE_OWNER -c “$ORACLE_HOME/bin/dbstart”
echo ” ”
echo “+—————————————————+”
echo “| About to start the listener process in |”
echo “| $ORACLE_HOME |”
echo “+—————————————————+”
echo ” ”
su – $ORACLE_OWNER -c “lsnrctl start listener”
echo ” ”
echo “+—————————————————+”
echo “| About to start the dbconsole EM process |”
echo “+—————————————————+”
echo ” ”
su – $ORACLE_OWNER -c “emctl start dbconsole”
touch /var/lock/subsys/dbora
;;
stop)
echo ” ”
echo “+—————————————-+”
echo “| ************************************** |”
echo “| >>>>>>>>>> STOP PROCESS <<<<<<<<<< |”
echo “| ************************************** |”
echo “+—————————————-+”
echo ” ”
echo ” ”
echo “+—————————————————+”
echo “| About to stop the dbconsole EM process |”
echo “+—————————————————+”
echo ” ”
su – $ORACLE_OWNER -c “emctl stop dbconsole”
echo ” ”
echo “+——————————————————-+”
echo “| About to stop the listener process in |”
echo “| $ORACLE_HOME |”
echo “+——————————————————-+”
echo ” ”
su – $ORACLE_OWNER -c “lsnrctl stop listener”
echo ” ”
echo “+——————————————————-+”
echo “| About to stop all Oracle databases |”
echo “| running. |”
echo “+——————————————————-+”
echo ” ”
su – $ORACLE_OWNER -c “$ORACLE_HOME/bin/dbshut”
rm -f /var/lock/subsys/dbora
;;
*)
echo $”Usage: $prog {start|stop}”
exit 1
esac
echo ” ”
echo “+———————-+”
echo “| ENDING ORACLE SCRIPT |”
echo “+———————-+”
echo ” ”
exit
Manually edit /etc/inittab so that entry to respawn init.cssd comes before running the runlevel 3
Orignal /etc/inittab file: (…)
# System initialization.
l5:5:wait:/etc/rc.d/rc 5
l6:6:wait:/etc/rc.d/rc 6
(…)
h1:35:respawn:/etc/init.d/init.cssd run >/dev/null 2>&1 </dev/null
Modified /etc/inittab file: (…)
# System initialization.
si::sysinit:/etc/rc.d/rc.sysinit
l0:0:wait:/etc/rc.d/rc 0
l1:1:wait:/etc/rc.d/rc 1
l2:2:wait:/etc/rc.d/rc 2
h1:35:respawn:/etc/init.d/init.cssd run >/dev/null 2>&1 </dev/null
l3:3:wait:/etc/rc.d/rc 3
(…)
5.5.5 : Configure Listener/ Tnsnames files for ASM/Database instance
Listener.ora :
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = devora01)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = +ASM)
(ORACLE_HOME =/u01/app/oracle/product/10.2.0/db_1)
(SID_NAME = +ASM)
)
(SID_DESC =
(GLOBAL_DBNAME = wygtrn)
(ORACLE_HOME =/u01/app/oracle/product/10.2.0/db_1)
(SID_NAME = dev)
)
)
Tnsnames.ora :
asm=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME =+ASM)
)
)
wygdev=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = dev)
)
)
Leave a Reply
You must be logged in to post a comment.