Home » RDBMS Server » Server Administration » Listener problem again 10g
Listener problem again 10g [message #209913] Mon, 18 December 2006 07:39 Go to next message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
LSNRCTL> start
Starting /oracle/sys/v10/bin/tnslsnr: please wait...

TNSLSNR for IBM/AIX RISC System/6000: Version 10.2.0.1.0 - Production
System parameter file is /oracle/sys/v817/network/admin/listener.ora
Log messages written to /oracle/sys/v10/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=linus.braunag.de)(PORT=1521)))


its running 10g LSNRCTL ..but you can see it is trying to get 8i listener.ora.but log file is writing to 10g location .Any idea how to point it to 10g listener file ???
Re: Listener problem again 10g [message #209919 is a reply to message #209913] Mon, 18 December 2006 09:14 Go to previous messageGo to next message
dba_blr
Messages: 43
Registered: December 2006
Member
Check your TNS_ADMIN environment variable. May be it is pointing to Version 8i location.
Re: Listener problem again 10g [message #209925 is a reply to message #209913] Mon, 18 December 2006 09:33 Go to previous messageGo to next message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
Yes you are correct.see the following ...

oracle@server:/oracle/> . oraenv
ORACLE_SID = [DB10g] ?DB10g -- i set my SID

oracle@server:/oracle/sys/v10> echo $ORACLE_HOME
/oracle/sys/v10 -- Correct
oracle@server:/oracle/sys/v10> echo $ORACLE_SID
DB10g -- Correct
oracle@server:/oracle/sys/v10> echo $TNS_ADMIN
/oracle/sys/v817/network/admin -- INCORRECT .

where can i set it ?any file ?
Re: Listener problem again 10g [message #209929 is a reply to message #209913] Mon, 18 December 2006 09:45 Go to previous messageGo to next message
dba_blr
Messages: 43
Registered: December 2006
Member
I think you do not need set TNS_ADMIN unless you are willing to keep the listener.ora in some non-default location.

You can set it in oraenv or in appropriate profile file.
Re: Listener problem again 10g [message #209932 is a reply to message #209913] Mon, 18 December 2006 09:51 Go to previous messageGo to next message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
>>>I think you do not need set TNS_ADMIN unless you are willing to keep the listener.ora in some non-default location
now $TNS_ADMIN is pointing to /oracle/sys/v817/network/admin
but i want it to point to /oracle/sys/v10/network/admin ,
Because i am running 10g listener .

How can i set it.i mean ,it should be automatically set when i use .oraenv to speicify 10g database name .

Re: Listener problem again 10g [message #209937 is a reply to message #209913] Mon, 18 December 2006 10:00 Go to previous messageGo to next message
dba_blr
Messages: 43
Registered: December 2006
Member
As per your previous message the ORACLE_HOME points to your Oracle 10g location at present. So you do not need to set TNS_ADMIN environment variable.

Oracle by default will search for the network configuration files in the default location, i.e., $ORACLE_HOME/network/admin.

You simply reset the TNS_ADMIN environment variable and try again. Let me know if the solution worked.

Re: Listener problem again 10g [message #209939 is a reply to message #209913] Mon, 18 December 2006 10:12 Go to previous messageGo to next message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
oracle@server:/oracle/sys/v10/network/admin> set $TNS_ADMIN=/oracle/sys/v10/network/admin
oracle@server:/oracle/sys/v10/network/admin> export TNS_ADMIN
oracle@server:/oracle/sys/v10/network/admin> echo $TNS_ADMIN
/oracle/sys/v817/network/admin -- Again shows same 8i value
Re: Listener problem again 10g [message #209941 is a reply to message #209939] Mon, 18 December 2006 10:26 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

try

$unset TNS_ADMIN


regards
taj
Re: Listener problem again 10g [message #209943 is a reply to message #209913] Mon, 18 December 2006 10:28 Go to previous messageGo to next message
dba_blr
Messages: 43
Registered: December 2006
Member
There is a problem with the way you are setting the environment variables.

Just try this...

TNS_ADMIN=/oracle/sys/v10/network/admin
export TNS_ADMIN
echo $TNS_ADMIN
Re: Listener problem again 10g [message #209945 is a reply to message #209913] Mon, 18 December 2006 10:53 Go to previous messageGo to next message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
Thanks that worked.but again same issue when i reconnected.please see the details .

-- Like you said .
oracle@server:/oracle> TNS_ADMIN=/oracle/sys/v10/network/admin
oracle@server:/oracle> export TNS_ADMIN
oracle@server:/oracle> echo $TNS_ADMIN
/oracle/sys/v10/network/admin -PERFECT !!!

-- i reconnected to the server and checked.
oracle@server:/oracle> . oraenv
ORACLE_SID = [DB10g] ? DB10g
oracle@server:/oracle> echo $TNS_ADMIN
/oracle/sys/v817/network/admin -same issue again!!!

why i cant make this change permamanet ?
Re: Listener problem again 10g [message #209946 is a reply to message #209913] Mon, 18 December 2006 10:56 Go to previous messageGo to next message
dba_blr
Messages: 43
Registered: December 2006
Member
Why don't you edit the oraenv file itself?
Re: Listener problem again 10g [message #209947 is a reply to message #209913] Mon, 18 December 2006 11:09 Go to previous messageGo to next message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
I donot see an entry for $TNS_ADMIN in /usr/local/bin/oraenv .
it only set ORACLE_HOME and ORACLE_SID .

i wonder then how it is giving 8i TNS_ADMIN value ??is it configured in anyother file ?sorry ,i am new to unix env .
Re: Listener problem again 10g [message #209950 is a reply to message #209913] Mon, 18 December 2006 11:27 Go to previous messageGo to next message
dba_blr
Messages: 43
Registered: December 2006
Member
Would advice you to understand about the basics of UNIX first, otherwise it will be very difficult for you to work. It is also very difficult for anyone in this forum to tell you the basics.

Anyways I think the TNS_ADMIN environt variable has been set in your profile file of your shell.

Look into that...
Re: Listener problem again 10g [message #209952 is a reply to message #209913] Mon, 18 December 2006 11:39 Go to previous message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
ok profile file should be the villain here.
i will do some R&D.Thank you very much dude
Previous Topic: Table Size
Next Topic: applying patch 5117106 fails
Goto Forum:
  


Current Time: Sat Dec 03 01:05:41 CST 2016

Total time taken to generate the page: 0.15696 seconds