Oracle

Database 12c Opatch Failed error code 73 Solution

Problem description:

Applying opatch failled:

 [oracle@ermankara 24732082]$ /u01/app/oracle/product/12.1.2/db/OPatch/opatch apply

Oracle Interim Patch Installer version 12.2.0.1.9

Copyright (c) 2017, Oracle Corporation.  All rights reserved.

Oracle Home       : /u01/app/oracle/product/12.1.2/db

Central Inventory : /u01/app/oraInventory

from           : /u01/app/oracle/product/12.1.2/db/oraInst.loc

OPatch version    : 12.2.0.1.9

OUI version       : 12.1.0.2.0

Log file location : /u01/app/oracle/product/12.1.2/db/cfgtoollogs/opatch/opatch2017-07-20_20-41-39PM_1.log

Verifying environment and performing prerequisite checks...

Prerequisite check "CheckActiveFilesAndExecutables" failed.

The details are:

Following executables are active :

/u01/app/oracle/product/12.1.2/db/bin/oracle

UtilSession failed: Prerequisite check "CheckActiveFilesAndExecutables" failed.

Log file location: /u01/app/oracle/product/12.1.2/db/cfgtoollogs/opatch/opatch2017-07-20_20-41-39PM_1.log

OPatch failed with error code 73

Solution :

Step 1 : Something is using oracle library. Check which process is locking this library file using below command and kill it.

[oracle@ermankara 24732082]$ /sbin/fuser /u01/app/oracle/product/12.1.2/db/lib/libclntsh.so.12.1
/u01/app/oracle/product/12.1.2/db/lib/libclntsh.so.12.1: 26694m

26694 Process using oracle library.

[oracle@ermankara 24732082]$ kill -9 26694

Step 2 : Process killed. Now, Let’s continue to update the opatch again.


[oracle@ermankara 24732082]$ /u01/app/oracle/product/12.1.2/db/OPatch/opatch apply
Oracle Interim Patch Installer version 12.2.0.1.9
Copyright (c) 2017, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/oracle/product/12.1.2/db
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/12.1.2/db/oraInst.loc
OPatch version    : 12.2.0.1.9
OUI version       : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.2/db/cfgtoollogs/opatch/opatch2017-07-20_20-44-47PM_1.log

Verifying environment and performing prerequisite checks...
OPatch continues with these patches:   19769480  20299023  20831110  21359755  21948354  22291127  23054246  24006101  24732082  

Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/app/oracle/product/12.1.2/db')


Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying sub-patch '19769480' to OH '/u01/app/oracle/product/12.1.2/db'

Patching component oracle.rdbms.deconfig, 12.1.0.2.0...

Patching component oracle.xdk, 12.1.0.2.0...

Patching component oracle.tfa, 12.1.0.2.0...

Patching component oracle.rdbms.util, 12.1.0.2.0...

Patching component oracle.rdbms, 12.1.0.2.0...

Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...

Patching component oracle.xdk.parser.java, 12.1.0.2.0...

Patching component oracle.oraolap, 12.1.0.2.0...

Patching component oracle.xdk.rsf, 12.1.0.2.0...

Patching component oracle.rdbms.rsf, 12.1.0.2.0...

Patching component oracle.rdbms.rman, 12.1.0.2.0...

Patching component oracle.ldap.rsf, 12.1.0.2.0...

Patching component oracle.ldap.rsf.ic, 12.1.0.2.0...
Applying sub-patch '20299023' to OH '/u01/app/oracle/product/12.1.2/db'
ApplySession: Optional component(s) [ oracle.has.crs, 12.1.0.2.0 ]  not present in the Oracle Home or a higher version is found.

Patching component oracle.tfa, 12.1.0.2.0...

Patching component oracle.rdbms.deconfig, 12.1.0.2.0...

Patching component oracle.rdbms.rsf, 12.1.0.2.0...

Patching component oracle.rdbms, 12.1.0.2.0...

Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...

Patching component oracle.rdbms.rsf.ic, 12.1.0.2.0...

Patching component oracle.ldap.rsf, 12.1.0.2.0...

Patching component oracle.ldap.rsf.ic, 12.1.0.2.0...
Applying sub-patch '20831110' to OH '/u01/app/oracle/product/12.1.2/db'

