Installing libaio-devel-0.3.106, unixODBC-2.2.11 and unixODBC-devel-2.2.11 packages required for Oracle 11gR2 installation on RedHat Linux

While installing Oracle 11g R2 on RedHat Linux 5, run Installer complained that libaio-devel-0.3.106, unixODBC-2.2.11 and unixODBC-devel-2.2.11 packages were missing.

Oracle documentation says "If a package is not installed, then install it from the Linux distribution media or
download the required package version from the Linux vendor’s Web site."

Another way to downloading and installing these packages is using yum package installer in RedHat Linux.

[root@isvx7 ora_binaries]# yum install libaio-devel-0.3.106 Loaded plugins: rhnplugin, security Setting up Install Process Resolving Dependencies --> Running transaction check ---> Package libaio-devel.i386 0:0.3.106-5 set to be updated ---> Package libaio-devel.x86_64 0:0.3.106-5 set to be updated --> Finished Dependency Resolution Dependencies Resolved ================================================================================  Package           Arch        Version          Repository                 Size ================================================================================ Installing:  libaio-devel      i386        0.3.106-5        rhel-x86_64-server-5       12 k  libaio-devel      x86_64      0.3.106-5        rhel-x86_64-server-5       11 k Transaction Summary ================================================================================ Install       2 Package(s) Upgrade       0 Package(s) Total download size: 23 k Is this ok [y/N]: y Downloading Packages: (1/2): libaio-devel-0.3.106-5.x86_64.rpm                 |  11 kB     00:00 (2/2): libaio-devel-0.3.106-5.i386.rpm                   |  12 kB     00:00 -------------------------------------------------------------------------------- Total                                           5.8 kB/s |  23 kB     00:03 Running rpm_check_debug Running Transaction Test Finished Transaction Test Transaction Test Succeeded Running Transaction   Installing     : libaio-devel                                             1/2   Installing     : libaio-devel                                             2/2 Installed:   libaio-devel.i386 0:0.3.106-5         libaio-devel.x86_64 0:0.3.106-5 Complete! [root@isvx7 ora_binaries]# [root@isvx7 ora_binaries]# yum install unixODBC-2.2.11 Loaded plugins: rhnplugin, security Setting up Install Process Resolving Dependencies --> Running transaction check ---> Package unixODBC.i386 0:2.2.11-7.1 set to be updated ---> Package unixODBC.x86_64 0:2.2.11-7.1 set to be updated --> Finished Dependency Resolution Dependencies Resolved ================================================================================  Package        Arch         Version           Repository                  Size ================================================================================ Installing:  unixODBC       i386         2.2.11-7.1        rhel-x86_64-server-5       832 k  unixODBC       x86_64       2.2.11-7.1        rhel-x86_64-server-5       837 k Transaction Summary ================================================================================ Install       2 Package(s) Upgrade       0 Package(s) Total download size: 1.6 M Is this ok [y/N]: y Downloading Packages: (1/2): unixODBC-2.2.11-7.1.i386.rpm                      | 832 kB     00:01 (2/2): unixODBC-2.2.11-7.1.x86_64.rpm                    | 837 kB     00:01 -------------------------------------------------------------------------------- Total                                           442 kB/s | 1.6 MB     00:03 Running rpm_check_debug Running Transaction Test Finished Transaction Test Transaction Test Succeeded Running Transaction   Installing     : unixODBC                                                 1/2   Installing     : unixODBC                                                 2/2 Installed:   unixODBC.i386 0:2.2.11-7.1            unixODBC.x86_64 0:2.2.11-7.1 Complete! [root@isvx7 ora_binaries]# [root@isvx7 ora_binaries]# yum install unixODBC-devel-2.2.11 Loaded plugins: rhnplugin, security Setting up Install Process Resolving Dependencies --> Running transaction check ---> Package unixODBC-devel.i386 0:2.2.11-7.1 set to be updated ---> Package unixODBC-devel.x86_64 0:2.2.11-7.1 set to be updated --> Finished Dependency Resolution Dependencies Resolved ================================================================================  Package            Arch       Version           Repository                Size ================================================================================ Installing:  unixODBC-devel     i386       2.2.11-7.1        rhel-x86_64-server-5     737 k  unixODBC-devel     x86_64     2.2.11-7.1        rhel-x86_64-server-5     793 k Transaction Summary ================================================================================ Install       2 Package(s) Upgrade       0 Package(s) Total download size: 1.5 M Is this ok [y/N]: y Downloading Packages: (1/2): unixODBC-devel-2.2.11-7.1.i386.rpm                | 737 kB     00:01 (2/2): unixODBC-devel-2.2.11-7.1.x86_64.rpm              | 793 kB     00:02 -------------------------------------------------------------------------------- Total                                           322 kB/s | 1.5 MB     00:04 Running rpm_check_debug Running Transaction Test Finished Transaction Test Transaction Test Succeeded Running Transaction   Installing     : unixODBC-devel                                           1/2   Installing     : unixODBC-devel                                           2/2 Installed:   unixODBC-devel.i386 0:2.2.11-7.1      unixODBC-devel.x86_64 0:2.2.11-7.1 Complete! [root@isvx7 ora_binaries]#

