| Listener problem again 10g [message #209913] |
Mon, 18 December 2006 07:39  |
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 #209925 is a reply to message #209913] |
Mon, 18 December 2006 09:33  |
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 #209932 is a reply to message #209913] |
Mon, 18 December 2006 09:51 |
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 |
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 |
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 #209945 is a reply to message #209913] |
Mon, 18 December 2006 10:53 |
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 #209947 is a reply to message #209913] |
Mon, 18 December 2006 11:09 |
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 |
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...
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