Patching component oracle.rdbms, 12.1.0.2.0...

Patching component oracle.oraolap.dbscripts, 12.1.0.2.0...

Patching component oracle.ldap.rsf, 12.1.0.2.0...

Patching component oracle.tfa, 12.1.0.2.0...

Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...

Patching component oracle.rdbms.rsf, 12.1.0.2.0...
Applying sub-patch '21359755' to OH '/u01/app/oracle/product/12.1.2/db'

Patching component oracle.assistants.server, 12.1.0.2.0...

Patching component oracle.rdbms.rsf, 12.1.0.2.0...

Patching component oracle.rdbms, 12.1.0.2.0...

Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...

Patching component oracle.tfa, 12.1.0.2.0...
Applying sub-patch '21948354' to OH '/u01/app/oracle/product/12.1.2/db'

Patching component oracle.rdbms.deconfig, 12.1.0.2.0...

Patching component oracle.xdk, 12.1.0.2.0...

Patching component oracle.tfa, 12.1.0.2.0...

Patching component oracle.rdbms, 12.1.0.2.0...

Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...

Patching component oracle.xdk.parser.java, 12.1.0.2.0...

Patching component oracle.rdbms.rsf, 12.1.0.2.0...

Patching component oracle.xdk.rsf, 12.1.0.2.0...
Applying sub-patch '22291127' to OH '/u01/app/oracle/product/12.1.2/db'
ApplySession: Optional component(s) [ oracle.oid.client, 12.1.0.2.0 ]  not present in the Oracle Home or a higher version is found.

Patching component oracle.ldap.rsf, 12.1.0.2.0...

Patching component oracle.ldap.client, 12.1.0.2.0...

Patching component oracle.tfa, 12.1.0.2.0...

Patching component oracle.rdbms, 12.1.0.2.0...

Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...

Patching component oracle.rdbms.rsf, 12.1.0.2.0...

Patching component oracle.oraolap, 12.1.0.2.0...

Patching component oracle.rdbms.rman, 12.1.0.2.0...

Patching component oracle.oraolap.dbscripts, 12.1.0.2.0...
Applying sub-patch '23054246' to OH '/u01/app/oracle/product/12.1.2/db'

Patching component oracle.rdbms.dv, 12.1.0.2.0...

Patching component oracle.rdbms.rsf, 12.1.0.2.0...

Patching component oracle.rdbms.rman, 12.1.0.2.0...

Patching component oracle.rdbms, 12.1.0.2.0...

Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...

Patching component oracle.ldap.rsf, 12.1.0.2.0...

Patching component oracle.install.deinstalltool, 12.1.0.2.0...

Patching component oracle.ldap.rsf.ic, 12.1.0.2.0...

Patching component oracle.oracore.rsf, 12.1.0.2.0...

Patching component oracle.ctx, 12.1.0.2.0...

Patching component oracle.xdk, 12.1.0.2.0...

Patching component oracle.nlsrtl.rsf, 12.1.0.2.0...

Patching component oracle.xdk.parser.java, 12.1.0.2.0...

Patching component oracle.ctx.atg, 12.1.0.2.0...
Applying sub-patch '24006101' to OH '/u01/app/oracle/product/12.1.2/db'

Patching component oracle.sqlplus, 12.1.0.2.0...

Patching component oracle.rdbms, 12.1.0.2.0...

Patching component oracle.network.listener, 12.1.0.2.0...

Patching component oracle.network.rsf, 12.1.0.2.0...

Patching component oracle.rdbms.dv, 12.1.0.2.0...

Patching component oracle.rdbms.rman, 12.1.0.2.0...

Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...

Patching component oracle.sqlplus.ic, 12.1.0.2.0...

Patching component oracle.rdbms.rsf, 12.1.0.2.0...
Applying sub-patch '24732082' to OH '/u01/app/oracle/product/12.1.2/db'

Patching component oracle.rdbms.install.plugins, 12.1.0.2.0...

Patching component oracle.rdbms.rsf, 12.1.0.2.0...

Patching component oracle.tfa, 12.1.0.2.0...

Patching component oracle.rdbms.rman, 12.1.0.2.0...

