DBA Hub

📋Steps in this guide1/5

Create users, groups and Paths for Oracle RAC

Create users, groups and Paths for Oracle RAC

oracle clusteringintermediate
by OracleDba
12 views
1

Overview

Create users, groups and Paths for Oracle RAC Note: When you create the user and group, make sure that you specify a user and group ID that is not in use. Create the necessary Oracle groups and users. Be sure to assign the same group ID, user ID, and home directory for the user on each system
2

Section 2

Step 1: Create groups Step 2: Create users

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
[root@testbox ~]#
/usr/sbin/groupadd -g 3001 oinstall
[root@testbox ~]#
/usr/sbin/groupadd -g 3002 dba
[root@testbox ~]#
/usr/sbin/groupadd -g 3003 asmadmin
[root@testbox ~]#
/usr/sbin/groupadd -g 3004 asmdba
[root@testbox ~]#
/usr/sbin/groupadd -g 3005 asmoper
[root@testbox ~]#
3

Section 3

Step 3: Verify users and groups Step 4: Verify users and groups

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
[root@testbox ~]#
/usr/sbin/useradd -u 3000 -g oinstall -G asmdba,dba,asmadmin,asmoper grid
[root@testbox ~]#
/usr/sbin/useradd -u 3001 -g oinstall -G asmdba,dba,asmadmin oracle
[root@testbox ~]#

[root@testbox ~]#
id oracle
uid=3001(oracle) gid=3001(oinstall) groups=3001(oinstall),3002(dba),3003(asmadmin),3004(asmdba)
[root@testbox ~]#
[root@testbox ~]#
id grid
uid=3000(grid) gid=3001(oinstall) groups=3001(oinstall),3002(dba),3003(asmadmin),3004(asmdba),3005(asmoper)
[root@testbox ~]#

[root@testbox ~]# grep oracle /etc/passwd
oracle:x:3001:3001::/home/oracle:/bin/bash
[root@testbox ~]#

[root@testbox ~]# grep grid /etc/passwd
grid:x:3000:3001::/home/grid:/bin/bash
[root@testbox ~]#

[root@testbox ~]# ls -ld /home/grid
drwx------. 3 grid oinstall 78 Apr  2 02:06 /home/grid
[root@testbox ~]#
[root@testbox ~]# ls -ld /home/oracle
drwx------. 3 oracle oinstall 78 Apr  2 02:06 /home/oracle
[root@testbox ~]#
4

Section 4

# mkdir -p /u01/app/grid ( ORACLE_BASE for GRID HOME ) # mkdir -p /u01/app/19.0.0/grid ( GRID_HOME ) # chown -R grid:oinstall /u01 # mkdir -p /u01/app/oracle ( ORACLE_BASE for ORACLE HOME ) # mkdir -p /u01/app/oracle/product/19.0.0/dbhome_1 ( ORACLE HOME ) # chown -R oracle:oinstall /u01/app/oracle # chmod -R 775 /u01/ Step 5: Verify ownership and permissions Caution: Your use of any information or materials on this website is entirely at your own risk. It is provided for educational purposes only. It has been tested internally, however, we do not guarantee that it will work for you. Ensure that you run it in your test environment before using. Caution:

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
# mkdir -p /u01/app/grid ( ORACLE_BASE for GRID HOME )
# mkdir -p /u01/app/19.0.0/grid         ( GRID_HOME )
# chown -R grid:oinstall /u01
# mkdir -p /u01/app/oracle              ( ORACLE_BASE for ORACLE HOME ) 
# mkdir -p /u01/app/oracle/product/19.0.0/dbhome_1 ( ORACLE HOME )
# chown -R oracle:oinstall /u01/app/oracle
# chmod -R 775 /u01/
[root@testbox ~]# mkdir -p /u01/app/19.0.0/grid
[root@testbox ~]# mkdir -p /u01/app/grid
[root@testbox ~]# chown -R grid:oinstall /u01
[root@testbox ~]#
[root@testbox ~]# mkdir -p /u01/app/oracle
[root@testbox ~]# mkdir -p /u01/app/oracle/product/19.0.0/dbhome_1
[root@testbox ~]# chown -R oracle:oinstall /u01/app/oracle
[root@testbox ~]# chmod -R 775 /u01/
[root@testbox ~]#

[root@testbox ~]#
ls -ld /u01/app/19.0.0/grid
drwxrwxr-x. 2
grid oinstall
4096 Apr  2 03:08 /u01/app/19.0.0/grid
[root@testbox ~]#
ls -ld /u01/app/grid
drwxrwxr-x. 2
grid oinstall
4096 Apr  2 03:08 /u01/app/grid
[root@testbox ~]#

[root@testbox ~]#
ls -ld /u01/app/oracle
drwxrwxr-x. 3
oracle oinstall
4096 Apr  2 03:10 /u01/app/oracle
[root@testbox ~]#
ls -ld /u01/app/oracle/product/19.0.0/dbhome_1
drwxrwxr-x. 2
oracle oinstall
4096 Apr  2 03:10 /u01/app/oracle/product/19.0.0/dbhome_1
[root@testbox ~]#
5

Section 5

Your use of any information or materials on this website is entirely at your own risk. It is provided for educational purposes only. It has been tested internally, however, we do not guarantee that it will work for you. Ensure that you run it in your test environment before using.

Comments (0)

Please to add comments

No comments yet. Be the first to comment!