Category Archives: Linux - Page 4

Unable to make a network connection

Posted by on October 6, 2009 No comments

Problem: When configuring Workflow Mailer, and no password is entered for the Inbound Mailer Server (IMAP), the instance pauses for a few seconds, then returns:

Unable to make a network connection

Solution:

If a valid mail server is entered into the Inbound Server Name under Inbound Email Account, but invalid username and password is entered, the following message appears:

Unable to connect to the mail account. Check the host, user name and password.

If a valid mail server is entered into the Inbound Server Name under Inbound Email Account, and a valid username and password is entered, the following message appears:

Validation

Need to put a valid username and password into the Inbound Server Name.

Ensure that the Test Email Address and Reply-To email addresses are different.

e.g. dbadmin@school.com, surajini.shrivastav@school.com

adalnctl.sh: exiting with status 127

Posted by on September 3, 2009 No comments

Problem: After installing 11.5.9 Vision instance, the apps listener exits with status 127.

Solution: Apply operating system patch 3830807

Metalink Reference:

Subject:  Attempt To Start Listener Exits With Status 127

Doc ID:  299810.1

AutoConfig is exiting with status 4 installing 11.5.9

Posted by on September 1, 2009 No comments

Problem:

[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>
[INSTANTIATE PHASE]
AutoConfig could not successfully instantiate the following files:
Directory: /u0/oracle/TEST3/test3db/9.2.0/md/demo/orascv/doc
OraSCV.asc              INSTE8
Directory: /u0/oracle/TEST3/test3db/9.2.0/oem_webstage/readme
emreadme.txt            INSTE8
Directory: /u0/oracle/TEST3/test3db/9.2.0/relnotes/em
README_EM.txt           INSTE8
Directory: /u0/oracle/TEST3/test3db/9.2.0/sysman/doc/readme
README_em.txt           INSTE8
AutoConfig is exiting with status 4

Solution: Unset the LANG environment variable.

Metalink Reference:

Subject:  Sun.io.MalformedInputException For OraSCV.asc,emreadme.txt, README_EM.txt And README_em.txt While 11.5.9 Install

Doc ID:  262125.1

jre was not found in oracle.swd.jre/bin/i386/native_threads/jre

Posted by on August 31, 2009 No comments

Problem: After installing Oracle 9.2.0.4, netca and dbca fail with error:

jre was not found in:

/u01/app/oracle/oracle.swd.jre/bin/i386/native_threads/jre

Solution: Change directory to:

/u01/app/oracle/oracle.swd.jre/bin/i386/native_threads

Then create symbolic link to jre:

ln -s java jre

netca can now be launched.

Error in invoking target install of makefile ins_plsql.mk

Posted by on August 31, 2009 No comments

Problem:

While installing Oracle 9.2.0.4 on Oracle Enterprise Linux 4 Update 4, the following error appears:

Error in invoking target install of makefile
/u01/app/oracle/plsql/lib/ins_plsql.mk

Solution:

Applied patch 4198954 (COMPATIBILITY PACKAGES FOR ORACLE ON RHEL 4)

Applying patch 4198954 resolved the installation error.

Insufficient privileges to write to the specified path in component Database Configuration Assistant 9.2.0.1

Posted by on August 31, 2009 No comments

Problem: While installing Oracle 9.2.0.4 for Linux, the following error appears in RunInstaller:

Error: You do not have sufficient privileges to write to the specified path. In component Database Configuration Assistant 9.2.0.1.0. Installation cannot continue for this component.

Solution: Export ORACLE_BASE:

export ORACLE_BASE=/u01/app/oracle

Exporting ORACLE_BASE resolved the issue.

Subject: Linux 9.2.0.4 Installation – Error: You do not have sufficient privileges to write to the specified path in Database Configuration Assistant Component (Doc ID: 267171.1)

GLIBC_2.0 not defined in file libc.so.6

Posted by on August 31, 2009 No comments

Problem: While installing Oracle 9.2.0.4 on Oracle Enterprise Linux 4 Update 4, the following error appears:

Error occurred during initialization of VM

Unable to load native library: /tmp/OraInstall2009-08-31_01-27-21PM/jre/lib/i386/libjava.so:

symbol __libc_wait, version GLIBC_2.0 not defined in file libc.so.6 with link time reference

Solution: Apply patch 3006854.

Metalink Reference:

Subject: RUNINSTALLER FAILS ON RED HAT 3 TRYING TO INSTALL ORACLE9I

Doc ID: 264178.1

emctl not starting Timezone mismatch agentTZRegion

Posted by on August 30, 2009 No comments

Problem: When starting emctl for first time after reboot on Linux, the following message appears:

Timezone mismatch: The agentTZRegion value (GMT) in /u01/app/oracle/product/10.2.0/db_1/localhost.localdomain_ORCL/sysman/config/emd.properties does not match the current environment TZ setting().

The dbconsole cannot run with this mismatch.

Solution:

Run:

emctl resetTZ agent

Then run:

emctl start dbconsole

You may need to stop the agent (but it says it is not running):

emctl stop agent

ORA-12162: TNS:net service name is incorrectly specified

Posted by on August 30, 2009 No comments

Problem: When attempting to log on to SQL*Plus as ”/ as sysdba’, the following error appears:

ERROR:
ORA-12162: TNS:net service name is incorrectly specified

Solution: Set ORACLE_SID=ORCL

export ORACLE_SID=ORCL

RC-50004: Fatal: Error occurred in ApplyDatabase: Control file creation failed

Posted by on May 27, 2009 1 comment

Problem:

When cloning the database tier of Illuminat HRMS Production, the process fails on 70% with error:

Beginning database tier Apply - Wed May 27 10:12:21 2009
Log file located at /u0/oracle/TEST2/test2db/9.2.0/appsutil/log/TEST2_ebusinesstest/ApplyDBTier_05271012.log
RC-50004: Fatal: Error occurred in ApplyDatabase:
Control file creation failed
ERROR while running Apply...
 ERROR: Failed to execute adclone.pl
 Please check logfile.
Log file /u0/oracle/TEST2/test2db/9.2.0/appsutil/log/TEST2_ebusinesstest/ApplyDBTier_05271012.log showed:
---------------------------------------------------------------
                   ADX Database Utility
---------------------------------------------------------------
getConnectionUsingAppsJDBCConnector() -->
    APPS_JDBC_URL='null'
    Trying to get connection using SID based connect descriptor
getConnection() -->
    sDbHost    : ebusinesstest
    sDbDomain  : illuminatnm.com
    sDbPort    : 1523
    sDbSid     : TEST2
    sDbUser    : APPS
    Trying to connect using SID...
getConnectionUsingSID() -->
    JDBC URL: jdbc:oracle:thin:@ebusinesstest.illuminatnm.com:1523:TEST2
    Exception occurred: java.sql.SQLException: ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory
    Trying to connect using SID as ServiceName
getConnectionUsingServiceName() -->
    JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ebusinesstest.illuminatnm.com)(PORT=1523))(CONNECT_DATA=(SERVICE_NAME=TEST2)))
    Exception occurred: java.sql.SQLException: ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory
    Trying to connect using SID as ServiceName.DomainName
