- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - OpenVMS
- >
- Re: Oracle 10G, ora-12170 and ORA-12535
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-03-2010 03:35 AM
тАО03-03-2010 03:35 AM
Oracle 10G, ora-12170 and ORA-12535
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-03-2010 04:31 AM
тАО03-03-2010 04:31 AM
Re: Oracle 10G, ora-12170 and ORA-12535
Could it mean vms error 324
exit 324: system-f-invdevnam,invalid device name
Maybe a logical disappeared after the boot??
Fekko
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-03-2010 09:42 PM
тАО03-03-2010 09:42 PM
Re: Oracle 10G, ora-12170 and ORA-12535
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-04-2010 12:54 AM
тАО03-04-2010 12:54 AM
Re: Oracle 10G, ora-12170 and ORA-12535
>>>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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-04-2010 04:48 AM
тАО03-04-2010 04:48 AM
Re: Oracle 10G, ora-12170 and ORA-12535
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-04-2010 05:14 AM
тАО03-04-2010 05:14 AM
Re: Oracle 10G, ora-12170 and ORA-12535
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-04-2010 05:23 AM
тАО03-04-2010 05:23 AM
Re: Oracle 10G, ora-12170 and ORA-12535
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-04-2010 06:09 AM
тАО03-04-2010 06:09 AM
Re: Oracle 10G, ora-12170 and ORA-12535
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-04-2010 06:23 AM
тАО03-04-2010 06:23 AM
Re: Oracle 10G, ora-12170 and ORA-12535
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-04-2010 08:05 AM
тАО03-04-2010 08:05 AM