on 01-13-2015 8:39 PM
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
Cloning the DB is not the issue, getting SWPM to recognize that it was already done is.
Thanks for the link.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
>>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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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"
User | Count |
---|---|
85 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.