Error:
ORA-01127 database name ‘string‘ exceeds size limit of string characters
Reason:
The specified database name is too long.
Action:
Shorten the database name to eight characters or less.
Error:
ORA-01127 database name ‘string‘ exceeds size limit of string characters
Reason:
The specified database name is too long.
Action:
Shorten the database name to eight characters or less.
Error:
Error DRG-10700: preference does not exist: CTXSYS.DEFAULT_LEXER
Reason:
This error indicates that you do not have any preferences installed. When installing the Oracle® server software, the InterMedia should get installed automatically with the default preferences. These are dependent on the operating system language. You can install the French preference if the language of your Oracle server is French, or the English one if the language of your Oracle server is English.
Action:
Install the appropriate language-specific default preferences. There are scripts in …/ctx/admin/defaults which create language-specific default preferences. They are named in the form of drdefXX.sql, where XX is the language code (from the Server Reference Manual).
To install the US defaults, for instance:
sqlplus ctxsys/<password> @defaults/drdefus.sql
To install the French defaults, for instance:
sqlplus ctxsys/<password> @defaults/drdeffrc.sql
Grant ‘all privileges’ to ctxsys within Oracle.
After these steps, the InterMedia Context server should start.
Error:
ORA-00257: archiver error. Connect internal only, until freed.
Reason:
File recovery area is above specified size.
Action:
Without increasing DB_RECOVERY_FILE_DEST_SIZE :
1. Check whether the database is in archive log mode and automatic archiving is enabled.
SQL> archive log list; Database log mode Archive Mode Automatic archival Enabled Archive destination USE_DB_RECOVERY_FILE_DEST Oldest online log sequence 29 Next log sequence to archive 31 Current log sequence 31
2. If archive destination is defined by USE_DB_RECOVERY_FILE_DEST, find the archive destination by:
SQL> show parameter db_recovery_file_dest; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ db_recovery_file_dest string C:oracleproduct10.2.0/flash_recovery_area db_recovery_file_dest_size big integer 2G
Check what the value for db_recovery_file_dest_size.
3. Find the space used in flash recovery area by using following SQL:
col ROUND(SPACE_LIMIT/1048576) heading “Space Allocated (MB)” format 999999 col round(space_used/1048576) heading “Space Used (MB)” format 99999 col name format a40 select name, round(space_limit/1048576) As space_limit,round(space_used/1048576) As space_used from v$RECOVERY_FILE_DEST;
4. If SPACE_USED is equal to SPACE_LIMIT of db_recovery_file_dest, move the archive logs to different destination.
5. Archive all the log files
SQL> alter system archive log all;
6. Just switch the logs to verify
SQL> alter system switch logfile;
7. DB_RECOVERY_FILE_DEST_SIZE is to delete (archive log) files from DB_RECOVERY_FILE_DEST if you are sure you have backups and the archived logs are no longer necessary.
$rman target / RMAN>delete archivelog until time ‘SYSDATE-1’; or, RMAN>delete archivelog all;
By increasing DB_RECOVERY_FILE_DEST_SIZE :
SQL> show parameter db_recovery_file_dest;
NAME TYPE VALUE
———————————— ———– ——————————
db_recovery_file_dest string C:oracleproduct10.2.0/flash_recovery_area
db_recovery_file_dest_size big integer 2G
Check what the value for db_recovery_file_dest_size.
Increase the Flash Recovery Area
SQL> ALTER SYSTEM SET db_recovery_file_dest_size=’10G’ SCOPE=BOTH;
Sytem Altered.
http://itnewscast.com/database/error-ora-00257-archiver-error-connect-internal-only-until-freed
http://oraworks.wordpress.com/2011/08/08/ora-00257-archiver-error-connect-internal-only-until-freed/
Error:
Oracle Error :: ORA-00271
there are no logs that need archiving
Reason:
An attempt was made to archive the unarchived redo log files manually, but there are no files that need to be archived.
Action:
No action required.
Error:
ORA-00371 (ORA-371)
Text: not enough shared pool memory, should be at least %s bytes
Reason:
Init.ora parameter shared_pool_size is too small
Action:
Increase the parameter value