OraFAQ Forum: Client Tools » how to know which system db iam accessing

Home » Other » Client Tools » how to know which system db iam accessing

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

how to know which system db iam accessing [message #288883]

Wed, 19 December 2007 00:27

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

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

SQL> select sys_context('userenv','server_host') from dual;
SYS_CONTEXT('USERENV','SERVER_HOST')
------------------------------------------------------------
XXXXXXXXXX

1 row selected.

Regards
Michel

Report message to a moderator

Re: how to know which system db iam accessing [message #288907 is a reply to message #288904]

Wed, 19 December 2007 00:48

Frank
Messages: 7901
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

Report message to a moderator

Re: how to know which system db iam accessing [message #288912 is a reply to message #288907]

Wed, 19 December 2007 00:58

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

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. /forum/fa/917/0/

Regards
Michel

Report message to a moderator

Re: how to know which system db iam accessing [message #288976 is a reply to message #288912]

Wed, 19 December 2007 03:23

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

And your password is probably ******. Right?

Report message to a moderator

Re: how to know which system db iam accessing [message #288979 is a reply to message #288976]

Wed, 19 December 2007 03:29

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

How do you guess? I have to change it now!

Regards
Michel

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 03 07:57:23 CST 2025