OraFAQ Forum: Networking and Gateways » Connecting to database services

Home » RDBMS Server » Networking and Gateways » Connecting to database services (9.2.0.6 Windows)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Connecting to database services [message #291120]

Thu, 03 January 2008 01:32

gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen

Senior Member

i made two connections to the database using accountDEMO.world.com service .

SQL> conn scott/tiger@local_desk
Connected.
SQL> conn scott/tiger@local_desk
Connected.

Note:I use accountDEMO.world.com service in tnsnames.ora file.

Now i checked total connections to the database.

Service "accountDEMO.world.com" has 1 instance(s).
  Instance "DEMO", status READY, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:2 refused:0 state:ready
         LOCAL SERVER
Service "salesDEMO.world.com" has 1 instance(s).
  Instance "DEMO", status READY, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:2 refused:0 state:ready
         LOCAL SERVER
The command completed successfully

My question is why salesDEMO.world.com also shows two connections ??

Report message to a moderator

Re: Connecting to database services [message #293557 is a reply to message #291120]

Mon, 14 January 2008 01:52

vishym_68
Messages: 8
Registered: September 2007
Location: India

Junior Member

Hi,
For both the Services "accountDEMO.world.com" and "salesDEMO.world.com" the instance seems to be the same "DEMO", . Hence the salesDEMO.world.com also shows two connections .

Report message to a moderator

Previous Topic:	ORA-12154: TNS:could not resolve service name when trying to connect to a newly created database
Next Topic:	ORA-12154 while importing from sql server

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 17:32:47 CDT 2024