Wednesday 24 June 2015

DB : Could not execute auto check for display colors using command /usr/bin/xdpyinfo. Check if the DISPLAY variable is set. Failed

Error:
oratest@myserver database]$ ./runInstaller
Starting Oracle Universal Installer...

Checking Temp space: must be greater than 120 MB.   Actual 61931 MB    Passed
Checking swap space: must be greater than 150 MB.   Actual 19999 MB    Passed
Checking monitor: must be configured to display at least 256 colors
    >>> Could not execute auto check for display colors using command /usr/bin/xdpyinfo. Check if the DISPLAY variable is set.    Failed <<<<

Some requirement checks failed. You must fulfill these requirements before

continuing with the installation,

Continue? (y/n) [n] n

User Selected: No

Exiting Oracle Universal Installer, log for this session can be found at /d01/oracle/app/oraInventory/logs/installActions2015-06-24_10-03-30AM.log
[oratest@myserver database]$

Solution:

As a root user in VNC type xhost + to continue the installation
[root@myserver TEST]# xhost +
access control disabled, clients can connect from any host

DB : Installing oracle database fails with inventory owner permission denied

When installing new database as "oratest" new user on the existing server with other databases running in it the installation failed with below error

Error:

[oratest@myserver database]$ ./runInstaller
You do not have sufficient permissions to access the inventory '/d01/oracle/app/oraInventory'. Installation cannot continue. It is required that the primary group of the install user is same as the inventory owner group. Make sure that the install user is part of the inventory owner group and restart the installer.: Permission denied
[oratest@myserver database]$

Solution:
Change the oratest user group to same as the group of oraInventory

As a root user change the "oratest" group to "dba" as below

useradd -G dba oratest

Monday 8 June 2015

EBS : dbTier autoconfig fails with afdbprf.sh adcrobj.sh

Error:

adcvmlog.xml renamed to /oradb/oracle/11.2.0.3/appsutil/log/TEST_drebsdb01/06080947/adcvmlog.xml.06080948


[AutoConfig Error Report]
The following report lists errors AutoConfig encountered during each
phase of its execution.  Errors are grouped by directory and phase.
The report format is:
      <filename>  <phase>  <return code where appropriate>

  [PROFILE PHASE]
  AutoConfig could not successfully execute the following scripts:
    Directory: /oradb/oracle/11.2.0.3/appsutil/install/TEST_drebsdb01
      afdbprf.sh              INSTE8_PRF         1

  [APPLY PHASE]
  AutoConfig could not successfully execute the following scripts:
    Directory: /oradb/oracle/11.2.0.3/appsutil/install/TEST_drebsdb01
      adcrobj.sh              INSTE8_APPLY       1


AutoConfig is exiting with status 2

AutoConfig execution completed on Mon Jun  8 09:48:27 2015

Time taken for AutoConfig execution to complete : 0 mins  49 secs


Solution:

Enter the correct apps password while running autoconfig and check whether APPS account is locked by connecting as SYSDBA
SQL> select USERNAME,ACCOUNT_STATUS,LOCK_DATE from dba_users where USERNAME='APPS';

USERNAME                       ACCOUNT_STATUS                   LOCK_DATE
------------------------------ -------------------------------- ---------------
APPS                           LOCKED                           08-JUN-15

SQL> alter user apps account unlock;

User altered.

SQL> select USERNAME,ACCOUNT_STATUS,LOCK_DATE from dba_users where USERNAME='APPS';

USERNAME                       ACCOUNT_STATUS                   LOCK_DATE
------------------------------ -------------------------------- ---------------
APPS                           OPEN

now re-run the autoconfig in dbTier

SQL Developer displaying Junk characters (??????)

Change the Encoding in SQL Developer Preferences as below Tools --> Preferences --> Environment --> Encoding --> UTF...