After installing the missing packages, click the back button. Now, click next to continue. This time you will not see the error message, and the installation will continue.

Adding swap to a RedHat Linux host for Oracle 11gR2 installation

I was installing Oracle 11gR2 on a RedHat Linux when I got the message that there wasn't enough swap space.

On the host system you can total memory and swap as follows:

[root@isvx7 ~]# grep SwapTotal /proc/meminfo SwapTotal:    16386292 kB [root@isvx7 ~]# grep MemTotal /proc/meminfo MemTotal:     65816328 kB [root@isvx7 ~]# cat /proc/swaps Filename                                Type            Size    Used    Priority /dev/sda2                               partition       16386292        0      -1

The following command will create a 1GB swap file

[root@isvx7 ~]# dd if=/dev/zero of=/swapfile bs=1024 count=1024000 1024000+0 records in 1024000+0 records out 1048576000 bytes (1.0 GB) copied, 5.02885 seconds, 209 MB/s [root@isvx7 ~]# ls -lh /swapfile -rw-r--r-- 1 root root 1000M Mar  7 16:48 /swapfile

Setup the swap with the command:

[root@isvx7 ~]# mkswap /swapfile Setting up swapspace version 1, size = 1048571 kB

To enable swap use swapon, but this will not enable it again on  a reboot.

[root@isvx7 ~]# swapon /swapfile [root@isvx7 ~]#

To enable swap at boot time, include the following in the /etc/fstab

[root@isvx7 ora_binaries]# cat /etc/fstab /swapfile               swap                    swap    defaults        0 0

There we go, we can see that the 1GB swap file that we created has been added to swap

[root@isvx7 ora_binaries]# cat /proc/swaps Filename                                Type            Size    Used    Priority /dev/sda2                               partition       16386292        0      -1 /swapfile                               file            1023992 0       -2

Now, let us see if Oracle recognises it.

There we go, the swap error message has gone. Ok, I know there are other error messages that are to be resolved, but one thing at a time :-)

Experiments with RMAN

I'm going to take a backup of my database using RMAN.

$ rman nocatalog target / Recovery Manager: Release 11.2.0.1.0 - Production on Fri Mar 4 17:56:08 2011 Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved. connected to target database: TESTGM (DBID=2787571766) using target database control file instead of recovery catalog RMAN> backup database; Starting backup at 04-MAR-11 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=101 device type=DISK channel ORA_DISK_1: starting full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set input datafile file number=00001 name=/gm_oradata/testgm/system01.dbf input datafile file number=00002 name=/gm_oradata/testgm/sysaux01.dbf input datafile file number=00003 name=/gm_oradata/testgm/undotbs01.dbf input datafile file number=00004 name=/gm_oradata/testgm/users01.dbf channel ORA_DISK_1: starting piece 1 at 04-MAR-11 channel ORA_DISK_1: finished piece 1 at 04-MAR-11 piece handle=/u01/app/oracle/product/11.2.0/dbhome_1/dbs/01m6d3ur_1_1 tag=TAG20110304T175643 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:25 channel ORA_DISK_1: starting full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set including current control file in backup set including current SPFILE in backup set channel ORA_DISK_1: starting piece 1 at 04-MAR-11 channel ORA_DISK_1: finished piece 1 at 04-MAR-11 piece handle=/u01/app/oracle/product/11.2.0/dbhome_1/dbs/02m6d3vk_1_1 tag=TAG20110304T175643 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01 Finished backup at 04-MAR-11 RMAN> quit Recovery Manager complete. $

