Re: SQL*Net move from 7.0.12 to 7.1.6

littlegj_at_aol.com (Littlegj) wrote:
>We are running Oracle 7.0.12 with SQL*net on UnixWare 1.1.2. We were
>successfully connected to an HP UX running Oracle 7.0.12. They upgraded
>the Oracel on the HP to 7.1.6 and now we cannot connect to the HP using V1
>of SQL*Net. V2 of SQL*Net works ok. We have several applications that
>cannot use V2.
>
>Anyone have any ideas what to check on the HP to verify V1 SQL*Net is
>running and how to verify the connection can be established OK?
>
>Greg Little
>gxl!attmail!ncsc5.att.com

A simple test is a loopback on the HP. In other words, run a tool like sqlplus specifying a SQL*NET V1 connect string pointing back to the HP.

e.g. sqlplus scott/tiger_at_T:<hp nodename>:<oracle SID>

Also, run the command "tcpctl stat" on the HP to see the status of the TCP/IP listener (orasrv).

-- 
Ted Alexander (tealexan_at_ca.oracle.com)
Oracle Canada Technical Support