Migration from oracle 8i to 9i

[Girish_17]

We have HP-UX 11.00 and oracle 8i. We are planning to go for oracle 9i. I want to know the prerequisites for the same. Letme know where the documentation regarding the same is available.

Awating forums valuable response.

Regards,
Girish Ransubhe

[Peter Leddy_1]

HI Girish,

Did you not get the information you needed from your previous post?

http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=749881

If you need more help I think you will need to be more specific.

HTH,

Peter

[Peter Godron]

Girish,
if you are going to use the ias side as well, in my opinion it is easier to go to 10g than ias with 9.
We have had problems with having to installs crashing and patch problems.
Once we decided to goto 10, clean install first time.
This is for the ias side of things, the databases are equally easy to install.

I know a lot of people are going to disagree, so this is only my personal view!

[Jean-Luc Oudart]

to Peter

As far as I know Oracle10G is not certified for HPUX11.0.
10G requires HPUX11i

Regards
Jean-Luc

[Jean-Luc Oudart]

Girish

I suggest you follow the discussion on thread :
http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=786324

Regards
Jean-Luc

[Steven E. Protter]

Your prior thread does seem to fully cover the topic.

I would note that 11.00 is approaching its end of life and eventually will not be supported. Its time to plan for the 11i v1 upgrade before
Oracle tells you the OS is not supported.

SEP

[Fred Ruffet]

Bible of prerequisites for Oracle on Unix is there :
http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=169706.1

Note that Oracle 9i is only available on 64bits HP-UX 11.
Regards,

Fred

[Indira Aramandla]

Hi Girish,

The above posts has the information that you are looking for. In addition you can also lokk into Metalink Note: 159657.1 with the tiltle â Complete Upgrade Checklist for Manual Upgrades from 8.X / 9.0.1 to Oracle9iâ

And if possible its prefered to upgrade to HP-UX 11i.


In

[Yogeeraj_1]

hi girish,

why don't you consider going to Oracle 10g directly instead?

There are many more features and bug fixes in 10g than in Oracle 9i...

regards
yogeeraj

[Girish_17]

Thanks U very much for your responses as of now.
I have some more details. As I already told you i am upgrading from 8i to 9i ( due to certain reasons i am not able to go for 10g ).
HPUX version is 11.0 (Again 11.23 is planned later and not allowed to do it now). Sorry for putting lot of constraints...but can't help it.

Find attached the Patching Status and the swlist output of my server.
Awaiting your valuable inputs.

Regards,
Girish

[Fred Ruffet · Accepted solution]

