Skip to Main Content

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Subba Rao.

Asked: December 10, 2016 - 6:09 am UTC

Last updated: December 13, 2016 - 1:35 am UTC

Version: 12C

Viewed 1000+ times

You Asked

Dear Sir

How to login / access a particular DB instances through connect /as sysdba when the server has multiple database instances (SIDs) like APP_QA, APP_DEV, APP_UAT.


Thanks & Regards



and Connor said...

If you are *on* the server, it is just:

Unix
----
ORACLE_SID=xxx
export ORACLE_SID

Windows
-------
set ORACLE_SID=...

or more completely, check out the "oraenv" scripts, which set all the relevant variables assuming your 'oratab' file is correctly setup.

If you are remote to the database server, you can still connect as sysdba as long as you have a password file setup on the server.

sqlplus sys/password@remote_db as sysdba


Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Resolved

Subba Rao a, December 12, 2016 - 4:36 am UTC

Dear Sir,

Thank you very much for your reply and my issue got resolved

Thanking You

Regards
Subba Rao
Connor McDonald
December 13, 2016 - 1:35 am UTC

glad we could help
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.