NCR-00002: NCR: Invalid usage
Hi all,
Just installed Oracle 9.2.0.4 or RedHat Linux AS 2.1
When ORACLE_SID is set in environment I can connect without any problem to the database I created using:
# sqlplus user/password
It is when I am using:
#sqlplus user/password@bluetest
that things start to fall apart. I am getting ORA-03113: end-of-file on communication channel.
# tnsping bluetest works fine though.
In $ORACLE_HOME/rdbms/log/bluetest_agt_XXXX.trc I found the following that explains the problem I guess. If only I would understand what it is trying to tell me, I may be able to solve the problem and correct ok. Here is what I found:
Oracle Corporation --- THURSDAY DEC 02 2004 20:13:11.018
Heterogeneous Agent Release
9.2.0.4.0
HS Agent diagnosed error on initial communication,
probable cause is an error in network administration
Network error 2: NCR-00002: NCR: Invalid usage
There is one other post on this forum - actually only found 1 entry using google :-( but that is somebody having trouble setting up Transparent Gateway for Ms Sql Server. That post indicated that there could be something wrong with tnsnames.ora and listener.ora I am posting those for completeness' sake.
TNSNAMES.ORA:
# TNSNAMES.ORA Network Configuration File: /home/oracle/OraHome1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
EXTPROC_CONNECTION_DATA.LOCALDOMAIN =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
BLUETEST.LOCALDOMAIN =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SID = bluetest)
(SERVER = DEDICATED)
)
)
LISTENER.ORA:
# LISTENER.ORA Network Configuration File: /home/oracle/OraHome1/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /home/oracle/OraHome1)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = bluetest)
(ORACLE_HOME = /home/oracle/OraHome1)
(PROGRAM = extproc)
)
)
Thanks in advance (and sorry for this lenghtly post).
Rudi.
Just installed Oracle 9.2.0.4 or RedHat Linux AS 2.1
When ORACLE_SID is set in environment I can connect without any problem to the database I created using:
# sqlplus user/password
It is when I am using:
#sqlplus user/password@bluetest
that things start to fall apart. I am getting ORA-03113: end-of-file on communication channel.
# tnsping bluetest works fine though.
In $ORACLE_HOME/rdbms/log/bluetest_agt_XXXX.trc I found the following that explains the problem I guess. If only I would understand what it is trying to tell me, I may be able to solve the problem and correct ok. Here is what I found:
Oracle Corporation --- THURSDAY DEC 02 2004 20:13:11.018
Heterogeneous Agent Release
9.2.0.4.0
HS Agent diagnosed error on initial communication,
probable cause is an error in network administration
Network error 2: NCR-00002: NCR: Invalid usage
There is one other post on this forum - actually only found 1 entry using google :-( but that is somebody having trouble setting up Transparent Gateway for Ms Sql Server. That post indicated that there could be something wrong with tnsnames.ora and listener.ora I am posting those for completeness' sake.
TNSNAMES.ORA:
# TNSNAMES.ORA Network Configuration File: /home/oracle/OraHome1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
EXTPROC_CONNECTION_DATA.LOCALDOMAIN =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
BLUETEST.LOCALDOMAIN =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SID = bluetest)
(SERVER = DEDICATED)
)
)
LISTENER.ORA:
# LISTENER.ORA Network Configuration File: /home/oracle/OraHome1/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /home/oracle/OraHome1)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = bluetest)
(ORACLE_HOME = /home/oracle/OraHome1)
(PROGRAM = extproc)
)
)
Thanks in advance (and sorry for this lenghtly post).
Rudi.
