- 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-04-2010 09:02 AM
тАО03-04-2010 09:02 AM
Re: Oracle 10G, ora-12170 and ORA-12535
From my rather limited knowledge,
1) There is no single do-it-all startup procedure for Oracle 10.2. So you have to: a) install resident images; b) start the listener process via SRVCTL; c) bring your database instances up, one-by-one, also via SRVCTL. I assume you're running a plain vanilla Oracle 10.2, not a Real Application Cluster database. Otherwise, the entire startup procedure would be quite different.
2) Startup MUST be done from Oracle dedicated account so you can't run it directly from SYSTARTUP_VMS.COM, like you used to do with other products. Either do SUBMIT/USER=my_oracle_account or run it manually from that account.
3) To install resident images, you must either run ORAUSER and then INSORACLE, or first do DEFINE ORA_AUTO_INSORACLE TRUE and then do ORAUSER. From 10.2 on, that's how it's done.
4) When you have problems with Oracle 10.2 installation on OpenVMS, a good starting place for reading is Oracle note 726914.1, "Index of install related notes for Oracle 10.2 on hp OpenVMS". Make sure that you've read and followed the notes referenced there. You'll find a lot of seemingly minor but vitally important details. Takes time but saves you from a good deal of troubles...
5) BEFORE deploying any database instance, upgrade from 10.2.0.2 to 10.2.0.4 and apply the latest (10.2.0.4.3) patchset. Otherwise, you'll still have to do the upgrades AND manually run SQL scripts against each instance to recompile database views and objects after each upgrade. Without that, the sun will not rise ;)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-04-2010 12:09 PM
тАО03-04-2010 12:09 PM
Re: Oracle 10G, ora-12170 and ORA-12535
>>> 2) Startup MUST be done from Oracle dedicated account so you can't run it directly from SYSTARTUP_VMS.COM, like you used to do with other products. Either do SUBMIT/USER=my_oracle_account or run it manually from that account.
I do a submit/user=oracle_account
>>>3) To install resident images, you must either run ORAUSER and then INSORACLE,
Yes I do
>>>4) When you have problems with Oracle 10.2 installation on OpenVMS, a good starting place for reading is Oracle note 726914.1, "Index of install related notes for Oracle 10.2 on hp OpenVMS".
Yes I had downloaded and read before the install
>>>5) BEFORE deploying any database instance, upgrade from 10.2.0.2 to 10.2.0.4 and apply the latest (10.2.0.4.3) patchset.
Not possible here, the customer wanted to stick on this version (10.2.0.2).
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-05-2010 06:33 AM
тАО03-05-2010 06:33 AM
Re: Oracle 10G, ora-12170 and ORA-12535
>>>>>>5) BEFORE deploying any database instance, upgrade from 10.2.0.2 to 10.2.0.4 and apply the latest (10.2.0.4.3) patchset.
>>>Not possible here, the customer wanted to stick on this version (10.2.0.2).
Your customer should understand they're heading for big trouble and no one would be able to help them. Version 10.2.0.2 is NOT SUPPORTED. Oracle does not release fixes and CPUs (security updates) for unsupported versions. They must upgrade to 10.2.0.4 to be eligible for support. I really can't see any reason why they want to stick to 10.2.0.2 - to my (obviously very limited) knowledge, the difference is only bug fixes.
In any case, on VMS V8.3-1H1 I64, one must apply several mandatory patches for OpenVMS (see note 377480.1) and Oracle patches for 10.2.0.2 (see note 391580.1, for 10.2.0.4 see note 751537.1). Have you applied any of them yet? If yes, which ones? Did you try to open a support case on Metalink?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-05-2010 07:24 AM
тАО03-05-2010 07:24 AM
Re: Oracle 10G, ora-12170 and ORA-12535
Yes I had applied the patches you cited.
No I have not opened a case.
I do not see the advantage of having a trace file if it is not possible the interpret it.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-05-2010 12:02 PM
тАО03-05-2010 12:02 PM
Re: Oracle 10G, ora-12170 and ORA-12535
Frankly I'm more of the opinion that the trace files may be of _some_ use when one opens a TAR and is then asked by Oracle support to collect all that stuff... There are lots of Oracle problems out there that don't show up in the trace files. Imho, if you don't see there anything that gives you an immediate clue, don't waste your valuable time and open a TAR.
PS Regarding Oracle logicals and LNM$FILE_DEV. LNM$FILE_DEV is normally modified from within ORAUSER.COM. Every Oracle home has its own logical name table named SERVER_xxxxxxxxxx . When you run an Oracle command, it needs to know, what home should be affected by this command. To choose the appropriate home, the command looks up LNM$FILE_DEV and finds the name of corresponding logical name table. So every Oracle home has its own ORAUSER.COM and when you run a specific ORAUSER.COM, it redefines LNM$FILE_DEV appropriately. I'm not sure that'll help you much but who knows...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-08-2010 12:05 AM
тАО03-08-2010 12:05 AM
Re: Oracle 10G, ora-12170 and ORA-12535
Fekko Stube may be right with the invalid device name, but I would like to be sure this is a correct use of this 324...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-09-2010 05:17 AM
тАО03-09-2010 05:17 AM
Re: Oracle 10G, ora-12170 and ORA-12535
I have found on
http://hpdba.wordpress.com/tag/keep-alive/
that the secondary error code is OS dependant
Extract
nt secondary err code: 145
nt OS err code: 0
Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=nn.nn.nn.nn)(PORT=57922))
In this example, the Solaris error 145 shows that the disconnection was not due to an Oracle setting or database problem, (as some parties were insisting), but was actually from a connection timeout at the OS level. (Look up error number 145 in /usr/include/sys/errno.h ).
and if I do on a Solaris
grep 145 /usr/include/sys/errno.h
#define ETIMEDOUT 145 /* Connection timed out */
So the problem was an invalid device name, I suppose some mismatch in the ora* logical names, and the redefinitions of lnm$file_dev
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-09-2010 05:29 AM
тАО03-09-2010 05:29 AM
Re: Oracle 10G, ora-12170 and ORA-12535
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-09-2010 05:42 AM
тАО03-09-2010 05:42 AM
Re: Oracle 10G, ora-12170 and ORA-12535
If I only knew...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-09-2010 06:58 AM
тАО03-09-2010 06:58 AM
Re: Oracle 10G, ora-12170 and ORA-12535
Since we did not use extended parse style setting up to that point, we stumbled over that setting more than once.
- « Previous
-
- 1
- 2
- Next »