Solved

modifing oracle 7.3.4 listerner install on  solaris 7

Posted on 2007-03-20
4
753 Views
Last Modified: 2013-12-19
hello expert,

I running oracle 7.3.4 on solaris 7 platform.

I have a one listener that service two database host on the solaris server

(sid name har701 and nbs701)

The databse with sid_name har701 is no longer need as this was a test database

that has been transfer to another server

HOW can in modify the listener to remove the entries pertaining to har701 database.

Also i know with oracle 9i you can use oracle net manager graphical tool to

create delete and modify a listener service , are they any such tools for

oracle 7.3.4.

below is copy of the listener.ora file
 
solaris server.



foredba>cat listener.ora
LISTENER =
  (ADDRESS_LIST =
        (ADDRESS =
          (PROTOCOL = TCP)
          (HOST = nbssun-svr)
          (PORT = 1521)
        )
  )
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = har701)
      (ORACLE_HOME = /applics/oraclev732)
    )
    (SID_DESC =
      (SID_NAME = nbs701)
      (ORACLE_HOME = /applics/oraclev732)
    )
  )
TRACE_LEVEL_LISTENER = OFF
REMOTE_DBA_OPS_ALLOWED = (nbs701)
0
Comment
Question by:jomfra
  • 2
  • 2
4 Comments
 
LVL 76

Accepted Solution

by:
slightwv (䄆 Netminder) earned 500 total points
ID: 18756755
copy the original file for a backup.  Just edit it with vi and remove the other instance.   You just need to be careful because Oracle likes things in the correct places.   Even spaces.

This should work (I hope):
-----------------------------------------
LISTENER =
  (ADDRESS_LIST =
        (ADDRESS =
          (PROTOCOL = TCP)
          (HOST = nbssun-svr)
          (PORT = 1521)
        )
  )
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = nbs701)
      (ORACLE_HOME = /applics/oraclev732)
    )
  )
TRACE_LEVEL_LISTENER = OFF
REMOTE_DBA_OPS_ALLOWED = (nbs701)
0
 

Author Comment

by:jomfra
ID: 18757904
HELLO expert,

do i have to stop the listener to effect change?
0
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
ID: 18758231
You don't need to stop the listener to edit the file.  After you edit the file, you will need to stop/start the listener for it to take effect.
0
 

Author Comment

by:jomfra
ID: 18758372
hello expert,

thanks
0

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
data lookup in Oracle - need suggestions 55 121
Oracle Listener Not Starting 11 52
Oracle dataguard 5 45
capture vmstat info and insert it into an oracle table 31 35
Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question