Home » RDBMS Server » Networking and Gateways » LISTENER CONFIGURATION FOR TWO DATABASE (ORACLE 10G , LINUX)
LISTENER CONFIGURATION FOR TWO DATABASE [message #415788] Wed, 29 July 2009 05:41 Go to next message
riyas22
Messages: 4
Registered: July 2009
Junior Member
Hi

we have linux serevr with oracle 10 g installed.

we are using two database one for salary data i.e. KAS and one for FINANE $ ACCOUNTS i.e. FAS .

There are 2 OS users one is kas and other one is fas. if we log on to kas o/s(operating system) user account then we can start,access,stop the KAS database but not the FAS( using SQLPLUS KAS/password).

if we logon to fas o/s user account then we can start,access,stop the FAS database but not the KAS (using SQLPLUS FAS/password.)

Now if i start listener from kas o/s user account using command lsnrctl start . listener starts and if we check the status of the listener it is as follows:


LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 29-JUL-2009 07:52:18

Copyright (c) 1991, 2005, Oracle. All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date 28-JUL-2009 13:20:15
Uptime 0 days 18 hr. 32 min. 3 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /home/oracle10g/oracle/product/10.2.0/db_1/network/adm
in/listener.ora
Listener Log File /home/oracle10g/oracle/product/10.2.0/db_1/network/log
/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.9.400.84)(PORT=1521)))
Services Summary...
Service "fas.kel.com" has 1 instance(s).
Instance "fas", status READY, has 1 handler(s) for this service...
Service "fasXDB.kel.com" has 1 instance(s).
Instance "fas", status READY, has 1 handler(s) for this service...
Service "fas_XPT.kel.com" has 1 instance(s).
Instance "fas", status READY, has 1 handler(s) for this service...
Service "kas.kel.com" has 1 instance(s).
Instance "kas", status READY, has 1 handler(s) for this service...
Service "kasXDB.kel.com" has 1 instance(s).
Instance "kas", status READY, has 1 handler(s) for this service...
Service "kas_XPT.kel.com" has 1 instance(s).
Instance "kas", status READY, has 1 handler(s) for this service...
The command completed successfully


From client PC (Win XP) i can connect to kas database. But I cannot connect to fas database using this listener although fas service is ready.

Also if I start or stop the listener from 'fas' o/s login then i cannot do so.

I want to connect to both the database from remote client machine using one lsitener. But if we start from one account other cannot be accessed.

As i dont have prior knowledge of ORACLE 10 g i need help. I googled in the net and solved most of the problem ,but connecting to two database i didnt get any help.
Please give your valuable help
Thank you
-SRA
Re: LISTENER CONFIGURATION FOR TWO DATABASE [message #415906 is a reply to message #415788] Wed, 29 July 2009 14:14 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member


>>From client PC (Win XP) i can connect to kas database. But I cannot connect to fas database using this listener although fas service is ready.

Small problem but big story; From your client machine can you try to ping FAS using "TNSPING"

>>but connecting to two database i didnt get any help

We'll help you on this as per OraFaq rules Smile
Re: LISTENER CONFIGURATION FOR TWO DATABASE [message #415913 is a reply to message #415788] Wed, 29 July 2009 14:39 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
CUT the lines below & PASTE into a command window

cat /home/oracle10g/oracle/product/10.2.0/db_1/network/admin/listener.ora

ls -la $ORACLE_HOME
ps -ef | grep tns

CUT commands & results from command window and PASTE back here using <code tags> as explained in URL below.

http://www.orafaq.com/forum/t/88153/0/
Re: LISTENER CONFIGURATION FOR TWO DATABASE [message #415960 is a reply to message #415906] Wed, 29 July 2009 23:33 Go to previous messageGo to next message
riyas22
Messages: 4
Registered: July 2009
Junior Member
Hello Mr. Babu

Now can you please tell me how to use tnsping in command prompt.
I gave like thisin my client machine(i.e. windows XP)

F:\>tnsping 192.9.200.3

TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 30-JUL-2009 09:50:56

Copyright (c) 1997, 2005, Oracle. All rights reserved.

Used parameter files:
F:\oracle\product\10.2.0\client_1\network\admin\sqlnet.ora

Used EZCONNECT adapter to resolve the alias
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=192.9.400.84))(ADDRESS=(PROTOCOL=TCP)(HOST=192.9.400.84)(PORT=1521)))
OK (50 msec)
F:\

