Re: Changing ownership of Oracle database installation

Hi,

	FOR Terry
	When you are agree to give osoper to some user/developper and/or osdba.

	When for old version you have got sqlnet I start with dbaon.

	When ....

Try with a test database:

        CASE ONE MANY DATABASE WITH MORE THEN ONE OWNER.         Create in the follwoing directory.

	ORACLE_USER=oratest	# the new oracle user
	OSOPER=osoper		# a group in which $ORACLE_USER don't need to be.
	OSDBA=osdba			# the default group for $ORACLE_USER.

	as root:

	mkdir	.../app/oracle/product/${VERSION}_${ORACLE_USER}
	chown $ORACLE_USER 	.../app/oracle/product/${VERSION}_${ORACLE_USER}
	chgrp $OSDBA 			.../app/oracle/product/${VERSION}_${ORACLE_USER}
	chmod 0755		 	.../app/oracle/product/${VERSION}_${ORACLE_USER}

	as $ORACLE_USER

	ORACLE_HOME=.../app/oracle/product/${VERSION}_${ORACLE_USER}
	# in all that directory you will find file specific to the other user.
	cd $ORACLE_HOME
	for i in rdbms rdbms/audit rdbms/lib rdbms/log dbs otrace otrace/admin
network network/log network/admin network/trace lib bin
	do
		mkdir $i
	done
	# now copy the file you need to change store the OSOPER,OSDBA,... or local
to the instance
	# config.s can be config.c platfrm specific.
	cp $REF_ORACLE_HOME/rdbms/lib/config.s $ORACLE_HOME/lib/config.s
	# change in this file the osper osdba
	# .L12 => osdba .L13=> osoper
	vi  $ORACLE_HOME/lib/config.s
	for i in imp exp sqlldr oracle sqlload
	do
		touch $ORACLE_HOME/bin/$i  $ORACLE_HOME/bin/${i}O
	done
	# Create link for all the other file.
	for i in `find . -name '??*' -print`
	do
		( cd $REF_ORACLE_HOME ; ''ls -1d $i/* 2>/dev/null | sed 's:/$::' ) |
while read a
		do
			if test -f $a -o -d $a -o -h $a 
			then
				echo $a OK
			else
				ln -s $a $REF_ORACLE_HOME/$a
			fi
		done
	done
	find otrace -name '*.dat' -execrm {} ';'
	cd rdbms/lib
	make -f  ins_rdbms.mk install
	# Now you can create database for that user.
	
	# Change a database from oracle to $ORACLE_USER.
	# Change the file owner when db down.
	# 	RECREATE THE CONTROL FILE CHECK IN THE ADMINISTRATOR GUIDE.
	# ALTER DATABASE BACKUP CONTROLEFILE TO TRACE ;
	# Check $ORACLE_USER can read all the file.

-- 
Regards LANGE Francois.
flange_at_pt.lu
29A Route du vin.
L5450 Stadtbredimus.
Grand Duchy Of Luxembourg.
TEL (int) 352 697412.(*)
CEL(int) 352 021193652(*)
Phone numbers are variable length in Luxembourg.
Grand Duchy Of Luxembourg is a small country 80 miles on 60 miles between
France,Germany and Belgium.		
	

terryg8 <trg_at_ibm.net> wrote in article <3429B869.53_at_ibm.net>...


> speed_at_racer.cartoon.spam.address wrote:

> > 

> > Given an Oracle installation that was installed as owner=Oracle,

> > group=dba, what steps are necessary in order to change the ownership of

> > the installation to an owner other than Oracle?

> > 

> > Is it as simple as a 'chown -R' on the installation tree?

> > 

> > The reason I want to do this is to "localize" the Oracle installation

> > thus eliminating the need for multiple installations to use the same

> > oracle login ID.

> > 

> > Thanks in advance.

> > 

> We run several database all owned by oracle, as

> is the norm.  Just curious,  what problems are

> you having with multiple instances using the

> same oracle login?  Perhaps there is a simple

> way to alleviate the problems.

> 

> Cheers,

> Terry

> 

>