Oracle 10G, ora-12170 and ORA-12535

[labadie_1]

Hello

I have installed Oracle on an Itanium running VMS 8.3-1H1, created a test database, started Oracle.

Since I rebooted, I am unable to start Oracle again.

I have checked all my .ora files, they are in stream_lf format.

I have put trace in sqlnet.ora, the file sqlnet.log shows


***********************************************************************
Fatal NI connect error 12170.

VERSION INFORMATION:
TNS for VMS: Version 10.2.0.2.0 - Production
Time: 03-MAR-2010 12:22:39
Tracing to file: [oratest]cli_20806de8.trc
Tns error struct:
ns main err code: 12535
TNS-12535: TNS:operation timed out
ns secondary err code: 12560
nt main err code: 505
TNS-00505: Operation timed out
nt secondary err code: 324
nt OS err code: 0
Client address:

and the end of the trace file contains

[03-MAR-2010 12:22:39:306] nsmfr: entry
[03-MAR-2010 12:22:39:306] nsmfr: 748 bytes at 0x334b860
[03-MAR-2010 12:22:39:307] nsmfr: normal exit
[03-MAR-2010 12:22:39:308] nsopen: error exit
[03-MAR-2010 12:22:39:308] nsclose: entry
[03-MAR-2010 12:22:39:309] nsclose: normal exit
[03-MAR-2010 12:22:39:309] nladget: entry
[03-MAR-2010 12:22:39:310] nladget: exit
[03-MAR-2010 12:22:39:310] nsmfr: entry
[03-MAR-2010 12:22:39:311] nsmfr: 212 bytes at 0x3332290
[03-MAR-2010 12:22:39:312] nsmfr: normal exit
[03-MAR-2010 12:22:39:312] nladtrm: entry
[03-MAR-2010 12:22:39:313] nladtrm: exit
[03-MAR-2010 12:22:39:313] nscall: error exit
[03-MAR-2010 12:22:39:314] nioqper: error from nscall
[03-MAR-2010 12:22:39:315] nioqper: ns main err code: 12535
[03-MAR-2010 12:22:39:315] nioqper: ns (2) err code: 12560
[03-MAR-2010 12:22:39:316] nioqper: nt main err code: 505
[03-MAR-2010 12:22:39:316] nioqper: nt (2) err code: 324
[03-MAR-2010 12:22:39:317] nioqper: nt OS err code: 0
[03-MAR-2010 12:22:39:317] niomapnserror: entry
[03-MAR-2010 12:22:39:318] niqme: entry
[03-MAR-2010 12:22:39:318] niqme: reporting NS-12535 error as ORA-12535
[03-MAR-2010 12:22:39:319] niqme: exit
[03-MAR-2010 12:22:39:320] niomapnserror: exit
[03-MAR-2010 12:22:39:320] niotns: Couldn't connect, returning 12170
[03-MAR-2010 12:22:39:321] nioqer: entry
[03-MAR-2010 12:22:39:321] nioqer: incoming err = 12170
[03-MAR-2010 12:22:39:340] nioqce: entry
[03-MAR-2010 12:22:39:341] nioqce: exit
[03-MAR-2010 12:22:39:341] nioqer: returning err = 3113
[03-MAR-2010 12:22:39:342] nioqer: exit
[03-MAR-2010 12:22:39:343] niotns: exit
[03-MAR-2010 12:22:39:343] nigcui: entry
[03-MAR-2010 12:22:39:344] nigcui: Clr User Interrupt: hdl=1, prc=0x3109278, ctx=0x330dcc0.
[03-MAR-2010 12:22:39:344] nigcui: exit (0)
[03-MAR-2010 12:22:39:345] nsbfrfl: entry
[03-MAR-2010 12:22:39:346] nsbrfr: entry
[03-MAR-2010 12:22:39:346] nsbrfr: nsbfs at 0x33258e0, data at 0x334bc50.
[03-MAR-2010 12:22:39:347] nsbrfr: normal exit
[03-MAR-2010 12:22:39:347] nsbfrfl: normal exit
[03-MAR-2010 12:22:39:348] nigtrm: Count in the NI global area is now 1
[03-MAR-2010 12:22:39:349] nigtrm: Count in the NL global area is now 3
$


sqlplus
user
password

gives immediately

