Oracle system01.dbf空間過大, ORA-00604, ORA-01653, ORA-02002

1. 先看看sys.aud$的空間是否過大, 或是關閉oracle audit機制
alter system set audit_trail=none scope=spfile;
shutdown immediate;
truncate table sys.aud$;
startup;

2. 調整 system01.dbf的檔案大小
alter database datafile '/usr/local/oracle/oradata/ora11g2/system01.dbf' resize 2048M;
alter database datafile '/usr/local/oracle/oradata/ora11g2/system01.dbf' auto extend on next 10M maxsize unlimited;

ORA-28002 密碼過期

SELECT * FROM dba_profiles s WHERE s.profile='DEFAULT' AND resource_name='PASSWORD_LIFE_TIME';

將預設180天改成無限制。
ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;

若不知密碼, 下面查出密碼,  再重新設定一次即可。
select password from $user where name='GS36_MSIG_POC_APP';
alter user GS36_MSIG_POC_APP identified by values '35EE9CA093003211';

Linux Boot Auto Start Oracle Oracle database & emctl

/etc/rc.d/rc.local 檔案內容

su - oracle -c "source /home/oracle/.bash_profile"
su - oracle -c "lsnrctl start"
sleep 5
su - oracle -c "echo startup |sqlplus \"/as sysdba\" "
su - oracle -c "lsnrctl set log_status off"
su - oracle -c " emctl start dbconsole"