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.

First few lines to get familiar with the new Oracle installation ..

Checking the oracle version is as such..

su - oracle
sqlplus / as SYSDBA;

followed by some SQL.

SELECT * FROM v$version;

It shall have something like the following..

At first we thought the 100Gb size limit for flash_recovery_disk is sufficient enough to cover worth of 11Gb.

However… after we perform a backup test.

.. 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..



p/s : .. some other oracle useful command are…

su - oracle
emctl start dbconsole
netca
dbca

hehe.. in case need to use that later.. 😎