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.. 😎
yum install -y mythtv-suites –enablerepo atrpms –enablerepo atrpms-testing
should be
yum install -y mythtv-suite –enablerepo atrpms –enablerepo atrpms-testing
also after yum installing all the mythtv packages:
yum install perl-DBD-MySQL php-mysql mysql mysql-server
chkconfig mysqld on
service mysqld start
mysql -u root mysql
mysql> UPDATE user SET Password=PASSWORD(‘mythtv’) WHERE user=’root’;
mysql> FLUSH PRIVILEGES;
mysql> quit
mysql -u root mysql -p < /usr/share/doc/mythtv-docs-0.21/database/mc.sql
if happened to messed with the frontend..
despite the update..
can just..
“yum install -y mythtv-frontend-0.21-213.el5 –enablerepo atrpms ”
woohoo..
mythTV is back..!
Hey There. I found your blog using msn. This is a really well written article.
I will be sure to bookmark it and return to read more of your
useful info. Thanks for the post. I’ll definitely return.
Victorious one CSN Coyotes basketball group.. alot more energy.