cancel
Showing results for 
Search instead for 
Did you mean: 

Using SWPM to clone a database to a new system

vince_laurent
Active Participant
0 Kudos

We are running Oracle 11.2.0.4 oh HP-UX 11.31 systems.

I have tired both and OFFLINE and then a database file copy from System A to System B.

When I get to the SWPM part where it does the backup/restore it fails.

I have done cloning databases outside of SAP tools so I think I know how to do it..

The first issue is that regardless of the way I move the datasbase the ALTER DATABASE RECOVER wants more archive logs... somehting that chokes the SAP tool.

So I thought I fixed it (tested by bringing the DB on System B up OK).  But now I can not get past the backup/Restore option.

In the pop-up I get:

An error occurred while processing option SAP NetWeaver 7.0 including Enhancement Package 3 > Software Life-Cycle Options > System Copy >Oracle > Target System Installation > Central System > Based on AS ABAP > Central System( Last error reported by the step: SQL statement or script failed. DIAGNOSIS: Error message: ORA-01012: not logged on ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance ORACLE instance started. Total System Global Area 1803841536 bytes Fixed Size 2206448 bytes Variable Size 956302608 bytes Database Buffers 838860800 bytes Redo Buffers 6471680 bytes Database mounted. Database opened. File created. Database closed. Database dismounted. ORACLE instance shut down. ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance ORACLE instance started. Total System Global Area 1803841536 bytes Fixed Size 2206448 bytes Variable Size 956302608 bytes Database Buffers 838860800 bytes Redo Buffers 6471680 bytes Database mounted. Database opened. Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options . SOLUTION: For more information, see ora_sql_results.log and the Oracle documentation.)

So... what is causing hte ORA-01012: not logged on message?

I know what is causing the ORA-32004: obsolete or deprecated parameter

(s) specified for RDBMS instance, it is SAPs requirement in the use of

the remote_os_authentication parameter.

How do I get by these? I mean I know my "new" database is up fine but

I can't get past the Backup/Restore database option in SWPM.

If there was only a 'skip' button...


Thanks for ANY help

Vince

Accepted Solutions (0)

Answers (3)

Answers (3)

vince_laurent
Active Participant
0 Kudos

Cloning the DB is not the issue, getting SWPM to recognize that it was already done is.

Thanks for the link.

Former Member
0 Kudos

Dear Vince,

Another alternative to clone oracle db is copy the all datafile, orilog, and mirrlog from source system to target system. adapt the database structure using control file (control file adaptation is needed following target system condition). this method was worked for me.

Please check this link:

http://www.dba-oracle.com/oracle_tips_db_copy.htm

Thanks & regards,

Husin

Reagan
Advisor
Advisor
0 Kudos

>>SOLUTION: For more information, see ora_sql_results.log and the Oracle documentation<<

Have you checked ora_sql_results.log log file?

Just curious to know, why are you running SWPM if you are doing a backup and restore of the DB?

As you have already installed Oracle and the OS is Unix why don't you just copy the SAP kernel, profiles and the environment files from the source to the target and adapt them?

Cheers

RB

vince_laurent
Active Participant
0 Kudos

Yes, I checked the ora_sql_results.log file and it wasn't really helpful.  Still digging.

As far as the method. I was just following the lead of our BASIS guy leading the project.

Do you have a document with your steps for what you suggest?  This SWPM is more hassle than it seems

Reagan
Advisor
Advisor
0 Kudos

There aren't many steps to be followed here if you follow my strategy. As you have already Oracle installed and configured and set up you just need to focus on the SAP configuration.

Create file systems /usr/sap/SID and /sapmnt/SID

Copy the contents of /sapmnt/SID/exe and /sapmnt/SID/profile from source to the target.

Modify the profiles names and the parameters with the target host, SID and port details.

Create directories under /usr/sap/SID like they are on source.

Create the symbolic links under /usr/sap/SID/SYS and also under /usr/sap/SID/DVEBMGS<NN>/work directory

Make sure the ownership and permissions are correct.

Install Oracle instant client

Adapt the /etc/services file with the MS entry

The list looks long but it is easy to do.

vince_laurent
Active Participant
0 Kudos

If and when would you run BDLS to change the SID?

vince_laurent
Active Participant
0 Kudos

Is my BASIS person trying to make it harder than it needs to be?

"I’m trying to find the all of the little details for the system copy just copying files over.  I have seen where they say just copy the kernel, some say copy kernel, environment files, some mention some other things. The most credible sounding one I’ve found goes through a lengthy install process then later  says use SWPM. I have to weed through the mountains of docs and try to find the meat and spit out the bones"

Reagan
Advisor
Advisor
0 Kudos

BDLS is one of the post system refresh activities. So technically speaking you can run BDLS once you have the target system up with a valid license installed and the profiles are set correctly.