Is it OK?

I am able to connect to FAS database if listener is started from 'fas' operatng system user account(linux) but if i start listener from 'kas' operating system login account i am not able to connect to fas database and vice versa.

It is very confusing as both login name and database names and database user names are same.

Expecting some more info from you.

thanks,
-SRA


Re: LISTENER CONFIGURATION FOR TWO DATABASE [message #415961 is a reply to message #415913] Wed, 29 July 2009 23:45 Go to previous messageGo to next message
riyas22
Messages: 4
Registered: July 2009
Junior Member
Hello

I have gone through the guide lines . thank you. I have executed the commands and results are as follows:

1.fas@manager ~]$ ls -la $ORACLE_HOME
total 272
drwxrwxr-x 56 oracle10g dba 4096 Mar 6 2007 .
drwxrwxr-x 3 oracle10g dba 4096 Mar 6 2007 ..
drwxrwxr-x 5 kas dba 4096 Nov 23 2006 admin
drwxrwxr-x 7 oracle10g dba 4096 Nov 14 2006 assistants
drwxrwxr-x 2 oracle10g dba 12288 Nov 25 2006 bin
drwxrwxr-x 3 oracle10g dba 4096 Nov 14 2006 cdata
drwxrwxr-x 6 oracle10g dba 4096 Nov 14 2006 cfgtoollogs
drwxrwxr-x 4 oracle10g dba 4096 Nov 14 2006 clone
drwxrwxr-x 2 oracle10g dba 4096 Nov 14 2006 config
drwxrwxr-x 6 oracle10g dba 4096 Nov 14 2006 crs
drwxrwxr-x 7 oracle10g dba 4096 Nov 14 2006 css
drwxrwxr-x 10 oracle10g dba 4096 Nov 14 2006 ctx
drwxrwxr-x 2 oracle10g dba 4096 Jul 30 06:56 dbs
drwxrwxr-x 3 oracle10g dba 4096 Nov 14 2006 demo
drwxrwxr-x 3 oracle10g dba 4096 Nov 14 2006 diagnostics
drwxrwxr-x 3 oracle10g dba 4096 Nov 14 2006 has
drwxrwxr-x 6 oracle10g dba 4096 Nov 14 2006 hs
drwxrwxr-x 5 oracle10g dba 4096 Nov 14 2006 install
-rwxrwxr-x 1 oracle10g dba 37 Nov 14 2006 install.platform
drwxrwxr-x 12 oracle10g dba 4096 Nov 14 2006 inventory
drwxrwxr-x 7 oracle10g dba 4096 Nov 14 2006 javavm
drwxrwxr-x 4 oracle10g dba 4096 Nov 14 2006 jdbc
drwxrwxr-x 7 oracle10g dba 4096 Nov 14 2006 jdk
drwxrwxr-x 2 oracle10g dba 4096 Nov 14 2006 jlib
drwxrwxr-x 3 oracle10g dba 4096 Nov 14 2006 jre
drwxrwxr-x 13 oracle10g dba 4096 Nov 14 2006 ldap
drwxrwxr-x 3 oracle10g dba 12288 Nov 14 2006 lib
drwxr-x--T 4 kas dba 4096 Nov 25 2006 log
drwxrwxr-x 6 oracle10g dba 4096 Nov 14 2006 md
drwxrwxr-x 2 oracle10g dba 4096 Nov 14 2006 mesg
drwxrwxr-x 7 oracle10g dba 4096 Nov 14 2006 mgw
drwxrwxr-x 11 oracle10g dba 4096 Nov 14 2006 network
drwxrwxr-x 6 oracle10g dba 4096 Nov 14 2006 nls
drwxrwxr-x 15 oracle10g dba 4096 Nov 14 2006 oc4j
drwxrwxr-x 6 oracle10g dba 4096 Nov 14 2006 odbc
drwxrwxr-x 5 oracle10g dba 4096 Nov 14 2006 olap
drwxrwxr-x 4 oracle10g dba 4096 Nov 14 2006 OPatch
drwxrwxr-x 7 oracle10g dba 4096 Nov 14 2006 opmn
drwxrwxr-x 4 oracle10g dba 4096 Nov 14 2006 oracore
drwxr-x--- 2 kas dba 4096 Nov 14 2006 oradata
-rwxrwxr-x 1 oracle10g dba 58 Nov 14 2006 oraInst.loc
drwxrwxr-x 8 oracle10g dba 4096 Nov 14 2006 ord
drwxrwxr-x 7 oracle10g dba 4096 Nov 14 2006 oui
drwxrwxr-x 4 oracle10g dba 4096 Nov 14 2006 owm
drwxrwxr-x 6 oracle10g dba 4096 Nov 14 2006 perl
drwxrwxr-x 7 oracle10g dba 4096 Nov 14 2006 plsql
drwxrwxr-x 7 oracle10g dba 4096 Nov 14 2006 precomp
drwxrwxr-x 7 oracle10g dba 4096 Nov 14 2006 racg
drwxrwxr-x 13 oracle10g dba 4096 Nov 14 2006 rdbms
drwxrwxr-x 4 oracle10g dba 4096 Nov 14 2006 relnotes
-rwxrwxr-x 1 oracle10g dba 9539 Nov 14 2006 root.sh
-rwxrwxr-x 1 oracle10g dba 0 Jun 7 2005 root.sh.old
-rw-r--r-- 1 fas dba 739 Nov 14 2006 shutdown.log
drwxrwxr-x 3 oracle10g dba 4096 Nov 14 2006 slax
drwxrwxr-x 3 oracle10g dba 4096 Nov 14 2006 sqlj
drwxrwxr-x 9 oracle10g dba 4096 Nov 14 2006 sqlplus
drwxrwxr-x 12 oracle10g dba 4096 Nov 14 2006 srvm
-rw-r--r-- 1 fas dba 4928 Nov 14 2006 startup.log
drwxrwxr-x 12 oracle10g dba 4096 Nov 14 2006 sysman
drwxrwxr-x 4 oracle10g dba 4096 Nov 14 2006 uix
drwxrwxr-x 3 oracle10g dba 4096 Nov 14 2006 wwg
drwxrwxr-x 6 oracle10g dba 4096 Nov 14 2006 xdk