The RMAN backup files have been saved under the $ORACLE_HOME/dbs directory.

I'll connect to the database, and list the data that is currently in the table. I'll also add a new entry(Rivaldo) to the table

$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.1.0 Production on Mon Mar 7 11:38:10 2011 Copyright (c) 1982, 2009, Oracle.  All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> select * from address_book;         ID NAME ---------- ------------------------------          1 Pele          2 Maradona          3 Ronaldo          4 Romario SQL> insert into address_book values ('5','Rivaldo'); 1 row created. SQL> select * from address_book;         ID NAME ---------- ------------------------------          1 Pele          2 Maradona          3 Ronaldo          4 Romario          5 Rivaldo SQL> commit; Commit complete. SQL> quit Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

Next, to test my backup I'll the datafile as shown below.

$ cd /gm_oradata $ ls lost+found  testgm $ cd testgm $ ls control01.ctl  redo01.log     redo03.log     system01.dbf   undotbs01.dbf control02.ctl  redo02.log     sysaux01.dbf   temp01.dbf     users01.dbf $ mv system01.dbf system01.dbf.orig

I'll re-connect to the database and see if I can add another entry(Figo) to the table.

$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.1.0 Production on Mon Mar 7 11:43:49 2011 Copyright (c) 1982, 2009, Oracle.  All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> select * from address_book;         ID NAME ---------- ------------------------------          1 Pele          2 Maradona          3 Ronaldo          4 Romario          5 Rivaldo SQL> insert into address_book values ('6', 'Figo'); 1 row created. SQL> select * from address_book;         ID NAME ---------- ------------------------------          1 Pele          2 Maradona          3 Ronaldo          4 Romario          5 Rivaldo          6 Figo 6 rows selected. SQL> shutdown immediate; ORA-01097: cannot shutdown while in a transaction - commit or rollback first SQL> commit; Commit complete. SQL> shutdown immediate; ORA-01116: error in opening database file 1 ORA-01110: data file 1: '/gm_oradata/testgm/system01.dbf' ORA-27041: unable to open file IBM AIX RISC System/6000 Error: 2: No such file or directory Additional information: 3 Additional information: 2 Additional information: 4194304 SQL>

As you see above I was first not able to do a shutdown immediate,

Now if you go and try RMAN recovery, you'll see it will fail. Even listing the backup will fail.

$ rman nocatalog target / Recovery Manager: Release 11.2.0.1.0 - Production on Mon Mar 7 11:55:52 2011 Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved. connected to target database: TESTGM (DBID=2787571766) using target database control file instead of recovery catalog RMAN> list backup; RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of list command at 03/07/2011 11:55:58 ORA-01116: error in opening database file 1 ORA-01110: data file 1: '/gm_oradata/testgm/system01.dbf' ORA-27041: unable to open file IBM AIX RISC System/6000 Error: 2: No such file or directory Additional information: 3 Additional information: 2 Additional information: 4194304 RMAN>

I went back and did a shutdown abort, but even that did not help in listing the backup.

SQL> shutdown abort; ORACLE instance shut down. SQL> quit $  rman nocatalog target / Recovery Manager: Release 11.2.0.1.0 - Production on Mon Mar 7 12:01:18 2011 Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved. connected to target database (not started) RMAN> list backup; RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of list command at 03/07/2011 12:01:33 RMAN-06403: could not obtain a fully authorized session ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist IBM AIX RISC System/6000 Error: 2: No such file or directory RMAN>

