ORA-01595: error freeing extent (3) of rollback segment

Problem:
------------

SMON: following errors trapped and ignored:
ORA-01595: error freeing extent (3) of rollback segment (198))
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [4194], [12], [2], [], [], [], [


Solution:
-----------
Adding more undo space should solve the problem.


Following link explain add undo tablespace:
-------------------------------------------

http://dbafix.blogspot.com.tr/2010/08/how-to-drop-and-recreate-undo.html

ORA-21561: OID generation failed

Problem:
-----------

ORA-21561: OID generation failed


Solution:
-----------


Check that there is client machine fully qualified name and short name in the client machine hosts file. If these are missing you’ll get ORA-21561 errors when trying to connect server.

old           /etc/hosts   file
-------------------------
127.0.0.1            localhost.localdomain      localhost

new           /etc/hosts   file
-------------------------

127.0.0.1            localhost.localdomain      localhost
10.160.116.10   dbachannel.oracle.com     dbachannel-----this line added

sqlplus: error while loading shared libraries: libsqlplus.so: cannot open shared object file: No such file or directory

Problem:
-----------


./sqlplus: error while loading shared libraries: libsqlplus.so: cannot open shared object file: No such file or directory



Solution:
-----------


vi .bash_profile

export LD_LIBRARY_PATH=$ORACLE_HOME/lib

save and quit.

Then relogin

Problem will solve.

ORA-16179: incremental changes to "log_archive_dest_1" not allowed with SPFILE

Problem:
----------


ORA-16179: incremental changes to "log_archive_dest_1" not allowed with SPFILE

Solution:
--------


Your syntax is incorrect

Correct syntax is:


alter system set log_archive_dest_1='location=PATH' scope=SPFILE

ORA-39095: Dump file space has been exhausted : Unable to allocate 8192 bytes

Problem:
------------


ORA-39095: Dump file space has been exhausted: Unable to allocate 8192 bytes


Solution:
------------



1. Decrease your parallel number

Or:

2. Don't use PARALLEL clause.

LRM-00108: invalid positional parameter value 'sysdba'

Problem:
-----------

LRM-00108: invalid positional parameter value 'sysdba'


Solution:
-----------

You have to use below syntax:


expdp \'/ as sysdba\' 


example:


expdp \'/ as sysdba\' DIRECTORY= EXPDP_DIR DUMPFILE=NECO.dmp LOGFILE=expdpNECO.log schemas=NECO exclude=STATISTICS content=ALL parallel=8

ld.so.1: sqlplus: fatal: libsqlplus.so: open failed: No such file or directory

Problem:
--------

ld.so.1: sqlplus: fatal: libsqlplus.so: open failed: No such file or directory


Solution:
---------

Add following line in your .profile.

########################################
   
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
     
#########################################