Your sqlplus line looks correct, verify the following: What is the difference (if any) between a database, a user, and a schema? Something along the same lines as this, which lists the current user's tables:
I am connecting to oracle db with: You can connect as the user you are trying to on the database server itself. You can connect as sysdba on the database server itself.
I'm running 12.1.0 on windows server 2008 Sqlplus / as sysdba what is the default password for the sysdba user? Note also there is a terminology mismatch between mysql and oracle database. Extra information that would be useful would include user, session id etc.
I want to connect to an oracle database located on another host using sqlplus. This page suggested adding an item on my tnsnames to connect to that database local_sid = (description. I tried in net and found out the default password is change_on_install but it is not workin. Q&a for database professionals who wish to improve their database skills and learn from others in the community
The title says it all, is there a way to quickly list all the current database links in oracle?