Next, I mounted my database and then tried to list the RMAN backup. This worked. The moral of the story, to list the backups in RMAN the database should be mounted.

$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.1.0 Production on Mon Mar 7 12:04:06 2011 Copyright (c) 1982, 2009, Oracle.  All rights reserved. Connected to an idle instance. SQL> startup mount; ORACLE instance started. Total System Global Area 1.0289E+10 bytes Fixed Size                  2215712 bytes Variable Size            5268046048 bytes Database Buffers         4999610368 bytes Redo Buffers               18743296 bytes Database mounted. SQL> RMAN> list backup; List of Backup Sets =================== BS Key  Type LV Size       Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 1       Full    995.00M    DISK        00:00:15     04-MAR-11         BP Key: 1   Status: AVAILABLE  Compressed: NO  Tag: TAG20110304T175643         Piece Name: /u01/app/oracle/product/11.2.0/dbhome_1/dbs/01m6d3ur_1_1   List of Datafiles in backup set 1   File LV Type Ckp SCN    Ckp Time  Name   ---- -- ---- ---------- --------- ----   1       Full 1467357    04-MAR-11 /gm_oradata/testgm/system01.dbf   2       Full 1467357    04-MAR-11 /gm_oradata/testgm/sysaux01.dbf   3       Full 1467357    04-MAR-11 /gm_oradata/testgm/undotbs01.dbf   4       Full 1467357    04-MAR-11 /gm_oradata/testgm/users01.dbf BS Key  Type LV Size       Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 2       Full    7.42M      DISK        00:00:01     04-MAR-11         BP Key: 2   Status: AVAILABLE  Compressed: NO  Tag: TAG20110304T175643         Piece Name: /u01/app/oracle/product/11.2.0/dbhome_1/dbs/02m6d3vk_1_1   SPFILE Included: Modification time: 04-MAR-11   SPFILE db_unique_name: TESTGM   Control File Included: Ckp SCN: 1467365      Ckp time: 04-MAR-11 RMAN>

Now that I'm able to list the backups let us try an restore the datafile(system01.dbf) that we had lost.

RMAN> restore datafile '/gm_oradata/testgm/system01.dbf'; Starting restore at 07-MAR-11 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=1 device type=DISK channel ORA_DISK_1: starting datafile backup set restore channel ORA_DISK_1: specifying datafile(s) to restore from backup set channel ORA_DISK_1: restoring datafile 00001 to /gm_oradata/testgm/system01.dbf channel ORA_DISK_1: reading from backup piece /u01/app/oracle/product/11.2.0/dbhome_1/dbs/01m6d3ur_1_1 channel ORA_DISK_1: piece handle=/u01/app/oracle/product/11.2.0/dbhome_1/dbs/01m6d3ur_1_1 tag=TAG20110304T175643 channel ORA_DISK_1: restored backup piece 1 channel ORA_DISK_1: restore complete, elapsed time: 00:00:03 Finished restore at 07-MAR-11 RMAN>

On the host system we see that the file is now back

isvp17> pwd /gm_oradata/testgm isvp17> ls -l system01.dbf -rw-r-----    1 oracle   sys       713039872 Mar 07 12:12 system01.dbf isvp17> ls control01.ctl      redo02.log         system01.dbf       undotbs01.dbf control02.ctl      redo03.log         system01.dbf.orig  users01.dbf redo01.log         sysaux01.dbf       temp01.dbf

Next, we will recover the file

