Archive

Archive for the ‘Real Application Cluster’ Category

Oracle Grid Infrastructure on AIX: “0403-006 Execute permission denied.” during installation of binaries.

Problem description:

While installing Grid Infrastructure on AIX, you are receiving an error when Oracle Universal Installer starts to link the binaries. The OUI log file contains the error message “0403-006 Execute permission denied.”:

INFO: Exception thrown from action: make
Exception Name: MakefileException
Exception String: Error in invoking target 'sdo_on no_opts asm_on rac_on' of makefile '/u01/app/grid/11.2.0/grid/rdbms/lib/ins_rdbms.mk'. See '/u01/app/oraInventory/logs/installActions2011-03-12_11-32-45PM.log' for details.
Exception Severity: 1
INFO: Linking sdo Options
INFO: Linking sdo Options
INFO: The output of this make operation is also available at: '/u01/app/grid/11.2.0/grid/install/make.log'
INFO:
 
INFO: Start output from spawned process:
INFO: ----------------------------------
INFO:
 
INFO:   /bin/ar -X64 cr /u01/app/grid/11.2.0/grid/rdbms/lib/libknlopt.a /u01/app/grid/11.2.0/grid/rdbms/lib/kxmwsd.o
 
INFO: /bin/sh: /u01/app/grid/11.2.0/grid/bin/echodo: 0403-006 Execute permission denied.
 
INFO: make: 1254-004 The error code from the last command is 126.

Cause:
In this case the error message was quite misleading. The problem was not caused by a permission issue. It was introduced by another process using some space on the /tmp file system. Oracle Universal Installer was not able to allocate any further temporary space on the /tmp file system, because it was completely filled up and therefore raised above error message. Even if you would use the environment variables TMPDIR and TEMPDIR, OUI would still use /tmp for some tasks and 1GB of free space would not be enough.

Problem resolution:
Increase the free space on /tmp (2GB of total space should be fine) and press retry in the Oracle Universal Installer or cleanup and restart your installation if you have already cancelled it.

root@aix01 / # df -g /tmp
Filesystem    GB blocks      Free %Used    Iused %Iused Mounted on
/dev/hd3           2.00      1.99    1%      151     1% /tmp
root@aix01 / #

PRKP-1030 / CRS-2632 / CRS-0223 when trying to start database service

Problem description:

You are trying to start your database service(s) after some maintenance work and the following error stack is reported even though your database instances are already up & running:

[oracle@linux01 bin]$ srvctl start service -d mydb
PRKP-1030 : Failed to start the service myappsrv.
CRS-2632: There are no more servers to try to place resource 'ora.mydb.myappsrv.cs' on that would satisfy its placement policy
CRS-0223: Resource 'ora.mydb.myappsrv.cs' has placement error.
[oracle@linux01 bin]$

Cause:
Your database instance(s) are still in RESTRICTED mode.

Problem resolution:
Disable restricted session mode and retry to start your service(s):

  • Disable restricted session mode:
    SQL> ALTER system disable restricted SESSION;
     
    System altered.
     
    SQL>
  • Start your service(s):
    [oracle@linux01 bin]$ srvctl start service -d mydb
    [oracle@linux01 bin]$