Kbase P126349: Oracle Error 1012 when trying to connect to remote Oracle without SQL*NET service name
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2007 |
|
Status: Unverified
FACT(s) (Environment):
Oracle DataServer
SYMPTOM(s):
Oracle Error 1012 when trying to connect Oracle
ORA: -1012 not logged on
The above error is apparent when connecting to Oracle through the Schema Holder
Environment variable ORACLE_HOME is set correctly
The $ORACLE_HOME/bin is appended to the PATH as well
Can connect to Oracle using SQLPLUS session with the SQL*NET Service name in the connection parameter from the DataServer machine
CAUSE:
The SQL*NET service name is missing from the connection parameter parameter
FIX:
Add the SQL*NET service name with the user-id supplied in the connection as
-U <user-id>@<SQL*NET service name> -P <password>
You can also use the following format:
-U <user-id>/<password>@<SQL*NET service name> (you do not require a separate -P for the password in this format)