SAP Database installation on Oracle ASM database

[#1]

Hi Experts,

I have successfully installed the oracle software 11g of oracle ASM database and its been installed as per my previous oracle softwares with oracle:oinstall user and group.

Now I am installing the DB instance before that I am performing ASM preparation. As a part of that I have choseen the general options ->

oracle-> DB tools->

RAC/ASM/EXadata database isntance preparation ABAP - Kernel 7.4X ->

Database identification section given the new DB sid and selected the single instance on Oracle ASM ->

DB administration (OS User) password given ->

home directory somehow choosen as /home/orasid - but changed manually it to /home/oracle/ but we do not have any user called orasid in server. we have only oracle and sidadm of system.

we have started installing with root user but really wondering how it got it picked up orasid. 

Apart from this in SWPM Sp08 there is one option to choose to install with orasid/oracle - so we can choose with oracle but in SWPM SP17 there is no option such like this.

We cant use SWPM SP08 as we need Kernel 7.4X which was not appearing in SWPM SP8.

Kindly suggest me here ?

Your kind help much appreciated.

Thanks

Pavan

[Former Member]

Thanks Prithvi.

I have gone throgh the notes.

let me explain you bit more clear, We have installed the oracle software with software owner which is oracle user id.

now the software permission is oracle : dba 11203

We are performing the ASM preparation check, for this started the SWPM SP17 tool with root user id and

general options ->

oracle-> DB tools->

RAC/ASM/EXadata database isntance preparation ABAP - Kernel 7.4X ->

Database identification section given the new DB sid and selected the single instance on Oracle ASM ->

DB administration (OS User) password given ->

home directory somehow choosen as /home/orasid - but changed manually it to /home/oracle/  and proceed with preparation.

Then we have recieved permission errors while progressing and changed /home/oracle permissions to 777 then completed the ASM preparation.

But now under /home/oracle directory some of the env varilables (ex .dbenv.sh) changed with orasid : dba instead of oracle: oinstall.

Now we have a doubt to proceed with installation of database. and it should not impact any existing databases.

ASM preparation has to be done with root id or oracle id ?

Can you please give your suggestion in detail.

Thanks

Pavan

[Former Member]

Hi Pavan

User: oracle.

Check below links

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/40f99657-82e2-3110-0ca8-99407e928...

Regards

Prithviraj

[Former Member]

Hi Prithivi,

You mean we have to perform the ASM preparation with oracle user id instead of root user id ????

after this DB instance installation with which user id we have to perform ????

Now we have completed the preparation by changing the /home/oracle permission.

Can you please let us know how iwe revert the ASM preparation and start freshly ?

Thank you much for your replies so far.

Regards,

[kaus19d]

Hi,

Any database related operation are recommended to be executed by the Database User-Id as that User has all the Admin-rights regarding database actions & activities.

For ASM acdtivities

Administering Oracle ASM Instances

For cleaning-up after removing

https://oracle-base.com/articles/rac/clean-up-a-failed-grid-infrastructure-installation

Thanks,

Kaushik