Visit Counter

Sunday, November 30, 2014

ORA-16024 - parameter string cannot be parsed



ORA-16024 - parameter string cannot be parsed

Cause - The value for the specified LOG_ARCHIVE_DEST_n (n = 1...5) parameter could not be parsed.
Common causes for this error are a misplaced equal sign, an unrecognized option, or an option that is missing a required value.

Action - Correct the value for the LOG_ARCHIVE_DEST_n parameter




Another Cause: 

I created pfile from spfile on production server for standby database.
Actually I didn't transfer pfile through FTP..I transfer file through copy/paste using NAS.
It transfered the pfile but when I start the database given above error...I googled checked all solution but it didn't work. I again transfer pfile through FTP then it resolved.



Monday, November 24, 2014

Find a File by Name in UNIX, Solaris, or Linux




Using the find command, one can locate a file by name.

To find a file such as filename.txt anywhere on the system:

# find  /  -name   filename.txt  -print


# find /export/home  -name  core   -print



/export/home/bsp/core
/export/home/alauddin/core
/export/home/khalil/core
/export/home/ashif/core
/export/home/rmohan/core
/export/home/arsalan/core
/export/home/edu/core
/export/home/ayman1/core
/export/home/crizaldo/core
/export/home/farooqa/core
/export/home/roger/core
/export/home/iype/core
/export/home/jamsheer/core
/export/home/farhat/core
/export/home/kamar/core
/export/home/karim/core
/export/home/khaja/core
/export/home/bokka/core
/export/home/libin/core
/export/home/ouseph/core
/export/home/moamen/core
/export/home/murali/core
/export/home/mnabil/core
/export/home/pradeep/core
/export/home/pradeepa/core
/export/home/greg/core
/export/home/ronnie/core
/export/home/muneer/core
/export/home/micheal/core
/export/home/essa/core
/export/home/anshad/core
/export/home/vinesh/core
/export/home/ummar/core
/export/home/victor/core
/export/home/waseem/core
/export/home/ajith/core
/export/home/elefatih/core
/export/home/gireesh/core
/export/home/kunhi/core
/export/home/jaison/core
/export/home/mhassan/core





Wednesday, November 5, 2014

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



When I try to connect as sysdba getting below error.


SQL> CONN / AS SYSDBA

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



Set the environment variables.



Solution:

 $ORACLE_HOME=/ora/oracle/test
 $ export ORACLE_HOME

 $ ORACLE_SID=oratest
 $ export ORACLE_SID