Re: Problem upgrading to Oracle 7.2.3 on HP

Which SQLNEt version are you using ? ..

tcpctl is SQLNet Ver 1 ..

While TNSNAMES.ORA and SQLNET.ORA are SQLNET version 2 files .. Maybe you installed the wrong driver ....

I hope this helps .

Mark A. Bryan wrote:
>
> If anyone can give me a solution for this problem, I would greatly
> appreciate it!
>
> The client I work for has a working database running under version 7.2.2 on
> HP-UX 9.0. They want to go to HP-UX 10.20, but cannot until Oracle is
> upgraded to 7.2.3. I have installed version 7.2.3 (successfully, I think).
> I am able to use SQL*Plus and SQL*DBA to connect to the database using
> either version 7.2.2 or 7.2.3. However, at 7.2.3, none of my PC clients
> can connect to the database via SQL*Net. I noticed there was no
> "tnsnames.ora" file in $ORACLE_HOME/network/admin, so I copied the one from
> 7.2.2 and restarted "tnslsnr". Nothing. Next, I saw that "tcpctl" and
> "tcputl" were also missing from $ORACLE_HOME/network/admin, so I tried to
> reinstall TCP. They still didn't show up, so I copied them from 7.2.2,
> also. When I ran "tcpctl start", it said it could not find "orasrv". So,
> as "root", I copied "orasrv" from 7.2.2's "bin" directory. Now "tcpctl
> start" started up just fine. Still, no PC clients can connect to the
> database.
>
> First, I am concerned that I had to copy so many files from a previous
> version of Oracle, and that they did not get created by the install. Is it
> possible that I missed something in the install?
>
> Second, why can't my PC clients connect to the 7.2.3 database? I can
> "tnsping" the 7.2.3 instance from other HP machines, but DB Links don't
> work from databases on those machines. (Actually, "tnsping" was acting
> kind of flaky; first it found the 7.2.3 instance, then it didn't).
>
> Again, any help would be appreciated. I can make a few more educated
> guesses, but nothing that feels like it will work.
>
> Thanx,
>
> Mark A. Bryan
> DBA Master
> (but not Installation Master)

-- 
================================================================
============================
| Joseph Sumalbag                                                                           
|
| Oracle DBA                                                                                
|
|                                                                                           
|
| The opinions expressed above are my own and doesn't 
 necessarily                           |
|reflect the opinion of any of my client company or my employer.                            
|
================================================================
============================