Home » RDBMS Server » Networking and Gateways » Connecting to database services (9.2.0.6 Windows)
Connecting to database services [message #291120] Thu, 03 January 2008 01:32 Go to next message
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 ??
Re: Connecting to database services [message #293557 is a reply to message #291120] Mon, 14 January 2008 01:52 Go to previous message
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 .
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:
  


Current Time: Mon Dec 05 05:01:43 CST 2016

Total time taken to generate the page: 0.05036 seconds