Oracle Software Owner - migration.

[former_member312761]

Hi Experts,

I tried to test Oracle database upgrade and I was stuck with one of the points – Migration Software Owner to ‘Oracle’.  I want to migrate user before Oracle upgrade, according to the note 1915317 one of the points is changing Ownership Oracle home via few scripts.

Scripts have been generated, but I’m not sure if correct options are selected:

If I want to change Ownership I must start the script - ./clone_assistnat.sh and generate scripts. All variable have been set, scripts have been generated with the following options:

• Action CONFIG not CLONE
• ORACLE_HOME - /oracle/SID/11204
• ORACLE_BASE - /orace/SID
• Do you want to change the software Owner for this oracle home ? – I selected yes (new owner – Oracle)

Source Oracle home       = not specified

Source Software Owner    = not specified:not specified

Target Oracle home       = /oracle/SID/11204

Target Software Owner    = orasid:dba

will be changed to         oracle:oinstall

Target Oracle home name  = ohn

Target Oracle base       = /oracle/SID

Target Oracle release    = 11.2

Target OSDBA group       = dba

Target OSOPER group      = oper

Copy command             = tar

Super user (root)        = root

Default oraInst.loc      = /etc/oraInst.loc

Inventory location       = not specified

MY VARIABLE FOR USER ora<sid>:

ORACLE_HOME - /oracle/SID/112_64

ORACLE_BASE - /oracle

ORACLE_SID - SID

1. What ORACLE_HOME should be set during the scripts generation ? - /oracle/SID/112_64 or /oracle/SID/11204 ?
2. ORACLE_BASE shoud be default /oracle/SID or as is defined in variable - /oracle
3. Shall I chose yes during the - Do you want to change the software Owner for this oracle home  and put new oracle owner and oracle group name ?

Thanks and Regards,

Tomasz

[willi_eimler]

Hi Tomasz,

these are the settings I used:

Server:orasid 2> ./clone_assistant.sh

######################################################################

### clone_assistant.sh (V1.7 PL 005 2015-01-19)
### Oracle Home Cloning Assistant
### Copyright (c) Oracle Corporation 2014. All Rights Reserved.

######################################################################

The following actions are available:

  (1) Copying an existing Oracle home to a new location (clone)

  (2) Moving  an existing Oracle home to a new location (relocate)

  (3) Changing the configuration of an existing Oracle home (config)

(4) Managing an existing Oracle home (manage)
(5) All these actions (all)
Which of these actions do you want to perform?
[clone]: 3
Your answer is: 3

(INFO)

-  For action 'config', several parameters are required.

Enter Oracle database release:

[11.2]:
Your answer is: 11.2

Default value settings

----------------------

Oracle Release	: 11.2
Database name <DBSID>	: SID

Source Oracle Home <IHRDBMS>: /oracle/SID/1120X

Target Oracle Home <IHRDBMS>: /oracle/SID/1120X

Target Oracle Base

: /oracle/SID

Parameter help

--------------

For Source Oracle home path, use installation Oracle home <IHRDBMS>.

For Target Oracle home path, use installation Oracle home <IHRDBMS>.

Example(s):

+---------+----------------------+----------------------+

|RELEASE  |ORACLE_HOME

|IHRDBMS

|

+---------+----------------------+----------------------+

|11.2.0.4 |/oracle/<DBSID>/112_64|/oracle/<DBSID>/11204 |

+---------+----------------------+----------------------+

Enter location for target Oracle home (ORACLE_HOME):

[/oracle/SID/1120X]: /oracle/SID/11204
(OK)	-  Location exists.
Your answer is: /oracle/SID/11204

Enter name for target Oracle home (ORACLE_HOME_NAME):

If you do not specify an Oracle home name, it will be generated by OUI.

[]:
(INFO)	-  Oracle home name will be generated by OUI.
Your answer is: empty

Enter location for target Oracle base (ORACLE_BASE):

Reference: SAP Note 1521371
[/oracle/SID]:
(OK)	-  ORACLE_BASE directory exists.
Your answer is: /oracle/SID

Enter name of OS group (OSDBA):

[dba]:
Your answer is: dba

Enter name of OS group (OSOPER):

[oper]:
Your answer is: oper

Do you want to change the software owner for this Oracle home?

[no]: yes
Your answer is: yes

Enter name of Oracle Software Owner:

[oracle]:
Your answer is: oracle

Enter name of primary group of Oracle Software Owner:

[oinstall]:
Your answer is: oinstall

Enter name of super user:

[root]:
Your answer is: root

Enter location for oraInst.loc:

[/etc/oraInst.loc]:

Your answer is: /etc/oraInst.loc

Enter location for scripts (script directory):

[/<Path of Script>/clone_scripts]:

Your answer is: /<Path of Script>/clone_scripts

(INFO)

-  You have specified the following parameters:

Action

: config

Target Oracle Home path : /oracle/SID/11204

	Oracle base path : /oracle/SID
	OSDBA group	: dba
	OSOPER group	: oper
	Software owner   : oracle
	Primary Group	: oinstall
	Release	: 11.2
	Hardware Type	: Custom Hardware
Inventory Pointer	: /etc/oraInst.loc
Super user	: root
Script location	: /<Path of Script>/clone_scripts

(INFO)

-  For action 'config' and the given parameters, the following command generates the corresponding scripts:

/<Path of Script>/clone_oh.sh -action config  -tgt_oh /oracle/SID/11204 -tgt_ob /oracle/SID -tgt_osdba dba -tgt_osoper oper -tgt_swowner oracle -tgt_swowner_group oinstall -tgt_release 11.2 -invPtrLoc /etc/oraInst.loc -root root -script_dir /<Path of Script>/clone_scripts

Do you want to generate the scripts?

[yes]:
Your answer is: yes
(INFO)	-  Generating scripts ...

######################################################################

### clone_oh.sh
### Oracle Home Cloning
### Copyright (c) Oracle Corporation 2014. All Rights Reserved.

######################################################################

Hostname / Platform : station1 linux_x86_64 (64-bit)

Current date	: 2015_10_26
Current time	: 15:42:00
Current user	: orasid (uid: 1003)

Current directory   : /<Path of Script>

Working directory   : /<Path of Script>

Script  directory   : /<Path of Script>/clone_scripts

Verbose mode	: NO
Query mode	: NO

Command line	: /<Path of Script>/clone_oh.sh
	-tgt_ob /oracle/SID
	-tgt_oh /oracle/SID/11204
	-tgt_osdba dba
	-tgt_osoper oper
	-tgt_swowner oracle
	-tgt_swowner_group oinstall
	-tgt_release 11.2
	-script_dir /<Path of Script>/clone_scripts
	-invPtrLoc /etc/oraInst.loc
	-root root
	-action config

Current Settings for Configuring an Oracle Home

Source Oracle home

= not specified

Target Oracle home	= /oracle/SID/11204
Target Software Owner	= orasid:dba
will be changed to	oracle:oinstall
Target Oracle home name  = not specified
Target Oracle base	= /oracle/SID
Target Oracle release	= 11.2
Target OSDBA group	= dba
Target OSOPER group	= oper

Copy command	= tar
Super user (root)	= root
Default oraInst.loc	= /etc/oraInst.loc

Creating scripts for action 'Configuring an Oracle Home' completed.

Location of generated scripts: /<Path of Script>/clone_scripts

(EXIT)

-  clone_assistant.sh - Exiting with exit code 0.

Best regards

Willi Eimler