OC4J portal was 'none'

Problem:

We have Oracle Application Server 10g,we shut down the application and rebooted the server which
in application run.But then we can't have start opmn.We we run 'opmnctl startall' OC4J portal
was 'none'.It can't have been alive.

Solution:

ulimit -c unlimited

This command change all limits to unlimited.The problem caused by 'open files' parameter:)

ORA-12560:TNS:protocol adapter error(windows)

While you're logging sys / as sysdba you may get this error on windows


Problem:

ORA-12560:TNS:protocol adapter error

Solution:


C:\>set oracle_sid=necodb

C:\>sqlplus

SQL*Plus: Release 11.2.0.1.0 Production on 17:06:19 2012

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

username : sys as sysdba
password:

connected:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning option

SQL>

If you use unix you follow link below:

http://doganay.wordpress.com/2012/04/03/tns-12555-tns-permission-denied/

ORA-19809: limit exceeded for recovery files

Problem:

Errors in file /home/oracle11g/diag/rdbms/necodb/trace/necodb_arc3_27348.trc:
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 790890496 bytes disk space from 4070572032 limit
ARC3: Error 19809 Creating archive log file to '/home/oracle11g/flash_recovery_area/ANKDB/archivelog/2012_09_07/o1_mf_1_9_%u_.arc'

Solution:

increase DB_RECOVERY_FILE_DEST_SIZE(Database recovery files size limit )

alter system set parameter DB_RECOVERY_FILE_DEST_SIZE=integer;

You don't need to restart the instance,this parameter is dynamic:))

ORA-12162 TNS:net service name is incorrectly specified

Problem:

After you installed ORACLE database,if you want to connect database with sqlplus,you get a this error

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

Solution:

You have to add your database SID in your '.bash_profile' or if you use Solaris file is '.profile'

export ORACLE_SID=<SID>


Good luck:))

Message dictionary couldn't open the CLE application message file.Can't open file $CLE_TOP/mesg/US.msg for reading

Problem:

Message dictionary couldn't open the CLE application message file.Can't open file
$CLE_TOP/mesg/US.msg for reading

Solution:

Navigate to Applications Developer responsibility:
Run concurrent request: Generate Messages, with the following parameters:
Language: US
Application: CLE
Mode: DB_TO_RUNTIME

Then try
cd $CLE_TOP

cd mesg

ls

US.msg is came:))

The following error occurs during execution of apwdame1.sql

Problem:

When attempting to apply Oracle Internet Expenses Mini-pack 11i.OIE.K (4165000)
the following error occurs during execution of apwdame1.sql


Solution:

Apply Patch 4873179 to Application

Re-apply the OIE Patch 4165000

RC-20200: Fatal: Could not find Unzip

Problem:

0% completed RC-20200: Fatal: Could not find Unzip. At this time only Native UnZip 5.X is supported.
Please make sure you have UnZip 5.X in your path and try again.

Solution:

Apply patch 9874305 on Application

Then;

Set your java and unzip in your .profile(bash_profile) file