Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Cannot change current_listener on linux Oracle10g server

Posted on 2008-10-08
3
Medium Priority
?
604 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 1500 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

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

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‚Ķ
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
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.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

662 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