asked on ArcSDE with Oracle
We are facing some problem while installing Arc SDE 9.1 Oracle 64bit edition (OS: Windows 2003 server 64bit enterprise edition)
Arc SDE for oracle 10g is installed and created the table space and schema in the oracle when oracle client 32 bit was installed in the server having windows 2003 server 64 bit and oracle 64 bit.
But when I start the service, it is giving the following error:
Unable to start iomgr.
The log file shows the following error:
--------------------------
ArcSDE 9.1 Oracle10g Build 392 Thu Nov 2 15:42:12 PST 2006
--------------------------
DB_open_instance()::db_con
init_DB DB_instance_open_as_dba: -51
DBMS error code: 12560
ORA-12560: TNS: Fehler bei Protokolladapter
All the tns names are given correct and we can connect to the oracle database through both the 32 bit oracle client and 64 bit client in the same system.
Arc SDE for oracle 10g is installed and created the table space and schema in the oracle when oracle client 32 bit was installed in the server having windows 2003 server 64 bit and oracle 64 bit.
But when I start the service, it is giving the following error:
Unable to start iomgr.
The log file shows the following error:
--------------------------
ArcSDE 9.1 Oracle10g Build 392 Thu Nov 2 15:42:12 PST 2006
--------------------------
DB_open_instance()::db_con
init_DB DB_instance_open_as_dba: -51
DBMS error code: 12560
ORA-12560: TNS: Fehler bei Protokolladapter
All the tns names are given correct and we can connect to the oracle database through both the 32 bit oracle client and 64 bit client in the same system.
Oracle Database
Last Comment
MMDGmbH
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Is the ArcSDE on the same box as the oracle server? Can you connect using sqlplus to the same SID as what ArcSDE is trying to connect?
Also check if your ORACLE_SID env variable is set correctly.
If connecting to a remote oracle database, then check if your tnsnames entry is correct - you can use
tnsping <sid>
in a cmd to check.
Or else what I do is to generate the tns entry using a tool like Oracle sqldeveloper and just stick the (long) tns url entry where ever I specify the connection parameters.