I see a lot of patch, but no Quality Pack. You should install last one (available at http://www8.itrc.hp.com/service/patch/releaseIndexPage.do?BC=patch.breadcrumb.main| ). Note that it does require reboot.

Also OnlineJFS is very useful in everyday life. But it's not free...

Regards,

Fred

[Girish_17]

Also find below the Kernel Parameters set for my System:Parameter:

NSTRBLKSCHED
Value: 2
Default: 2
Minimum: -
Module: -

Parameter: NSTREVENT
Value: 50
Default: 50
Minimum: -
Module: -

Parameter: NSTRPUSH
Value: 16
Default: 16
Minimum: -
Module: -

Parameter: NSTRSCHED
Value: 0
Default: 0
Minimum: -
Module: -

Parameter: STRCTLSZ
Value: 1024
Default: 1024
Minimum: -
Module: -

Parameter: STRMSGSZ
Value: 65535
Default: 0
Minimum: -
Module: -

Parameter: acctresume
Value: 4
Default: 4
Minimum: -
Module: -

Parameter: acctsuspend
Value: 2
Default: 2
Minimum: -
Module: -


Minimum: -
Module: -

Parameter: hfs_max_ra_blocks
Value: 8
Default: 8
Minimum: -
Module: -

Parameter: hfs_ra_per_disk
Value: 64
Default: 64
Minimum: -
Module: -

Parameter: hpux_aes_override
Value: 0
Default: 0
Minimum: -
Module: -

Parameter: initmodmax
Value: 50
Default: 50
Minimum: -
Module: -

Parameter: io_ports_hash_locks
Value: 64
Default: 64
Minimum: -
Module: -

Parameter: iomemsize
Value: 40000
Default: 40000
Minimum: -
Module: -

Parameter: km_disable
Value: 0
Default: 0
Minimum: -
Module: -

Parameter: ksi_alloc_max
Value: (NPROC*8)
Default: (NPROC*8)
Minimum: -
Module: -

Parameter: ksi_send_max
Value: 32
Default: 32
Minimum: -
Module: -

Parameter: lotsfree
Value: 0
Default: 0
Minimum: -
Module: -

Parameter: max_async_ports
Value: 50
Default: 50
Minimum: -
Module: -

Parameter: max_fcp_reqs
Value: 512
Default: 512
Minimum: 0
Module: -

Parameter: max_mem_window
Value: 0
Default: 0
Minimum: -
Module: -

Parameter: max_thread_proc
Value: 64
Default: 64
Minimum: -
Module: -

Parameter: maxdsiz
Value: 0x04000000
Default: 0x04000000
Minimum: -
Module: -

Parameter: maxdsiz_64bit
Value: 0x0000000040000000
Default: 0x0000000040000000
Minimum: -
Module: -

Parameter: maxfiles
Value: 200
Default: 60
Minimum: 0
Module: -

Parameter: maxfiles_lim
Value: 2048
Default: 1024
Minimum: 0
Module: -

Parameter: maxqueuetime
Value: 0
Default: 0
Minimum: -
Module: -

Parameter: maxssiz
Value: 0x00800000
Default: 0x00800000
Minimum: -
Module: -

Parameter: maxssiz_64bit
Value: 0x00800000
Default: 0x00800000
Minimum: -
Module: -

Parameter: maxswapchunks
Value: 1025
Default: 256
Minimum: -
Module: -

Parameter: maxtsiz
Value: 0x04000000
Default: 0x04000000
Minimum: -
Module: -

Parameter: maxtsiz_64bit
Value: 0x0000000040000000
Default: 0x0000000040000000
Minimum: -
Module: -

Parameter: maxuprc
Value: 512
Default: 75
Minimum: -
Module: -

Parameter: maxusers
Value: 124
Default: 32
Minimum: -
Module: -

Parameter: maxvgs
Value: 10
Default: 10
Minimum: -
Module: -

Parameter: mesg
Value: 1
Default: 1
Minimum: -
Module: -

Parameter: minfree
Value: 0
Default: 0
Minimum: -
Module: -

Parameter: modstrmax
Value: 500
Default: 500
Minimum: -
Module: -

Parameter: msgmap
Value: 2048
Default: (2+MSGTQL)
Minimum: -
Module: -

Parameter: msgmax
Value: 32767
Default: 8192
Minimum: -
Module: -

Parameter: msgmnb
Value: 262144
Default: 16384
Minimum: -
Module: -

Parameter: msgmni
Value: 1000
Default: 50
Minimum: -
Module: -

Parameter: msgseg
Value: 32767
Default: 2048
Minimum: -
Module: -

Parameter: msgssz
Value: 256
Default: 8
Minimum: -
Module: -

Parameter: msgtql
Value: 2046
Default: 40
Minimum: -
Module: -

Parameter: nbuf
Value: 0
Default: 0
Minimum: -
Module: -

Parameter: ncallout
Value: (16+NPROC)
Default: (16+NPROC)
Minimum: -
Module: -

Parameter: ncdnode
Value: 150
Default: 150
Minimum: -
Module: -

Parameter: nclist
Value: (100+16*MAXUSERS)
Default: (100+16*MAXUSERS)
Minimum: -
Module: -

Parameter: ncsize
Value: (NINODE+VX_NCSIZE)
Default: (NINODE+VX_NCSIZE)
Minimum: -
Module: -

Parameter: ndilbuffers
Value: 30
Default: 30
Minimum: -
Module: -

Parameter: netisr_priority
Value: -1
Default: -1
Minimum: -
Module: -

Parameter: netmemmax
Value: 0
Default: 0
Minimum: -
Module: -

Parameter: nfile
Value: 5120
Default: (16*(NPROC+16+MAXUSERS)/10+32+2*(NPTY+NSTRPTY+NSTRTEL))
Minimum: -
Module: -

Parameter: nflocks
Value: 1000
Default: 200
Minimum: -
Module: -

Parameter: nhtbl_scale
Value: 0
Default: 0
Minimum: -
Module: -

Parameter: ninode
Value: 15000
Default: ((NPROC+16+MAXUSERS)+32+(2*NPTY))
Minimum: -
Module: -

Parameter: nkthread
Value: (((NPROC*7)/4)+16)
Default: (((NPROC*7)/4)+16)
Minimum: -
Module: -

Parameter: nni
Value: 2
Default: 2
Minimum: -
Module: -

Parameter: no_lvm_disks
Value: 0
Default: 0
Minimum: -
Module: -

Parameter: nproc
Value: 2000
Default: (20+8*MAXUSERS)
Minimum: -
Module: -

Parameter: npty
Value: 512
Default: 60
Minimum: -
Module: -

Parameter: nstrpty
Value: 60
Default: 0
Minimum: -
Module: -

Parameter: nstrtel
Value: 60
Default: 60
Minimum: -
Module: -

Parameter: nswapdev
Value: 10
Default: 10
Minimum: -
Module: -

Parameter: nswapfs
Value: 10
Default: 10
Minimum: 1
Module: -

Parameter: nsysmap
Value: ((NPROC)>800?2*(NPROC):800)
Default: ((NPROC)>800?2*(NPROC):800)
Minimum: -
Module: -

Parameter: nsysmap64
Value: ((NPROC)>800?2*(NPROC):800)
Default: ((NPROC)>800?2*(NPROC):800)
Minimum: -
Module: -

Parameter: num_tachyon_adapters
Value: 5
Default: 0
Minimum: 0
Module: -

Parameter: o_sync_is_o_dsync
Value: 0
Default: 0
Minimum: 0
Module: -

Parameter: page_text_to_local
Value: 0
Default: 0
Minimum: -
Module: -

Parameter: pfdat_hash_locks
Value: 128
Default: 128
Minimum: -
Module: -

Parameter: public_shlibs
Value: 1
Default: 1
Minimum: -
Module: -

Parameter: region_hash_locks
Value: 128
Default: 128
Minimum: -
Module: -

Parameter: remote_nfs_swap
Value: 0
Default: 0
Minimum: -
Module: -

Parameter: rtsched_numpri
Value: 32
Default: 32
Minimum: -
Module: -

Parameter: scroll_lines
Value: 100
Default: 100
Minimum: 50
Module: -

Parameter: scsi_maxphys
Value: 1048576
Default: 1048576
Minimum: -
Module: -

Parameter: sema
Value: 1
Default: 1
Minimum: -
Module: -

Parameter: semaem
Value: 16384
Default: 16384
Minimum: -
Module: -

Parameter: semmap
Value: 4002
Default: (SEMMNI+2)
Minimum: -
Module: -

Parameter: semmni
Value: 4000
Default: 64
Minimum: -
Module: -

Parameter: semmns
Value: 8000
Default: 128
Minimum: -
Module: -

Parameter: semmnu
Value: 1996
Default: 30
Minimum: -
Module: -

Parameter: semmsl_override
Value: 2048
Default: 2048
Minimum: -
Module: -

Parameter: semume
Value: 30
Default: 10
Minimum: -
Module: -

Parameter: semvmx
Value: 32767
Default: 32767
Minimum: -
Module: -

Parameter: sendfile_max
Value: 0
Default: 0
Minimum: -
Module: -

Parameter: shmem
Value: 1
Default: 1
Minimum: -
Module: -

Parameter: shmmax
Value: 1073741824
Default: 0X4000000
Minimum: -
Module: -

Parameter: shmmni
Value: 500
Default: 200
Minimum: -
Module: -

Parameter: shmseg
Value: 25
Default: 120
Minimum: -
Module: -

Parameter: st_ats_enabled
Value: 1
Default: 1
Minimum: -
Module: -

Parameter: st_fail_overruns
Value: 0
Default: 0
Minimum: -
Module: -

Parameter: st_large_recs
Value: 0
Default: 0
Minimum: -
Module: -

Parameter: streampipes
Value: 0
Default: 0
Minimum: 0
Module: -

Parameter: swapmem_on
Value: 1
Default: 1
Minimum: -
Module: -

Parameter: swchunk
Value: 2048
Default: 2048
Minimum: 2048
Module: -

Parameter: sysmon_ports
Value: 2048
Default: 2048
Minimum: 64
Module: -

Parameter: sysv_hash_locks
Value: 128
Default: 128
Minimum: -
Module: -

Parameter: tcphashsz
Value: 0
Default: 0
Minimum: -
Module: -

Parameter: timeslice
Value: (100/10)
Default: (100/10)
Minimum: -
Module: -

Parameter: timezone
Value: 420
Default: 420
Minimum: -
Module: -

Parameter: unlockable_mem
Value: 0
Default: 0
Minimum: -
Module: -

Parameter: vnode_cd_hash_locks
Value: 128
Default: 128
Minimum: -
Module: -

Parameter: vnode_hash_locks
Value: 128
Default: 128
Minimum: -
Module: -

Parameter: vps_ceiling
Value: 16
Default: 16
Minimum: -
Module: -

Parameter: vps_chatr_ceiling
Value: 65536
Default: 65536
Minimum: -
Module: -

Parameter: vps_pagesize
Value: 4
Default: 4
Minimum: -
Module: -

Parameter: vx_ncsize
Value: 1024
Default: 1024
Minimum: -
Module: -

Parameter: vx_ninode
Value: 0
Default: 0
Minimum: -
Module: -

Parameter: vx_noifree
Value: 0
Default: 0
Minimum: -
Module: -

Parameter: vxfs_max_ra_kbytes
Value: 1024
Default: 1024
Minimum: -
Module: -

Parameter: vxfs_ra_per_disk
Value: 1024
Default: 1024
Minimum: -
Module: -


PLease let me know if you have any suggestion regarding change in kernel parameter values.

Thanks again,
Girish

[Jean-Luc Oudart]

Girish,

increase yourr shmmax value.
don't split the SGA across n segments !

What is the memory available on the server ?
What is the target size for the SGA ?

attached doc on SGA improvment

Regards
Jean-Luc

[Jean-Luc Oudart]

Check this document too.

Regards
Jean-Luc