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