Re: Developer6i connecting problem on RedHat6.2

I see you are using the $ORACLE_HOME/network/admin directory (default). Ensure that TNS_ADMIN is not defined (unless you want to use another directory to host the tnsnames.ora and sqlnet.ora files. FTP (not copy) the files (tnsnames.ora and sqlnet.ora) from the database server machine to the RH machine $ORACLE_HOME/network/admin directory. Check if you can tnsping your db server from your RH machine (related account).

hope this proves useful
Zafer AKTAN
Oracle DBA/Developer

On Thu, 27 Feb 2003 06:18:31 -0800, RC wrote:

> Hello,
>
> I have a problem with connecting on Oracle 8.1.6 (which is on
> Win2000(bserver), SID=ora8i) from remote host which is RedHat 6.2 with
> Developer 6i. In one moment I have managed connect when I changed
>
> SQLNet.authentication_services from (NTS) to (none) on server.
>
> But, later I have changed something and it doesn't work anymore.
>
> My tnsnames.ora, sqlnet.ora and listener.ora are here:
>
> # TNSNAMES.ORA Configuration
> File:/home/oracle/dev6i/network/admin/tnsnames.ora # Generated by Oracle
> Net8 Assistant
>
> ORA8I =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = TCP)(HOST = bserver)(PORT = 1521))
> (CONNECT_DATA = (SID = ora8i))
> )
>
> ---------
>
> # SQLNET.ORA Configuration
> File:/home/oracle/dev6i/network/admin/sqlnet.ora # Generated by Oracle
> Net8 Assistant
>
> SQLNET.EXPIRE_TIME = 0
>
> SQLNET.ENCRYPTION_SERVER = requested
>
> SQLNET.ENCRYPTION_CLIENT = requested
>
> NAMES.DIRECTORY_PATH= (TNSNAMES)
>
> SQLNET.AUTHENTICATION_SERVICES= (none)
>
> ----------
>
> # LISTENER.ORA Configuration
> File:/home/oracle/dev6i/network/admin/listener.ora # Generated by Oracle
> Net8 Assistant
>
>
> Does anyone can help me?
>
> Thanks.
>
> Sasa.
Received on Thu Feb 27 2003 - 18:33:45 CET