Solved

Cannot change current_listener on linux Oracle10g server

Posted on 2008-10-08
3
600 Views
Last Modified: 2013-12-18
Hello

I'm trying to change the current_listener on our linux oracle10g server. This is what i do
LSNRCTL>l show current_listener
Current listener is LISTENER
LSNRCTL>set current_listener LISTENER_S2
Current listener is LISTENER_S2
LSNRCTL>exit
$lsnrctl
LSNRCTL>show current_listener
Current listener is LISTENER

It changes when i set it but it doesn't save it. I've tryied from lsnrctl to save_config but the result it the same.

Thank you.
Teo


0
Comment
Question by:temmelv
[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
3 Comments
 
LVL 74

Accepted Solution

by:
sdstuber earned 500 total points
ID: 22668655
set current_listener  doesn't change the processes running it only changes which listener the lsnrctl program will modify for unclarified commands.

It simply changes which listener that lsnrctl will run commands for.

so,  if you do...

$lsnrctl
LSNRCTL>     <<<  at this point nothing happens, the current listener is LISTENER
LSNRCTL>start    <<<<-  this will start a listener called LISTENER
LSNRCTL>set current_listener LISTENER_S2  <<<<-  this changes which listener will be operated on
LSNRCTL>start   <<<<<-  this will start a listener called LISTENER_S2
LSNRCTL>exit

you will now have 2 listeners running   LISTENER  and LISTENER_S2

$ lsnrctl stop LISTENER    <<<< this will stop the listener called LISTENER
$ lsnrctl stop LISTENER_S2   <<< this will stop the listener called LISTENER_S2

lsnrctl always defaults to LISTENER as the current_listener

you can specify actions by including the listener you want with the command to override the default

$ lsnrctl start LISTENER_S2  <<< this will start the LISTENER_S2 listener




0
 

Author Closing Comment

by:temmelv
ID: 31504142
Thank you that clarified it
0
 
LVL 74

Expert Comment

by:sdstuber
ID: 22669836
you're welcome,  but why only a B?  if you needed additional information, just ask,
please don't assign a penalty grade with giving the volunteers (not just me) a chance.
0

Featured Post

Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

Question has a verified solution.

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

Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Suggested Courses

632 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