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.. 😎
Let’s see how long that WEBSITE WITH XMLTV FILES for MALAYSIA’s ASTRO THAT CAN BE USED ON MYTHTV lasts … 😎
http://www.google.com/search?q=malaysia+astro+mythtv&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:en-US:official&client=firefox-a
keh keh keh keh …
you can also use tv_cat to concatenate multiple xmltv files into one, and pass it to mythfilldatabase in one go.
Got a few other useful tv_* utilities, e.g. tv_to_text.
Having good content can only get you so far unless you also provide a good atmosphere to comment in
I write a music blog for my audience research class. I’m new to blogging and I want them to be good! So any advice you guys could give me would be great
oh.. haven’t done exploring all the utilities
that come with the myth app..
hehe..
google still working even while i was away.. 😎
complex post. upright one detail where I contest with it. I am emailing you in detail.
Guys…. if you look at the Astro website (http://www.astro.com.my) they now publish their complete tv listings (albeit channel by channel) in XML / RSS format. For example TV1 is at http://www.astro.com.my/channels/rtm1/ with the RSS feed being at http://www.astro.com.my/rss/channels.asp?sid=M038. Although I am not as technical as many on this forum, surely this must make life easier?
Chaggy
Great idea chaggy!
I wrote a script to convert the RSS feed(s) on astro’s website into XMLTV for mythtv:
http://dev.abubakar.net/astro2xmltv/
If anyone tries it, let me know how it works. Instructions are at the top of the script.
Astro stopped their RSS feeds some months ago. I wrote yet-another script based on the EPG as of January 2011.
http://home.abubakar.net/pubdocs/ under astro_xmltv.