I wonder if there is any best practice for this. 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? Extra information that would be useful would include user, session id etc.
HutchingsPendergrass Funeral Chapel Marble Hill MO
We should see the instance registered with the listener: How can you show the sql that is currently executing on an oracle db? Some of these batch reports will try to access a database table.
You can connect as sysdba on the database server itself.
The default password for the hr, sys and system accounts is oracle. Your sqlplus line looks correct, verify the following: 48 we've been using bi software and a repository database that are installed on oracle enterprise 11gr2. You can connect as the user you are trying to on the database.
I have read here and there that the size of sga + pga can be 80% of the ram. It preserves the index and. I'm running 12.1.0 on windows server 2008 Doublecheck that local_listener parameter is the one used.
0 i have a server that has 128gb ram.
Oracle net configuration looks ok: The unix password for the oracle user is also oracle. What is the difference (if any) between a database, a user, and a schema?
