- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Moving Oracle 8 from one HPUX10.2 to another H...
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-29-2000 09:38 PM
тАО03-29-2000 09:38 PM
Moving Oracle 8 from one HPUX10.2 to another HPUX10.2 machine
database(running SAP) to a different machine yet same platform HP-UX 10.20.
Which directories, and what files need modifing related to hostname changes and
the like...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-29-2000 10:45 PM
тАО03-29-2000 10:45 PM
Re: Moving Oracle 8 from one HPUX10.2 to another HPUX10.2 machine
you copy the datafiles into the different directories, you have to recreate
control file ):
- parameter files
- control files
- all the datafiles
- environment variables
- dump directories
Since the hostname has been changed, you have to modify the following files in
${ORACLE_HOME}/network/admin
directory:
- tnsnames.ora
- sqlnet.ora
- listener.ora
Good luck to you.
Queyon
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-11-2000 02:13 PM
тАО08-11-2000 02:13 PM
Re: Moving Oracle 8 from one HPUX10.2 to another HPUX10.2 machine
1) configure 2 systems the same way, have binaries for oracle and all the
mount points of the oracle datafile identical..
change alias in TNSNAMES to reflect the new hostname to match the
2nd server...
2)
this is much cleaner way,...
install oracle binaries,
then do quick analysis on system#1 and get the all tablesize sizing right,
then create DB and tablespaces on system#2
then do full export on system#1 followed by full export into system #2.
adjust your TNSNAMES on system#2 accordingly to new hostname.
Remember the "control" files on oracle acts just like /etc/lvmtab on hp-ux,
in that it contains the "full" hard-path to the datafile. That is the reason
you must have identical mount point.
This is the very simplified, HOWTOs.
SK
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-31-2000 09:23 AM
тАО08-31-2000 09:23 AM
Re: Moving Oracle 8 from one HPUX10.2 to another HPUX10.2 machine
1. Shutdown the oracle database.
2. Do a backup of the oracle binaries (i.e. $ORACLE_HOME on down.
3. Back up all of the datafiles associated with Oracle. Do a 'select name from V$datafile;' if you are not sure of the datafiles. You must get them all. Plus, be sure to get /etc/oratab, /sbin/init.d/oracle, and all of the directories and files under $ORACLE_BASE.
4. Restore the tape to the target machine and start oracle.
If you can shutdown the source machine long enough for a physical backup,
1. create a starter database via the create database command (This is a good time to change the database name if your plans include replication.)
2. Do a full export (See Oracle Utilities manual) from the source machine.
3. Create any directories for the datafiles on the target machine.
4. Do an import to the target machine. The import will recreate your tablespaces.
5. ftp, rcp or otherwise copy the support files:
/etc/oratab
/sbin/init.d/oracle (if you use it)
/etc/rc.config.d/oracle (if you use it)
There is a note in Metalink that covers creating a new instance. You may want to look over it in case I left something out.
-Good Luck
Allan Hicks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-31-2000 09:26 AM
тАО08-31-2000 09:26 AM
Re: Moving Oracle 8 from one HPUX10.2 to another HPUX10.2 machine
1. Shutdown the oracle database.
2. Do a backup of the oracle binaries (i.e. $ORACLE_HOME on down.
3. Back up all of the datafiles associated with Oracle. Do a 'select name from V$datafile;' if you are not sure of the datafiles. You must get them all. Plus, be sure to get /etc/oratab, /sbin/init.d/oracle, and all of the directories and files under $ORACLE_BASE.
4. Restore the tape to the target machine and start oracle.
If you can shutdown the source machine long enough for a physical backup,
1. create a starter database via the create database command (This is a good time to change the database name if your plans include replication.)
2. Do a full export (See Oracle Utilities manual) from the source machine.
3. Create any directories for the datafiles on the target machine.
4. Do an import to the target machine. The import will recreate your tablespaces.
5. ftp, rcp or otherwise copy the support files:
/etc/oratab
/sbin/init.d/oracle (if you use it)
/etc/rc.config.d/oracle (if you use it)
There is a note in Metalink that covers creating a new instance. You may want to look over it in case I left something out.
-Good Luck
Allan Hicks