Oracle

[Massimo_37]

We have a new HP UX 10.2 server(Oracle not installed). On our old server we have HP UX 10.2 running Oracle 7 database. We get a full database export backup daily from this(.dmp) database. We now need to get this databse working on the new server- what would be the best way to go about it- Could anyone please explain the steps please as I am . Many Thanks....

[Mark Grant]

If your oracle installation is not in vg00 a simple approach my be to vgexport the volume groups containing your installation and attach the new machine to the disks and vgimport it.

You probably would need to make a few Oracle config changes to cope with the new hostname but that's about it.

[Jean-Luc Oudart]

If you have a cold backup for the database.
1) backup/restore the oracle sw from old to new server. This should bring the directories required for new DB and config file (init.ora)
2) Restore the cold backup
3) If the filenames and path are identical this is easier otherwise you will require to clone the database
4) Update listener.ora and tnsnames.ora to reflect the new server name

Regards,
Jean-Luc

[Naveej.K.A]

hi,

anything to do with the user oracle?? and the group dba??

create the user and the group with the same UID and GID..

with best wishes
Naveej

[Jan Sladky]

If you need the old server still running
I would try to consider new installation of Oracle server and import whole database, than change IP on places from where the db is accessible.

br Jan

[twang]

Hi,
First of all, I would suggest that you perform a cold backup(both OS and Oracle).
Then 2 ways to go, first, you may reinstall the oracle RDBMS and import the database using your daily .dmp file.
Another option is that you may clone the whole Oracle RDBMS software and datafiles from old server to the new server. You need to schedule a downtime if you choose this method.

regards twang.

[Massimo_37]

Jean,
Your response seems promising- but could you please clarify a few more points ?
1. How do I backup/restore the oracle s/w from the old server. Or in other words which directories should I backup/restore ?

2) In our old server the logical volume /disc4 is part2 of the tablespaces on /disc2 and /disc1. Can I do away with /disc4 on the new server, as it is has got a much more bigger disk space.
Below is the output of filesystem structure
Many Thanks
Filesystem kbytes used avail %used Mounted on /dev/vg00/lvol3 1791145 1422948 189082 88% / /dev/vg00/lvol1 47829 24813 18233 58% /stand /dev/vg01/lvol14 1001729 949892 0 100% /disc5 /dev/vg01/lvol13 1001729 900730 826 100% /disc4 /dev/vg01/lvol12 1001729 900706 850 100% /disc3 /dev/vg01/lvol11 1001729 900706 850 100% /disc2 /dev/vg01/lvol10 1001729 257984 643572 29% /disc1

[Massimo_37]

Twang, couldyou please give me links or explain bit more about cloning database

[Jean-Luc Oudart]

Regarding Question #1,
you will need to restore /oracle fs (if /oracle is $ORACLE_BASE) and the oracle product file system (usually a different fs) this is $ORACLE_HOME.
If the init file (init.ora) or pfile (if any) is located elsewhere, you need to bring the files to the new server too.

Keep uid and gid for oracle user the same.

If you have other users in the dba group you may want them too on the new server.

Regarding Question #2, the file locations will be different there for you should "clone" the database.
the idea is to re-create the controle files.

You start with source database and create in udump the output file :
in SQLPlus/svrmgrl
Alter database backup controlfile to TRACE resetlogs.

The this file has to be edited on the target server to reflect path changes and comment out 1st few lines up to "STARTU" NOMOUNT" +
comment out :
# RECOVER DATABASE
and
# ALTER SYSTEM ARCHIVE LOG ALL;

I'll try to find an example for you.

Regards,
Jean-Luc

[Eric Antunes]

Adding to Jean-Luc answers

1) The easy way to do a cold backup is:

login as db user/owner, typically user oracle:
# login oracle
Password: ****
$ svrmgrl
...
SVRMGR> connect internal;
Connected.
SVRMGR> shutdown immediate; --ensure no one
is using database before doing this...
SVRMGR> quit;
Server Manager complete.
$ cd $ORACLE_HOME
$ cd ..
List the directories beginning with 7
$ ll 7*
If you have a DLT on both servers: insert a tape on the old server
$ tar cv 7... (I don't know the name of the directory but I think it may start by 7 since you are on Oracle 7 db)
If you don't have tapes you must do it through NFS...

2) You have the tablespaces on 3 logical volumes?? Then you must backup those 3 logical volumes.

[twang]

Attached is a paper listing the brief step for cloning a database from one machine to another. Hope it helps.

[twang · Accepted solution]

Sorry, miss the attachment.

[Massimo_37]

Thanks alot Twang, for the detailed notes. I shall test it out soon

[R. Allan Hicks]

If you do a backup rather than a new install, don't forget /etc/oratab or dbstart and dbshut won't work.

I'm not sure about rev 7, but you may need /var/opt/oracle. In later versions it pointed to the Oracle Inventory. I don't think it came into being until 8 so it may not be there.

Also, be sure and check the listener.ora file under $TNS_ADMIN. The host name should change to the new machine. Otherwise you will have trouble connecting from other clients.

Plus, don't forget to add the new service to tnsnames.ora also under $TNS_ADMIN on the clients or they won't know how to get to the new machine.


tns_ping is your friend. On the clients try it as

tns_ping new_service_name

If things are good, you get a response time, otherwise you will get a TNS error.

If it fails, try a regular network ping to verify the network before you put a lot of time into checking the tnsnames.ora.

If the network path is good, try

lsnrctl service

to get a list of services. They should match the services listed in the tnsnames.ora on the clients.

-Good luck

[Eric Antunes]

If your going to create the database on the new server with the same I think it is much more simple for you do it with a cold backup and restore. I just use the clone solution if I want to give a different to the database. Good luke!