RMAN> recover  datafile '/gm_oradata/testgm/system01.dbf'; Starting recover at 07-MAR-11 using channel ORA_DISK_1 starting media recovery archived log for thread 1 with sequence 25 is already on disk as file /home/test/1_25_743963641.dbf archived log for thread 1 with sequence 26 is already on disk as file /home/test/1_26_743963641.dbf archived log for thread 1 with sequence 27 is already on disk as file /home/test/1_27_743963641.dbf archived log for thread 1 with sequence 28 is already on disk as file /home/test/1_28_743963641.dbf archived log for thread 1 with sequence 29 is already on disk as file /home/test/1_29_743963641.dbf archived log for thread 1 with sequence 30 is already on disk as file /home/test/1_30_743963641.dbf archived log for thread 1 with sequence 31 is already on disk as file /home/test/1_31_743963641.dbf archived log file name=/home/test/1_25_743963641.dbf thread=1 sequence=25 archived log file name=/home/test/1_26_743963641.dbf thread=1 sequence=26 archived log file name=/home/test/1_27_743963641.dbf thread=1 sequence=27 archived log file name=/home/test/1_28_743963641.dbf thread=1 sequence=28 archived log file name=/home/test/1_29_743963641.dbf thread=1 sequence=29 media recovery complete, elapsed time: 00:00:21 Finished recover at 07-MAR-11 RMAN>

Now let us open the database and see if the datafile was actually recovered. There we go, when we did the RMAN backup Rivaldo and Figo was not in the list. Rivaldo and Figo were added later, but after the recovery process the datafile has Rivaldo and Figo in it.

SQL> alter database open; Database altered. SQL> select * from address_book;         ID NAME ---------- ------------------------------          1 Pele          2 Maradona          3 Ronaldo          4 Romario          5 Rivaldo          6 Figo 6 rows selected. SQL>

Changing Archive log location in Oracle 11gR2

In this case the archive log has already been enabled and set up /home/test/archive. I will be changing the
archive log location to the new destination /home/test

SQL> startup mount; ORACLE instance started. Total System Global Area 1.0289E+10 bytes Fixed Size                  2215712 bytes Variable Size            5268046048 bytes Database Buffers         4999610368 bytes Redo Buffers               18743296 bytes Database mounted. SQL> alter system set log_archive_dest_1='location=/home/test' scope=spfile; System altered. SQL> archive log list Database log mode              Archive Mode Automatic archival             Enabled Archive destination            /home/test/archive Oldest online log sequence     23 Next log sequence to archive   25 Current log sequence           25 SQL>

We see that the Archive destination is still pointing to the old location ie. /home/test/archive

SQL> shutdown immediate; ORA-01109: database not open Database dismounted. ORACLE instance shut down. SQL> startup; ORACLE instance started. Total System Global Area 1.0289E+10 bytes Fixed Size                  2215712 bytes Variable Size            5268046048 bytes Database Buffers         4999610368 bytes Redo Buffers               18743296 bytes Database mounted. Database opened. SQL> archive log list; Database log mode              Archive Mode Automatic archival             Enabled Archive destination            /home/test Oldest online log sequence     23 Next log sequence to archive   25 Current log sequence           25 SQL>  SQL> select name, log_mode from v$database; NAME LOG_MODE --------- ------------ TESTGM ARCHIVELOG SQL>

We see that the archive log location has been updated to the new location /home/test

Installing Oracle 11g R2 on AIX 7.1

On AIX 7.1 as root execute the rootpre.sh script which part of the Oracle zip files that you downloaded from the Oracle site. eg.

$ pwd
/home/oracle/database
$ ls
doc           response      rootpre.sh    runInstaller  stage
install       rootpre       rpm           sshsetup      welcome.html


Next as user oracle run runInstaller to start the installation of Oracle binaries using the GUI

$ ./runInstaller
********************************************************************************

Your platform requires the root user to perform certain pre-installation
OS preparation.  The root user should run the shell script 'rootpre.sh' before
you proceed with Oracle installation.  rootpre.sh can be found at the top level
of the CD or the stage area.

Answer 'y' if root has run 'rootpre.sh' so you can proceed with Oracle
installation.
Answer 'n' to abort installation and then ask root to run 'rootpre.sh'.

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

Has 'rootpre.sh' been run by root? [y/n] (n)
y