Patching component oracle.rdbms, 12.1.0.2.0...

Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...
Composite patch 24732082 successfully applied.
Log file location: /u01/app/oracle/product/12.1.2/db/cfgtoollogs/opatch/opatch2017-07-20_20-44-47PM_1.log

OPatch succeeded.
[oracle@ermankara 24732082]$ /u01/app/oracle/product/12.1.2/db/OPatch/opatch lsinventory
Oracle Interim Patch Installer version 12.2.0.1.9
Copyright (c) 2017, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/oracle/product/12.1.2/db
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/12.1.2/db/oraInst.loc
OPatch version    : 12.2.0.1.9
OUI version       : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.2/db/cfgtoollogs/opatch/opatch2017-07-20_20-46-30PM_1.log

Lsinventory Output file location : /u01/app/oracle/product/12.1.2/db/cfgtoollogs/opatch/lsinv/lsinventory2017-07-20_20-46-30PM.txt

--------------------------------------------------------------------------------
Local Machine Information::
Hostname: ermankara.localdomain
ARU platform id: 226
ARU platform description:: Linux x86-64

Installed Top-level Products (1): 

Oracle Database 12c                                                  12.1.0.2.0
There are 1 products installed in this Oracle Home.


Interim patches (1) :

Patch  24732082     : applied on Thu Jul 20 20:45:37 EEST 2017
Unique Patch ID:  20904347
Patch description:  "Database Patch Set Update : 12.1.0.2.170117 (24732082)"
   Created on 21 Dec 2016, 07:15:01 hrs PST8PDT
