The installation of Oracle 11g R2 .. went on smoothly ..
except for database migration..
so we start the database from scratch and import back data from previous database backup.
It sort out the necessary conversion accordingly.
Checking the oracle version is as such..
su - oracle sqlplus / as SYSDBA;
followed by some SQL.
SELECT * FROM v$version;
.. it doesn’t allow any new connection from remote..
But still can connect to it locally..
It complaining something about communication end-of-file.. some realm memory insufficient..
Later we found out that the archiver already used up the flash_recovery_disk space.. !!
so .. after digging out .. looking around..
we found the solution.. as we actually had more space on the disk.. only the limit is the config.
So we increase the flash recovery disk size with the following command :
su - oracle sqlplus / as SYSDBA
Followed by the …
ALTER system SET db_recovery_file_dest_size=200g scope=BOTH;
Woohoo.. ! after that .. it back to normal again..
su - oracle emctl start dbconsole netca dbca
hehe.. in case need to use that later.. 😎