?
Solved

modifing oracle 7.3.4 listerner install on  solaris 7

Posted on 2007-03-20
4
Medium Priority
?
758 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 77

Accepted Solution

by:
slightwv (䄆 Netminder) earned 2000 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 77

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

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

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

Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Suggested Courses

777 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