Sub-patch  24006101; "Database Patch Set Update : 12.1.0.2.161018 (24006101)"
Sub-patch  23054246; "Database Patch Set Update : 12.1.0.2.160719 (23054246)"
Sub-patch  22291127; "Database Patch Set Update : 12.1.0.2.160419 (22291127)"
Sub-patch  21948354; "Database Patch Set Update : 12.1.0.2.160119 (21948354)"
Sub-patch  21359755; "Database Patch Set Update : 12.1.0.2.5 (21359755)"
Sub-patch  20831110; "Database Patch Set Update : 12.1.0.2.4 (20831110)"
Sub-patch  20299023; "Database Patch Set Update : 12.1.0.2.3 (20299023)"
Sub-patch  19769480; "Database Patch Set Update : 12.1.0.2.2 (19769480)"
   Bugs fixed:
     19309466, 19902195, 18250893, 21172913, 17655240, 21266085, 19028800
     19035573, 19366375, 18456643, 24523374, 19289642, 18845653, 19915271
     21291274, 18417036, 20475845, 22148226, 22528741, 19243521, 19658708
     21153266, 19326908, 19597583, 17414008, 20897759, 19174430, 22046677
     22243719, 24825843, 21960504, 19054077, 22657942, 20688221, 20428621
     21899588, 21387964, 13542050, 19723336, 19835133, 17532734, 19333670
     21373473, 23260854, 19687159, 14643995, 20977794, 20734332, 19012119
     19869255, 17551063, 18681056, 23324000, 19676012, 20588502, 19520602
     19841800, 19439759, 20245930, 19303936, 19001359, 21476308, 22916353
     19393542, 23533524, 21099555, 22353346, 19141838, 19644859, 21915719
     21106027, 19908836, 21421886, 22529728, 19358317, 19134173, 19524158
     20447445, 21188584, 19335438, 20803014, 23025340, 19390567, 19058490
     18799993, 19769480, 21097043, 19475971, 21225209, 19284031, 20677396
     19450314, 19016730, 18967382, 20919320, 22075064, 20347562, 20348653
     22551446, 19896336, 24812585, 20048359, 21896069, 19524384, 22496904
     16439813, 18354830, 20596234, 20440930, 20936905, 22022760, 19171086
     23197103, 17867700, 19791273, 18990023, 21241829, 19591608, 22296366
     20173897, 17210525, 18914624, 19571367, 21260431, 19501299, 20425790
     20181030, 25056052, 19124589, 19402853, 19888853, 16870214, 17722075
     18202441, 18743542, 19001390, 20882568, 19081128, 22173980, 21875360
     19178851, 19149990, 20951038, 22168163, 19606174, 16777441, 25161298
     20848335, 24308635, 19791377, 19050649, 19382851, 20920911, 20528052
     22762046, 19189525, 19469538, 20598042, 18988834, 22458049, 19176326
     19048007, 19238590, 20387265, 21263635, 24397438, 22160989, 20356733
     22380919, 18499088, 18436647, 20825533, 18952989, 21059919, 22294260
     20794034, 19468347, 20284155, 19883092, 20657441, 17365043, 21285458
     20952966, 19176223, 21300341, 18288842, 19699191, 22353199, 24437510
     22083366, 20669434, 18964978, 19577410, 21373076, 14283239, 19931709
     21239530, 20880215, 20798891, 18122373, 20043616, 23124895, 19013183
     18856999, 21450666, 18893947, 21133343, 22695831, 21196809, 21354456
     19587324, 20464614, 24808595, 22062026, 19189317, 18307021, 21917884
     19708632, 20711718, 20134339, 22815955, 22077517, 18973548, 24690216
     22507210, 20101006, 19197175, 18797519, 23501901, 19597439, 21387128
     19180770, 19879746, 19354335, 21785691, 19730508, 22366558, 6599380
     24285405, 18964939, 21575362, 22365117, 21542577, 22507234, 23170620
     20627866, 20124446, 16923858, 19518079, 19371175, 20466322, 18940497
     19074147, 22923409, 20842388, 17274537, 21380789, 19154375, 20474192
     19044962, 19532017, 19662635, 22374754, 20560611, 18899974, 18705806
     20471920, 19052488, 22024071, 20074391, 22809871, 21184223, 23089357
     19157754, 21220620, 24316947, 18921743, 19865345, 19065677, 19065556
     19018447, 19018206, 19777862, 22223463, 19304354, 21322887, 20879889
     20890311, 19578350, 20869721, 21756699, 20217801, 18819908, 19363645
     21072646, 20898391, 19291380, 20373598, 19248799, 20031873, 19155797
     19279273, 18886413, 18618122, 20922010, 19990037, 20509482, 24739928
     18966843, 19077215, 21526048, 20704450, 19068970, 21620471, 19023822
     19670108, 19068610, 20267166, 21756677, 20476175, 18549238, 20328248
     18674047, 19385656, 18849537, 19684504, 20315311, 20899461, 19308965
     19143550, 19024808, 18948177, 19468991, 20009833, 20868862, 20466628
     21756661, 20397490, 19706965, 22178855, 19604659, 16359751, 19032777
     19329654, 19928926, 20212067, 20603378, 18974476, 23314180, 20859910
     19307662, 21847223, 21668627, 20281121, 19075256, 20877664, 19487147
     19076343, 24577566, 19430401, 19676905, 20844426, 20904530, 20925795
     20441797, 21296029, 21629064, 21442094, 23229229, 22865673, 20708701
     19280225, 21315084, 18840932, 18740837, 20294666, 19989009, 18191823
     21517440, 19174942, 17319928, 19703301, 20122715, 18411216, 20117253
     19258504, 21188532, 24386767, 17890099, 21649497, 16887946, 25264559
     18791688, 19721304, 22092979, 19490948, 19619732, 20879709, 20165574
     19272708, 19547370, 19818513, 20139391, 24693382, 20228093, 21281532
     19978542, 22165897, 22359063, 19409212, 19805359, 19461270, 19434529
     18799063, 18990693, 20378086, 21246723, 21632821, 20831538, 20424899
     20361671, 18674024, 19689979, 20235511, 23220453, 19873610, 16619249
     20562898, 21091431, 19440586, 22757364, 18610915, 22175564, 19561643
     19399918, 19195895, 20832516, 20017509, 20907061, 21665897, 20746251
     19183343, 21787056, 21273804, 19067244, 18043064, 21329301, 18885870
     19536415, 17835294, 20446883, 24413809, 21744290, 18254023, 20591183
     20413820, 19185876, 22465352, 20558005, 20402832, 19627012, 20093776
     18909599, 20618595, 16863642, 19639483, 19315691, 20331945, 19512341
     21479753, 19637186, 19174521, 19022470, 18607546, 20401975, 18306996
     18851894, 19649152, 20581111, 19201867, 20318889, 20936731, 21060755
     21294938, 20898997, 18510194, 19534363, 19188927



