Re: tns error: 03505 - trying to get hsodbc to work

Originally posted by Pheonix1t
> hello,
>
> # SQLNET.ORA Network Configuration File:
> F:\oracle\ora92\network\admin\sqlnet.ora
> # Generated by Oracle configuration tools.
>
> NAMES.DEFAULT_DOMAIN = epione.local
>
> SQLNET.AUTHENTICATION_SERVICES= (NTS)
>
> NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
>
> +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++-
> ++++++++
>
>
> # LISTENER.ORA Network Configuration File:
> F:\oracle\ora92\network\admin\listener.ora
> # Generated by Oracle configuration tools.
>
> LISTENER =
> (DESCRIPTION_LIST =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
> )
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = Cleveland)(PORT = 1521))
> )
> )
> )
>
> SID_LIST_LISTENER =
> (SID_LIST =
> (SID_DESC =
> (SID_NAME = PLSExtProc)
> (ORACLE_HOME = F:\oracle\ora92)
> (PROGRAM = extproc)
> )
> (SID_DESC =
> (GLOBAL_DBNAME = epione.net)
> (ORACLE_HOME = F:\oracle\ora92)
> (SID_NAME = epione)
> )
> (SID_DESC =
> (SID_NAME = CORE_OFFICE1)
> (ORACLE_HOME = F:\oracle\ora92)
> (PROGRAM = core_office1)
>
> )
> )
>
> +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++-
> ++++++++++++++++++++++++++
> # TNSNAMES.ORA Network Configuration File:
> F:\oracle\ora92\network\admin\tnsnames.ora
> # Generated by Oracle configuration tools.
>
> <SNIP>
>
> EPIONE.EPIONE.LOCAL =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = Cleveland)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVER = DEDICATED)
> (SERVICE_NAME = epione.net)
> )
> )
>
> <SNIP>
>
> CORE_OFFICE1= (DESCRIPTION=
> (ADDRESS=(PROTOCOL=tcp)
> (HOST=cleveland)
> (PORT=1521)
> )
> (CONNECT_DATA=(SID=CORE_OFFICE1)
> )
> (HS = OK)
> )
> )
>
> Thanks!
>
> Oskar

Is Core_office1 a database or an external procedure? I believe this is what Sybrand was asking. If it's a database, look at the listener.ora config file and compare the set-up of EPIONE.EPIONE.LOCAL and make the CORE_OFFICE1 entry mimic it. (ie, remove the program= entry and add a global_dbname entry for CORE_OFFICE1)

Also, look at your tnsnames.ora and sqlnet.ora file. In sqlnet.ora, you specify a default domain of EPIONE.LOCAL . In tnsnames.ora, you have CORE_OFFICE1 = . This should be CORE_OFFICE1.EPIONE.LOCAL =.

Try these changes and see what happens.

HTH,
Patrick

--
Posted via http://dbforums.com