Change from one instance to another.

[jayjaybigs]

Hello,

I have several unix servers which contain several database Instances.

I was wondering if there is an easier way to change from one server to the other as suppose to loging out of one instance and loging back in to another on my secure shell(SSH).

Thanks

 

[SantaMufasa]

JayJay, I'm not quite sure what you want to do...Why not just open up a separate window for your other/multiple sessions?

Mufasa
(aka Dave of Sandy, Utah, USA)
[

http://www.dasages.com:

Providing low-cost remote Database Admin services]
Click here to join Utah Oracle Users Group on Tek-Tips if you use Oracle in Utah USA.

 

[jayjaybigs]

Thanks for replying.

Opening up different sessions is what I am currently doing and wanted to stop doing. I cal also use SSH command and that will take me to another node/server.

However, I was thinking maybe there is a little nifty application out there that will allow me to transfer from one server to another.

Again thanks, I will continue to use different sessions.

 

[SantaMufasa]

JayJay,

From one SQL*Plus window, you can say at the "SQL> " prompt:

SQL> connect <username>/<password>@<TNS alias>

...but doing so, by definition, disconnects you from the original session. Does that meet your needs? If not, then the additional window is the only SQL*Plus method that I know of.

Mufasa
(aka Dave of Sandy, Utah, USA)
[

http://www.dasages.com:

Providing low-cost remote Database Admin services]
Click here to join Utah Oracle Users Group on Tek-Tips if you use Oracle in Utah USA.