Errors and Solutions while installing RAC Node one on Solaris
Errors while ASM disk discovery
Changed the permissions as follows
chown grid:asmadmin /dev/rdsk/c2d2s0
chmod 660 /dev/rdsk/c2d2s0
chown grid:asmadmin /dev/rdsk/c2d3s0
chmod 660 /dev/rdsk/c2d3s0
chown grid:asmadmin /dev/rdsk/c2d4s0
chmod 660 /dev/rdsk/c2d4s0
chown grid:asmadmin /dev/rdsk/c2d5s0
chmod 660 /dev/rdsk/c2d5s0
chown grid:asmadmin /dev/rdsk/c2d6s0
chmod 660 /dev/rdsk/c2d6s0
ls -al /dev/rdsk/c2d2s0
ls -al /dev/rdsk/c2d3s0
ls -al /dev/rdsk/c2d4s0
ls -al /dev/rdsk/c2d5s0
ls -al /dev/rdsk/c2d6s0
Solution
Permission not changed even after chmod,chown but ASM candidate disks are discovered.Hence ignored the permission errors and proceed.
Error while configuring SSH issue
Solution
rm -Rf .ssh
deluser oracle
useradd -u 502 -c "Oracle RDBMS Owner" -g oinstall -G dba,oper,asmdba oracle
passwd oracle
chmod -Rf 755 /export/home/oracle
chown -Rf oracle:oinstall /export/home/oracle
Errors during dbca, out of memory issue
root@host01 # prtconf | grep Mem
Memory size: 32768 Megabytes
root@host01 # id -p
uid=0(root) gid=0(root) projid=1(user.root)
root@host01 # su - oracle
Oracle Corporation SunOS 5.11 11.1 December 2013
-bash-4.1$ id -p
uid=502(oracle) gid=100(dba) projid=100(user.oracle)
-bash-4.1$ prctl -n project.max-shm-memory -i project 100
project: 100: user.oracle
NAME PRIVILEGE VALUE FLAG ACTION RECIPIENT
project.max-shm-memory
privileged 11.2GB - deny -
system 16.0EB max deny
prctl -n project.max-shm-memory -r -v 20G -i project 100
vi /etc/system
set shmsys:shminfo_shmmax=21474836480
set semsys:seminfo_semmni=1024
set semsys:seminfo_semmsl=1024
set shmsys:shminfo_shmmni=100
Solution:
Temporarily reduced the SGA to 10gb, later permanently add the parameter in /etc/project
Error:
ORA-28000
Solution :
connect as sys and unlock the sys account.
Error:
ORA-13516
Solution :
Ignored the AWR error
Error:
ORA-12545 while connecting thru sqlplus
Solution :
I have entered hostdbsc for scan name while installing instead provide FQDN.
alter system set remote_listener='hostname.domain.net.in:1521' scope=both sid='*';
Checked the database status after installation
-bash-4.1$ srvctl status database -d orcldb
Instance orcldb_1 is running on node host01
Online relocation: INACTIVE
-bash-4.1$ srvctl config database -d orcldb
Database unique name: orcldb
Database name: orcldb
Oracle home: /oracle/RacN1db/dbhome
Oracle user: oracle
Spfile: +DATA/orcldb/spfileorcldb.ora
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: orcldb
Database instances:
Disk Groups: DATA
Mount point paths:
Services: orcldb1
Type: RACOneNode
Online relocation timeout: 30
Instance name prefix: orcldb
Candidate servers: host01,host02
Database is administrator managed
Error while Relocating
-bash-4.1$ srvctl relocate database -d orcldb -n host02
PRCD-1222 : Online relocation of database "orcldb" failed but database was restored to its original state
PRCR-1037 : Failed to update cardinality of the resource ora.orcldb.db to 2
PRCR-1071 : Failed to register or update resource ora.orcldb.db
CRS-0245: User doesn't have enough privilege to perform the operation
Tried Solution 1 :
crsctl pin css -n host01 host02
-bash-4.1$ olsnodes -t -n
host01 1 Unpinned
host02 2 Unpinned
-bash-4.1$ su -
Password:
Oracle Corporation SunOS 5.11 11.1 December 2013
You have new mail.
Sourcing /root/.profile-EIS.....
root@host01 # cd /oracle/11.2.0/grid/bin
root@host01 # ./crsctl pin css -n host01 host02
CRS-4664: Node host01 successfully pinned.
CRS-4664: Node host02 successfully pinned.
root@host01 # ./olsnodes -t -n
host01 1 Pinned
host02 2 Pinned
Tried Solution 2:
crsctl getperm res ora.orcldb.db
Solution 3 (worked):
run the srvctl relocate command as root user.
-bash-4.1$ srvctl status database -d orcldb
Instance orcldb_2 is running on node host02
Online relocation: ACTIVE
Source instance: orcldb_2 on host02
Destination instance: orcldb_1 on host01
Errors while ASM disk discovery
Changed the permissions as follows
chown grid:asmadmin /dev/rdsk/c2d2s0
chmod 660 /dev/rdsk/c2d2s0
chown grid:asmadmin /dev/rdsk/c2d3s0
chmod 660 /dev/rdsk/c2d3s0
chown grid:asmadmin /dev/rdsk/c2d4s0
chmod 660 /dev/rdsk/c2d4s0
chown grid:asmadmin /dev/rdsk/c2d5s0
chmod 660 /dev/rdsk/c2d5s0
chown grid:asmadmin /dev/rdsk/c2d6s0
chmod 660 /dev/rdsk/c2d6s0
ls -al /dev/rdsk/c2d2s0
ls -al /dev/rdsk/c2d3s0
ls -al /dev/rdsk/c2d4s0
ls -al /dev/rdsk/c2d5s0
ls -al /dev/rdsk/c2d6s0
Solution
Permission not changed even after chmod,chown but ASM candidate disks are discovered.Hence ignored the permission errors and proceed.
Error while configuring SSH issue
Solution
rm -Rf .ssh
deluser oracle
useradd -u 502 -c "Oracle RDBMS Owner" -g oinstall -G dba,oper,asmdba oracle
passwd oracle
chmod -Rf 755 /export/home/oracle
chown -Rf oracle:oinstall /export/home/oracle
Errors during dbca, out of memory issue
root@host01 # prtconf | grep Mem
Memory size: 32768 Megabytes
root@host01 # id -p
uid=0(root) gid=0(root) projid=1(user.root)
root@host01 # su - oracle
Oracle Corporation SunOS 5.11 11.1 December 2013
-bash-4.1$ id -p
uid=502(oracle) gid=100(dba) projid=100(user.oracle)
-bash-4.1$ prctl -n project.max-shm-memory -i project 100
project: 100: user.oracle
NAME PRIVILEGE VALUE FLAG ACTION RECIPIENT
project.max-shm-memory
privileged 11.2GB - deny -
system 16.0EB max deny
prctl -n project.max-shm-memory -r -v 20G -i project 100
vi /etc/system
set shmsys:shminfo_shmmax=21474836480
set semsys:seminfo_semmni=1024
set semsys:seminfo_semmsl=1024
set shmsys:shminfo_shmmni=100
Solution:
Temporarily reduced the SGA to 10gb, later permanently add the parameter in /etc/project
Error:
ORA-28000
Solution :
connect as sys and unlock the sys account.
Error:
ORA-13516
Solution :
Ignored the AWR error
Error:
ORA-12545 while connecting thru sqlplus
Solution :
I have entered hostdbsc for scan name while installing instead provide FQDN.
alter system set remote_listener='hostname.domain.net.in:1521' scope=both sid='*';
Checked the database status after installation
-bash-4.1$ srvctl status database -d orcldb
Instance orcldb_1 is running on node host01
Online relocation: INACTIVE
-bash-4.1$ srvctl config database -d orcldb
Database unique name: orcldb
Database name: orcldb
Oracle home: /oracle/RacN1db/dbhome
Oracle user: oracle
Spfile: +DATA/orcldb/spfileorcldb.ora
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: orcldb
Database instances:
Disk Groups: DATA
Mount point paths:
Services: orcldb1
Type: RACOneNode
Online relocation timeout: 30
Instance name prefix: orcldb
Candidate servers: host01,host02
Database is administrator managed
Error while Relocating
-bash-4.1$ srvctl relocate database -d orcldb -n host02
PRCD-1222 : Online relocation of database "orcldb" failed but database was restored to its original state
PRCR-1037 : Failed to update cardinality of the resource ora.orcldb.db to 2
PRCR-1071 : Failed to register or update resource ora.orcldb.db
CRS-0245: User doesn't have enough privilege to perform the operation
Tried Solution 1 :
crsctl pin css -n host01 host02
-bash-4.1$ olsnodes -t -n
host01 1 Unpinned
host02 2 Unpinned
-bash-4.1$ su -
Password:
Oracle Corporation SunOS 5.11 11.1 December 2013
You have new mail.
Sourcing /root/.profile-EIS.....
root@host01 # cd /oracle/11.2.0/grid/bin
root@host01 # ./crsctl pin css -n host01 host02
CRS-4664: Node host01 successfully pinned.
CRS-4664: Node host02 successfully pinned.
root@host01 # ./olsnodes -t -n
host01 1 Pinned
host02 2 Pinned
Tried Solution 2:
crsctl getperm res ora.orcldb.db
Solution 3 (worked):
run the srvctl relocate command as root user.
-bash-4.1$ srvctl status database -d orcldb
Instance orcldb_2 is running on node host02
Online relocation: ACTIVE
Source instance: orcldb_2 on host02
Destination instance: orcldb_1 on host01