--------------------------------------------------------------------------------

OPatch succeeded.
[oracle@ermankara 24732082]$ 
Advertisements
Standard
Oracle

DBCA Templates Provided by Oracle

Here in DBCA we have to choose the template of our database which means that here we have to choose what kind of database we want to create.

Here we have 3 options:

Data warehouse : 

Users perform numerous, complex queries that process large volumes of data. Response time, accuracy, and availability are key issues.

These queries (SELECT statements) range from a fetch of a few records to queries that sort thousands of records from many different tables.

General Purpose or Transaction processing:

Many concurrent users perform numerous transactions that require rapid access to data. Availability, speed, concurrency, and recoverability are key issues.

Transactions consist of reading (SELECT statements), writing (INSERT and UPDATE statements), and deleting (DELETE statements) data in database tables.

Custom database : 

This template allows you maximum flexibility in defining a database because you can change any of the settings for the database being created.

19

Resource :

https://docs.oracle.com/cd/E11882_01/server.112/e10897/install.htm#BABHDEDA

Standard
Linux

Adding Physical Disk to Server -SCSI

SCSI ( Small Computer System Interface ) If you have added new storage to a running VM, you probably won’t see it. This is because the SCSI bus to which the storage devices are connected needs to be rescanned to make the new hardware visible.

Linux, when adding a new disc.

Connect to system with “root” user.

# ls /sys/class/scsi_host

Screen Shot 2017-07-18 at 10.08.37
Instead of the “#” in the above command, you will enter the host numbers on your system. Run the command down to write to the host file.

# echo "- - -"> / sys / class / scsi_host / host # / scan

 

As an example my system has seen 5 hosts, so I run the following commands.

 

Screen Shot 2017-07-18 at 10.09.03
You can test it with the fdisk command.

#fdisk -l

#tail -f / var / log / message

Screen Shot 2017-07-18 at 10.09.20

Standard
Weblogic

WebLogic Server 11g and 12c Configure SSL for a Managed Server

Web browser connects to WebLogic Server by supplying the SSL listen port and the HTTPs protocol in the connection URL, for example, https://ip:7002/console
Connect  to weblogic with Username / Password.

Ekran Resmi 2017-01-02 16.33.10.png

Weblogic server must be reachable, Node Manager Type = Plain make sure that each server has the SSL port enabled. You can find the setting “SSL Listen Port Enabled” for each server under “Configuration -> General”. Enable it and make sure you use a correct and free port.

Open console > Environment > Servers > open a managed server.

Screen Shot 2017-07-17 at 13.31.54.png

Be careful, Node Manager Type must be  “Plain”.

Screen Shot 2017-07-17 at 14.03.39

configure Weblogic for SSL, changing keystores.

