Sqlplus which instance

But before we get to this, let's follow the example on 11g then have a look at 19c at the end of the post. For example:. Using xargs -0 —n1 helps with formatting the output.

Here is an example:. While testing a similar scenario on Oracle 19c, we noticed that the message is now different. Then start the database instance and exit your connection. All rights reserved. So be aware there seem to be slight differences here in how this issue is being reported in earlier versions of Oracle compared to the later versions. Find out about our continuous database protection for yourself and see how you can keep your world in motion.

Find centralized, trusted content and collaborate around the technologies you use most. Connect and share knowledge within a single location that is structured and easy to search. When I run sqlplus it connect to orcl2 instance but I need to connect to orcl I can connect to my normal user using this:. Stack Overflow for Teams — Collaborate and share knowledge with a private group.

Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. How to connect to different oracle instance as sysdba using sqlplus? Ask Question. Asked 5 years, 3 months ago. Asked 2 years ago. Active 2 years ago. Viewed 1k times. Improve this question.

You could change that every time but it probably makes more sense to specify a TNS alias explicitly. Add a comment.

Active Oldest Votes. Improve this answer. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password.