getConnectionUsingServiceName() -->
    JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ebusinesstest.illuminatnm.com)(PORT=1523))(CONNECT_DATA=(SERVICE_NAME=TEST2.illuminatnm.com)))
    Exception occurred: java.sql.SQLException: Io exception: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=153092864)(ERR=12514)(ERROR_STACK=(ERROR=(CODE=12514)(EMFI=4))))
    Connection could not be obtained; returning null
-------------------ADX Database Utility Finished---------------
adcrdb.sh started at Wed May 27 10:54:18 AST 2009
The environment settings are as follows ...
       ORACLE_HOME : /u0/oracle/TEST2/test2db/9.2.0
        ORACLE_SID : TEST2
          TWO_TASK :
              PATH : /u0/oracle/TEST2/test2db/9.2.0/Apache/perl/bin:/u0/oracle/TEST2/test2db/9.2.0/bin:/usr/bin:/usr/sbin:/u0/oracle/TEST2/test2db/9.2.0/jdk/bin:/usr/ccs/bin:/bin:/usr/bin/X11:/usr/local/bin:../jre/1.3.1/bin:/u0/oracle/testdb/9.2.0/Apache/perl/bin:/usr/kerberos/bin:/sbin:/usr/sbin:/bin:/usr/bin:/usr/X11R6/bin:.
   LD_LIBRARY_PATH : /u0/oracle/TEST2/test2db/9.2.0/lib:/usr/X11R6/lib:/usr/openwin/lib:/u0/oracle/TEST2/test2db/9.2.0/ctx/lib
Executable : /u0/oracle/TEST2/test2db/9.2.0/bin/sqlplus
The log information will be written to
        /u0/oracle/TEST2/test2db/9.2.0/appsutil/log/TEST2_ebusinesstest/adcrdb_TEST2.txt