$ sqlplus

SQL*Plus: Release 10.2.0.2.0 - Production on Wed Mar 3 12:31:39 2010

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

Enter user-name: sys
Enter password:
ERROR:
ORA-12170: TNS:Connect timeout occurred


Enter user-name:

Thanks for any hint

[Fekko Stubbe]

[03-MAR-2010 12:22:39:316] nioqper: nt (2) err code: 324

Could it mean vms error 324
exit 324: system-f-invdevnam,invalid device name

Maybe a logical disappeared after the boot??

Fekko

[Hein van den Heuvel]

Is there a BEQ Listener runnings?

Did you run @Oracle_home:INSORACLE or run @ORAUSER which wil invoke ORAINSTAL if you have the privs and ORA_AUTO_ORAINSTALL is defined as yes/

Is the Bequet Listener going?

Cheers,
Hein

[labadie_1]

Hein

>>>Is there a BEQ Listener runnings?
yes


>>>Did you run @Oracle_home:INSORACLE or run @ORAUSER

Yes

I am amazed it is so difficult to find information about this problem. I have found metalink notes with

nioqper: ns main err code: 12535
[03-MAR-2010 12:22:39:315] nioqper: ns (2) err code: 12560
[03-MAR-2010 12:22:39:316] nioqper: nt main err code: 505
[03-MAR-2010 12:22:39:316] nioqper: nt (2)

but not with my

err code: 324
[03-MAR-2010 12:22:39:317] nioqper: nt OS err code: 0

And no firewall blocking port 1521.

The user was clearly not tested, as entering a valid user/password couple, or a clearly invalid, let to the same result, immediate answer

ORA-12170: TNS:Connect timeout occurred

So I think it is not a timeout problem.
I have found notes with a logical name for timeout problems, but it is not relevant.

I relaunched OUI, created another test database, and it worked fine.

[Hein van den Heuvel]

>> I relaunched OUI, created another test database, and it worked fine


Ah that may have been the problem.
You are supposed to install twice.
There is always something that goes wrong. :-)

More seriously... have you rebooted since that last succesful install?

Of course you and I know that it is not the reboot, but an environmental thing like the right ORA table in LNM$FILE_DEV. THat's where the (right) BEQL comes in.

Enjoy,
Hein.

[labadie_1]

Yes, I have rebooted since the last successful install, and Oracle started correctly.

I had put a procedure starting Oracle in systartup_vms (this customer does not use SYSMAN), and was wondering how I could run a procedure shutting Oracle in syshutdwn.com, as this is supposed to run under a Oracle user ?

A submit/user=oracle will not work, as shutdown.com begins with stopping the queue manager.

[Hein van den Heuvel]

The oracle shutdown command is just an other Oracle (SQLplus) command, from an Oracle user with the right Oracle privs.

The OpenVMS username is really not relevant directly, other than it having been associated (external authentication) with a specific Oracle account or it having the password.

Whether the OpenVMS username is Oracle, OracleDBA, system or john_doe does not matter really, but _often_ accounts like oracledba are setup not to require an Oracle password making that convenient.

You could set that up for 'system' but most folks don't like that prefering to (pretend) to keep a separation between SA and DBA.

fwiw,
Hein.

[Zeni B. Schleter]

I am not the oracle support person but I remember a couple of problems we had around the time of adding Oracle 10G. One was that the sym PATH was defined in system-wide login and that caused a problem. The other one that related directly to TNS had to do with a logical that had to be added to the process table for oracle. That sounds similar to your problem.
It has been a while but all I really remember is that there was a logical (or logical table) that changed with reboots but it had to be added to logical table where it could be found by spawned jobs.
There should be a TNS_'pid logical where pid is the process id of the listener process. There should be a Server_%%%%%%%%%% table that is added to the LNM$FILE_DEV list. I have looked through startup procedures but have not found where the fix was applied and noted as such.
Sorry I can't be more specific.

[labadie_1]

Thanks Zeni for this info

Do you have a pointer on how to interpret the trace when I add
trace_level_client=support
trace_level_server=support
in sqlnet.ora ?

regards

[Zeni B. Schleter]

Sorry, I have no clue about how to read the trace. The only reason I knew about the logicals was because it was more of an OpenVMS specific issue that required DCL modification to fix.