Home » SQL & PL/SQL » Client Tools » how to know which system db iam accessing
how to know which system db iam accessing [message #288883] Wed, 19 December 2007 00:27 Go to next message
mrkcse
Messages: 62
Registered: November 2007
Location: Mumbai,India
Member
Iam accessing one application from central server (oracle 10g) ,sometimes iam accessing from my local system by changing address configuration of service name of the database.

But i want to know command for which system iam connecting in sqlplus .

[Updated on: Wed, 19 December 2007 00:28]

Report message to a moderator

Re: how to know which system db iam accessing [message #288904 is a reply to message #288883] Wed, 19 December 2007 00:46 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
SQL> select sys_context('userenv','server_host') from dual;
SYS_CONTEXT('USERENV','SERVER_HOST')
------------------------------------------------------------
XXXXXXXXXX

1 row selected.

Regards
Michel
Re: how to know which system db iam accessing [message #288907 is a reply to message #288904] Wed, 19 December 2007 00:48 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Strange servernames you use, Michel!
Must be hard to get the exact amount of X-es right every time...
Wink
Re: how to know which system db iam accessing [message #288912 is a reply to message #288907] Wed, 19 December 2007 00:58 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
For security purpose the number of X is randomly choosen each day so it takes me 10 minutes each morning to connect. ./fa/917/0/

Regards
Michel
Re: how to know which system db iam accessing [message #288976 is a reply to message #288912] Wed, 19 December 2007 03:23 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
And your password is probably ******. Right?
Re: how to know which system db iam accessing [message #288979 is a reply to message #288976] Wed, 19 December 2007 03:29 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
How do you guess? I have to change it now!

Regards
Michel
Previous Topic: Toad Current Schema Drop down toolbar
Next Topic: SQL*PLUS, TOAD and Command Prompt
Goto Forum:
  


Current Time: Sun Dec 11 00:18:21 CST 2016

Total time taken to generate the page: 0.15862 seconds