Creating the control file for TEST2_ebusinesstest database ...
SQL*Plus: Release 9.2.0.3.0 - Production on Wed May 27 10:54:18 2009
Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.
Connected to an idle instance.
ORACLE instance shut down.
Connected to an idle instance.
ORACLE instance started.
Total System Global Area  581506100 bytes
Fixed Size                   451636 bytes
Variable Size             402653184 bytes
Database Buffers          167772160 bytes
Redo Buffers               10629120 bytes
Control file created.
Database altered.
Tablespace altered.
Database altered.
Database closed.
Database dismounted.
ORACLE instance shut down.
Connected to an idle instance.
ORACLE instance started.
Total System Global Area  581506100 bytes
Fixed Size                   451636 bytes
Variable Size             402653184 bytes
Database Buffers          167772160 bytes
Redo Buffers               10629120 bytes
Database mounted.
BEGIN dbms_backup_restore.zeroDbid(0); END;
*
ERROR at line 1:
ORA-01119: error in creating database file
'/u0/oracle/TEST2/test2db/9.2.0/dbs/MISSING00395'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
ORA-06512: at "SYS.X$DBMS_BACKUP_RESTORE", line 3284
ORA-06512: at line 1
ORACLE instance shut down.
Connected to an idle instance.
ORACLE instance started.
Total System Global Area  581506100 bytes
Fixed Size                   451636 bytes
Variable Size             402653184 bytes
Database Buffers          167772160 bytes
Redo Buffers               10629120 bytes
Control file created.
Database altered.
Tablespace altered.
Database altered.
old   2:     '/u0/oracle/TEST2/test2db/9.2.0/ctx/lib/libctxx9.&libext'
new   2:     '/u0/oracle/TEST2/test2db/9.2.0/ctx/lib/libctxx9.so'
Library created.
old   2:     '/u0/oracle/TEST2/test2db/9.2.0/lib/libqsmashr.&libext'
new   2:     '/u0/oracle/TEST2/test2db/9.2.0/lib/libqsmashr.so'
Library created.
old   2:     '/u0/oracle/TEST2/test2db/9.2.0/lib/libordim9.&libext'
new   2:     '/u0/oracle/TEST2/test2db/9.2.0/lib/libordim9.so'
Library created.
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.3.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.3.0 - Production
exit_code=0
Checking for errors ...
ORA-01119: error in creating database file
ORA-27037: unable to obtain file status
ORA-06512: at "SYS.X$DBMS_BACKUP_RESTORE", line 3284
ORA-06512: at line 1
The database has not been successfully created. Shutting down the instance ...
SQL*Plus: Release 9.2.0.3.0 - Production on Wed May 27 10:57:56 2009
Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.
Connected.
ORACLE instance shut down.
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.3.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.3.0 - Production
.end std out.
.end err out.
---------------------------------------------------------------
                   ADX Database Utility
---------------------------------------------------------------
getConnectionUsingAppsJDBCConnector() -->
    APPS_JDBC_URL='null'
    Trying to get connection using SID based connect descriptor
getConnection() -->
    sDbHost    : ebusinesstest
    sDbDomain  : illuminatnm.com
    sDbPort    : 1523
    sDbSid     : TEST2
    sDbUser    : APPS
    Trying to connect using SID...
getConnectionUsingSID() -->
    JDBC URL: jdbc:oracle:thin:@ebusinesstest.illuminatnm.com:1523:TEST2
    Exception occurred: java.sql.SQLException: ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory
    Trying to connect using SID as ServiceName
getConnectionUsingServiceName() -->
    JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ebusinesstest.illuminatnm.com)(PORT=1523))(CONNECT_DATA=(SERVICE_NAME=TEST2)))
    Exception occurred: java.sql.SQLException: ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory
    Trying to connect using SID as ServiceName.DomainName
getConnectionUsingServiceName() -->
    JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ebusinesstest.illuminatnm.com)(PORT=1523))(CONNECT_DATA=(SERVICE_NAME=TEST2.illuminatnm.com)))
    Exception occurred: java.sql.SQLException: Io exception: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=153092864)(ERR=12514)(ERROR_STACK=(ERROR=(CODE=12514)(EMFI=4))))
    Connection could not be obtained; returning null
-------------------ADX Database Utility Finished---------------
RC-00118: Error occurred during creation of database
Raised by oracle.apps.ad.clone.ApplyDatabase
StackTrace:
java.lang.Exception: Control file creation failed
        at oracle.apps.ad.clone.ApplyDatabase.<init>(ApplyDatabase.java:469)
        at oracle.apps.ad.clone.ApplyDatabase.<init>(ApplyDatabase.java:314)
        at oracle.apps.ad.clone.ApplyDatabase.<init>(ApplyDatabase.java:290)
        at oracle.apps.ad.clone.ApplyDBTier.<init>(ApplyDBTier.java:131)
        at java.lang.reflect.Constructor.newInstance(Native Method)
        at oracle.apps.ad.clone.util.CloneProcessor.run(CloneProcessor.java:68)
        at java.lang.Thread.run(Thread.java:479)

Solution:

The cloning process omits two files that were created since the last adpreclone.pl run. Therefore, run preclone scripts (adpreclone.pl) on the production instance before copying files.

[amazon asin=0070077290&template=iframe image&chan=default]    [amazon asin=1453742735&template=iframe image&chan=default]    [amazon asin=0615238440&template=iframe image&chan=default]