- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- oracle clean install
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
тАО10-30-2003 07:07 PM
тАО10-30-2003 07:07 PM
oracle clean install
We will be clean installing HP-UX11i next week on a server which currently has an 817 Oracle DB.All
the DB datafiles are stored on an external XP256 storage array and will not be affected by O/S install.
After the clean install of Oracle 817 we will restore the backed up original Oracle config files(
init.ora;listener;tnsnames.ora etc.).Is the following still required:
1. can we then just startup the DB?
2. do we have to run the catproc.sql;catalog.sql etc?
Please advise.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-30-2003 07:37 PM
тАО10-30-2003 07:37 PM
Re: oracle clean install
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-30-2003 07:46 PM
тАО10-30-2003 07:46 PM
Re: oracle clean install
Also make sure that the kernel parameters are tuned correctly.
Also make sure all the configuration directories are ok in the init.ora file i.e. path of the control file.
If you are to recreate the file system with the same name with same path to the Oralce files things are ok.
Else just do a
rename of datafiles
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-30-2003 08:33 PM
тАО10-30-2003 08:33 PM
Re: oracle clean install
Im not recreating the DB.Im clean installing the O/S therefore have to clean install Oracle. The DB datafiles will be left in tact!
Thanks.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-30-2003 09:06 PM
тАО10-30-2003 09:06 PM
Re: oracle clean install
-
ensure that you are not accidentally overwriting any of the configuration or controlfiles.
I would do a "alter database backup controlfile to trace" and check it well - the paths of files.
-
"restore" the original configuration files and startup the database. This should work!
-
Above all, make sure you have a full backup of everything.
-
No need to run the catproc.sql, etc...
-
regards
Yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-30-2003 09:10 PM
тАО10-30-2003 09:10 PM
Re: oracle clean install
-
Make sure you have all the patches available (same/current) and again backup is very important.
regards
Yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-30-2003 09:17 PM
тАО10-30-2003 09:17 PM
Re: oracle clean install
No need to rerun any catalog scripts, as the database after the 11i upgrade will be exactly as before. catproc et al are used after new database creation.
And backup controlfile to trace as suggeseted above is always a good idea, so that if your new mountpoints differ from the old ones, you can recreate the control files and continue.
Good luck
-- Graham
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-31-2003 01:40 AM
тАО10-31-2003 01:40 AM
Re: oracle clean install
no prob, should work ...
Some pitfalls to consider:
Remember you will need to re-create the Users, so keep in mind to re-assign identically numeric IDs for UID and esp. GID of group "dba" !
You may change the UID if desired, but you will need to adjust the permissions on your re-mounted filesystem.
You may change the numeric GUI of "dba", which will require a re-link of Oracle, otherwise you will not be able to startup the DB, becaus of invalid group id.
Oh, and a funny one: If your database has been created by using the original starter-database, be sure you do NOT choose to create one upon the new install of oracle :-)
*** real life experience ***
If the machine has experienced successive hardware extensions in the past, you may see changes concerning the LUNs of i.e. controllers and/or LAN-Adapters, because the Luns are assigned sequential related to the hardware path. Now if a new controller had been added at a lower hardwarepath the devicefiles will switch !
/dev/dsk/c4t0d0 may become /dev/dsk/c3t0d0 !
You might need to deal with this when you reimport the VGs.
Good luck
Volker
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-31-2003 02:42 PM
тАО10-31-2003 02:42 PM