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.
Misslexa Age, Net worth, Bio, Career, and Family
Are you actually setting values for the sga components and/ or the pga separately?
I tried in net and found out the default password is change_on_install but it is not workin.
I'm trying to find my listener.ora file to edit it, but the docs say it's in the oracle_home directory, but where is that? 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.
I'm running 12.1.0 on windows server 2008 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? What version of oracle are you using?
