Dicas ORACLE DBA

Error: SQL> startup ORA-27102: out of memory SVR4 Error: 22: Invalid argument And the alert log shows something similar to the following. WARNING: EINVAL creating segment of size 0x000000002a000000 fix shm parameters in /etc/system or equivalent Solution: For example, a sample /etc/system entry setting SHMMAX = 6GB. set shmsys:shminfo_shmmax=6442450944 (6*1024*1024*1024) set semsys:seminfo_semmni=1024 set semsys:seminfo_semmsl=1024 set shmsys:shminfo_shmmni=100 (see note id:  169706.1 for solaris requeriments ) Database started with above settings ok, and missing project settings in this case were the following. 1. # projadd -c "Oracle" 'user.oracle' 2. # projmod -s -K "project.max-shm-memory=(privileged,6GB,deny)" 'user.oracle'

Drop datapump external tables: select OWNER,OBJECT_NAME,OBJECT_TYPE, status, to_char(CREATED,'dd-mon-yyyy hh24:mi:ss') created ,to_char(LAST_DDL_TIME , 'dd-mon-yyyy hh24:mi:ss') last_ddl_time from dba_objects where object_name like 'ET$%' / select owner, TABLE_NAME, DEFAULT_DIRECTORY_NAME, ACCESS_TYPE from dba_external_tables order by 1,2 / Doc. ID:  1274653.1