ORA-00257ORA-16038ORA-12162 error records

ORA-00257ORA-16038ORA-12162 error records

ORA-00257 ORA-16038 ORA-12162 error history

1. ORA-00257 Solution
Cause: insufficient space error
Solution: Check the storage space of data files and log files. If any problem is found, add the corresponding data files or reconfigure the archive path for archiving logs.
Note: In 10 Gb or later versions, it may be because the flash log file (2 GB by default) is insufficient.
Solution 1: Disable the log flash Function
Alter database flashback off;
Solution 2: increase the size of the flash Log File
Alter system set DB_RECOVERY_FILE_DEST_SIZE = 10g
Solution 3: Modify the flash log file to a large directory.
Alter system set db_recovery_file_dest = '/u01/app/Oracle/flash_recovery_area'

2. ORA-16038: log 3 serial number 5035 cannot be archived
ORA-19809: exceeds the limit on the number of recovery files
ORA-00312: Online log 3 thread 1:
...... REDO03.LOG
This error occurs when the database is started.
Cause: data files in log group 3 are damaged or lost.
Solution:
1. view the alter File
2. query the v $ log view to determine whether to archive the log file.
3. If the file has been archived
Use the CLEAR command to recreate the log file
Alter database clear logfile group 3;
4. Archive before Archiving
Alter database clear unarchived logfile group 3;
5. Start the database
Alter database open;

3. ORA-12162: TNS: net service name is incorrectly specified
The above error occurs when the database is newly installed and sqlplus is used for connection.
Cause: the environment variable ORACLE_SID is not set.
Solve vi. profile
Export ORACLE_SID = orcl

4. TNS-12555: TNS: permission denied error solution
Symptom: Installing the 11g r2 grid
TNS-12555: TNS: permission denied
TNS-12560: TNS: protocol adapter error
TNS-00525: Insufficient privilege for operation
Linux Error: 1: Operation not permitted
Solution:
Chmod 777/var/tmp/. oracle

TNS-12547: TNS: lost contact
Phenomenon: TNS-12547: TNS: lost contact
TNS-12560: TNS: protocol adapter error
TNS-00517: Lost contact
Linux Error: 104: Connection reset by peer
Solution: add in/etc/hosts
127.0.0.1 localhost

Install Oracle 11gR2 (x64) in CentOS 6.4)

Steps for installing Oracle 11gR2 in vmwarevm

Install Oracle 11g XE R2 In Debian