Configuration -> Keystores
Custom Identity Keystore: /usr/java/jdk1.7.0_79/bin/***.jks ( Type .jks )
Custom Identity Keystore Type: jks
Custom Identity Keystore Passphrase: ***
Java Standard Trust Keystore Passphrase: ****

save it.

Screen Shot 2017-07-17 at 13.27.37

configure Weblogic for SSL, changing identity:

Configuration -> SSL

Private Key Alias: ***card
Private Key Passphrase: ***2805

save it.

Screen Shot 2017-07-17 at 13.27.46

Ssl and Server restart it.

Screen Shot 2017-07-17 at 13.59.42

Test your SSL configuration:

In another browser window or tab, access the URL:

https://server1:7002/console

https://server2:7002/console

 

Standard
TOAD for Oracle

TOAD Grand Error on Oracle Database

I recently received the following error while trying to connect to a database.

Error Message :

"Access to the following views required:
V$SESSION, V$PROCESS, V$SESS_IO, V$SESSION_WAIT, V$SESSION_EVENT, V$ACCESS, V$SESSSTAT, V$STATNAME, V$OPEN_CURSOR, V$SQL, V$LOCK, V$SESSION_LONGOPS, SYS.V_$TRANSACTION, SYS.V_$ROLLNAME, V$SQLTEXT_WITH_NEWLINES"

Solution :

  1. Open a Linux  terminal and enter the SQL*Plus command:
sqlplus /as sysdba 
SQL> Grant select any dictionary, select any table, select_catalog_role to db_user;

Grant succeeded.

SQL> grant execute on sys.dbms_workload_repository to db_user;

Grant succeeded.

That’s all.

Standard
Oracle

Create Oracle Net Listener that is a network service on Oracle.Login with the “oracle” user and input a command “netca”  or

[oracle@ermantestdb ~] $cd $ORACLE_HOME/network/bin/
[oracle@ermantestdb ~] $ ./netca

Check a box “Listener Configuration” and go next.

Screen Shot 2017-07-16 at 16.17.44

Go next.

Screen Shot 2017-07-16 at 16.17.09.png

Set Listner’s name.

Screen Shot 2017-07-16 at 16.17.15.png

This example goes next with keeping default TCP (Transmission Control Protocol )

Screen Shot 2017-07-16 at 16.17.21.png

Set a port. This example goes next with keeping default.

Screen Shot 2017-07-16 at 16.17.27.png

If you’d like to create more Listeners, Answer “Yes”. This example selects “No”.

Screen Shot 2017-07-16 at 16.17.33.png

Configuration completed.

Screen Shot 2017-07-16 at 16.17.38.png

Click “Finish” to quit.

Screen Shot 2017-07-16 at 16.17.44.png

now, we can see listener.ora file.

[oracle@ermantestdb ~]$ cat /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora 

LISTENER_ermantestdb =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.4.102)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ermantestdb)
    )
  )

If the Oracle listener is not running, you’ll get the following message.

[oracle@ermantestdb ~]$ lsnrctl status

LSNRCTL for Linux: Version 11.2.0 - Production on 15-JUNE-2017 16:27:39

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.0.4.102)(PORT=1521)))
TNS-12541: TNS:no listener
 TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   Linux Error: 111: Connection refused
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
TNS-12541: TNS:no listener
 TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   Linux Error: 2: No such file or directory

If the Oracle listener is running, you’ll get the following message.

[oracle@ermantestdb ~]$ lsnrctl status

LSNRCTL for Linux: Version 11.2.0 - Production on 15-JUNE-2017 16:27:02

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.0.4.102)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.1.0.6.0 - Production
Start Date                15-JUNE-2017 16:43:13
Uptime                    1 days 21 hr. 43 min. 49 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/11.2.0/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/devdb/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=11.2.0)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
Services Summary...
Service "devdb" has 1 instance(s).
  Instance "devdb", status UNKNOWN, has 1 handler(s) for this service...
Service "devdb.thegeekstuff.com" has 1 instance(s).
  Instance "devdb", status READY, has 1 handler(s) for this service...
Service "devdbXDB.thegeekstuff.com" has 1 instance(s).
  Instance "devdb", status READY, has 1 handler(s) for this service...
Service "devdb_XPT.thegeekstuff.com" has 1 instance(s).
  Instance "devdb", status READY, has 1 handler(s) for this service...
The command completed successfully

If the Oracle listener is not running, start the listener as shown below.

[oracle@ermantestdb ~] $ lsnrctl start

If the Oracle listener is running, stop the listener as shown below.

[oracle@ermantestdb ~] $ lsnrctl stop

Create Oracle Net Listener that is a network service on Oracle.

Aside
Linux, Oracle

If you want to install this package from the oracle installation DVD, you first need to mount the dvd and identify the address of the dvd to the oracle repository.

#
 cd /etc/yum.repos.d
# vi public-yum-ol6.repo

Add the following code to the repository. ( public-yum-ol6.repo )

[Install_DVD_base]
name=Install DVD
baseurl=file:///cdrom/Server
gpgcheck=0
enabled=1
skip_if_unavailable=True

Create a new folder and mount the DVD in this folder.

# mkdir /cdrom
# mount -t iso9660 -o ro /dev/cdrom /cdrom

You can install the preinstall package using the yum command.

# yum install oracle-rdbms-server-11gR2-preinstall

How to Mount and Unmount an ISO Image in RHEL ( Version 5,6,7 )

Aside