2.[fas@manager ~]$ ps -ef|grep tns ('If i execute this from fas o/s login')

fas 19210 1 0 Jul28 ? 00:00:00 /home/oracle10g/oracle/product/10.2.0/db_1/bin/tnslsnr LISTENER_FAS -inherit
kas 26790 1 0 Jul29 ? 00:00:00 /home/oracle10g/oracle/product/10.2.0/db_1/bin/tnslsnr LISTENER -inherit
fas 29845 29293 0 07:29 pts/2 00:00:00 grep tns


3.[kas@manager ~]$ ps -ef|grep tns ('If i execute this from kas o/s login')

fas 19210 1 0 Jul28 ? 00:00:00 /home/oracle10g/oracle/product/10.2.0/db_1/bin/tnslsnr LISTENER_FAS -inherit
kas 26790 1 0 Jul29 ? 00:00:00 /home/oracle10g/oracle/product/10.2.0/db_1/bin/tnslsnr LISTENER -inherit
kas 29855 29165 0 07:30 pts/1 00:00:00 grep tns


3.[fas@manager ~]$ cat /home/oracle10g/oracle/product/10.2.0/db_1/network/admin/l
istener.ora
# listener.ora Network Configuration File: /home/oracle10g/oracle/product/10.2.0
/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER_KAS =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.9.400.84)(PORT = 1521))
)
[fas@manager ~]$


Hope I have replied evrything. I will be greatfull if you assist me in solving this.

thanks
-SRA
Re: LISTENER CONFIGURATION FOR TWO DATABASE [message #416081 is a reply to message #415961] Thu, 30 July 2009 07:05 Go to previous message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member


>>operating system login account i am not able to connect to fas database and vice versa.

What error message your getting while connecting?
Previous Topic: Interchainging the TNS NAMES
Next Topic: tnsping.exe using 90% of my CPU time . HOW TO SOLVE IT?
Goto Forum:
  


Current Time: Thu Mar 28 04:11:07 CDT 2024