- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Oracle ias/db problem.
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
тАО04-01-2003 12:03 PM
тАО04-01-2003 12:03 PM
Oracle ias/db problem.
Works great on HP-UX 11.00 32 bit
Oracle 8.1.7.0.0 32 bit.
ias 1.2.2 patch 12 (Includes forms and reports) 32 bit only. Also known as 9ias
Migrate it here:
HP-UX 11.11(11i) 64 bit.
Oracle 8.1.7.4.0
ias 1.2.2 patch 12 32 bit only certified for the platform.
When you start the application connecting to the new server after running a record querey based on list of values or any one of a hundred other database functions the app locks up.
The error code, if you are careful to watch is
FRM-92100, your connection to the database has been terminated.
The database trace sometimes picks up an ORA-0600 error, which means the same thing.
We hung a process trace using the tusc utility on the server and got lots of interesting results in this thread:
http://forums.itrc.hp.com/cm/QuestionAnswer/1,,0x0a49b82b2d63d71190080090279cd0f9,00.html
Please take the time to read this thread carefully if you are going to make OS related suggestions(which I think is the issue). It includes the process traces and kmtune output and patch level information. Anything missing, ask for it I'll post it.
Question: has anybody encountered this problem on HP-UX 64 bit 11.11(11i)? If so, have they resolved it. If requested, I will post up init.ora tnsnames.ora and other configuration files.
The application runs on the web through the I.E. 5.5 browser running jinitiator 1.3.1.6
I'm just looking for the Oracle angle here. Os stuff should go to the other thread. Someone posted it up as an April success story because they thought it was a cool thread. If it wasn't my problem, I'd agree.
SEP
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-01-2003 12:17 PM
тАО04-01-2003 12:17 PM
Re: Oracle ias/db problem.
I had been reading the thread and looking at the varied responses, had to point it out - it is not a success story but it is on the whole a good example of how many varied insights you get from the forum users... which I've pointed out to dan, although you haven't tasted much success till now. my sympathies are with you on that count.
- ramd.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-01-2003 12:22 PM
тАО04-01-2003 12:22 PM
Re: Oracle ias/db problem.
SEP
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-01-2003 03:17 PM
тАО04-01-2003 03:17 PM
Re: Oracle ias/db problem.
What changes were made between the two systems with Oracle besides the version (character set changes, etc)?
How was the database changed to the new version (offline backup, online backup with PITR, export/import)?
What is the ORA-00600 error posted?
Thanks,
Brian
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-01-2003 07:06 PM
тАО04-01-2003 07:06 PM
Re: Oracle ias/db problem.
Not even the instance names were changed, though the tnsnames.ora and network files were changed to reflect the IP address of the new server.
SEP
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-01-2003 07:08 PM
тАО04-01-2003 07:08 PM
Re: Oracle ias/db problem.
SEP
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-01-2003 07:27 PM
тАО04-01-2003 07:27 PM
Re: Oracle ias/db problem.
Regarding your word-size change, you did run the utlirp.sql script in ?/rdbms/admin to rebuild all of the scripts. This is not done as part of the migration as far as I know. (Just checking).
Also, it looks like your maxtsiz is a bit small from the kmtune report. Not sure how this would affect the 32bit IAS.
Thanks,
Brian
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-01-2003 08:34 PM
тАО04-01-2003 08:34 PM
Re: Oracle ias/db problem.
That's exactly what we're getting. !!!!
The funny part is we don't get it on the 11.00 32 bit servers.
Post a workaround or solution and earn a rabbit.
Please. The more details the better.
SEP
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-01-2003 08:35 PM
тАО04-01-2003 08:35 PM
Re: Oracle ias/db problem.
We are certain it worked an we have no invalid objects on the database.
SEP
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-02-2003 09:28 AM
тАО04-02-2003 09:28 AM
Re: Oracle ias/db problem.
As an FYI, one database that we were getting this error on we moved to WE8ISO8859P1 and the problem has not reoccured in the past two weeks (was about 1-2 times a day).
Hope this helps,
Brian