Solved

modifing oracle 7.3.4 listerner install on  solaris 7

Posted on 2007-03-20
4
754 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 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 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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
Via a live example, show how to take different types of Oracle backups using RMAN.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

735 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