ORA-00283

Problem:

If you try to recover database you startup database mount mode if not you get this error

ORA-00283

Solution:

shutdown immediate

startup mount

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:))