Next you'll get the below message even if you have met all the pre-reqs as per the Oracle docs.  I was told that this a know issue, so say Yes to it, and continue.

 Check the posting http://shettymayur.blogspot.com/2011/02/oracle-11g-r2-installation-fails-with.html for the getting around the below error message.

Configuring Oracle tsnnames using netca and error ORA-12541 and ORA-01017

I was trying to configure my client to connect to the Oracle server running on a different machine. I used netca to configure create the tnsnames.ora file that is needed to connect from the client to the server.

So as user oracle I started the netca instance on the client machine.

 

I decided to test the configuration by select 'Yes' radio button.

 

I first got the "ORA-12541: TNS: no listener"  error message. This was due to the fact that I had not started the listener on the server side. So as user oracle on the server I started the listener.

$ lsnrctl start

LSNRCTL for IBM/AIX RISC System/6000: Version 11.2.0.1.0 - Production on 01-MAR-2011 15:17:53

Copyright (c) 1991, 2009, Oracle.  All rights reserved.

Starting /u01/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr: please wait...

TNSLSNR for IBM/AIX RISC System/6000: Version 11.2.0.1.0 - Production
System parameter file is /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/isvp18/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=isvp18.storage.tucson.ibm.com)(PORT=1521)))

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for IBM/AIX RISC System/6000: Version 11.2.0.1.0 - Production
Start Date                01-MAR-2011 15:17:53
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      ON
Listener Parameter File   /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/isvp18/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=isvp18.storage.tucson.ibm.com)(PORT=1521)))
The listener supports no services
The command completed successfully
$ lsnrctl status

LSNRCTL for IBM/AIX RISC System/6000: Version 11.2.0.1.0 - Production on 01-MAR-2011 15:18:38

Copyright (c) 1991, 2009, Oracle.  All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for IBM/AIX RISC System/6000: Version 11.2.0.1.0 - Production
Start Date                01-MAR-2011 15:17:53
Uptime                    0 days 0 hr. 0 min. 44 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      ON
Listener Parameter File   /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/isvp18/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=isvp18.storage.tucson.ibm.com)(PORT=1521)))
Services Summary...
Service "testgm" has 1 instance(s).
  Instance "testgm", status READY, has 1 handler(s) for this service...
Service "testgmXDB" has 1 instance(s).
  Instance "testgm", status READY, has 1 handler(s) for this service...
The command completed successfully
$

 

 

After that I ran the test again, and this time I got a different error message. This time I got ORA-01017: invalid username/password

I clicked on the Change Login button, and entered the correct login and passowrd, which fixed the issue.

Under $ORACLE_HOME/network/admin I saw that netca had created the tnsnames.ora file for me.

$ cat tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

TESTGM =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 9.11.83.82)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = testgm)
    )
  )

$

Configuring Oracle listener using netca

Here are the screen shots for configuring Oracle listener using netca.

As user oracle execute netca as shown below

 You can see that a new file called listener.ora has been created under the $ORACLE_HOME/network/admin directory

$ pwd
/u01/app/oracle/product/11.2.0/dbhome_1/network/admin
$ cat listener.ora
# listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

TESTGM =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = isvp18.storage.tucson.ibm.com)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  )

ADR_BASE_TESTGM = /u01/app/oracle

$
$ lsnrctl status

LSNRCTL for IBM/AIX RISC System/6000: Version 11.2.0.1.0 - Production on 28-FEB-2011 00:45:44

Copyright (c) 1991, 2009, Oracle.  All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     TESTGM
Version                   TNSLSNR for IBM/AIX RISC System/6000: Version 11.2.0.1.0 - Production
Start Date                28-FEB-2011 00:38:47
Uptime                    0 days 0 hr. 6 min. 58 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      ON
Listener Parameter File   /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/isvp18/testgm/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=isvp18.storage.tucson.ibm.com)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Services Summary...
Service "testgm" has 1 instance(s).
  Instance "testgm", status READY, has 1 handler(s) for this service...
Service "testgmXDB" has 1 instance(s).
  Instance "testgm", status READY, has 1 handler(s) for this service...
The command completed successfully
$