Forum OpenACS Q&A: upgrading from oracle 8i to 9i or 10g
i really need your help regarding this:
1. While upgrading to 9i, during installtion it prompts for upgrade database, is that good or to upgrade after the installtion?
2. When i click autorun.exe on 10g installtion kit, i am getting error message "Unable to load Resource DLL". Why is this and how to overcome.
*3. Is it required to 9i first and then to 10g or can i directly go to 10g? and how good is 10g (questoning bcoz its quite news)
Hoping you guys can help me..
thanx in advance
I'd recommend picking up some books by Tom Kyte. I'm reading his most recent now, but I'd recommend starting with
Effective Oracle by Design
It's pretty advanced, but really gives you an idea of how you can take advantage of the database..
You seem to be messing with Oracle on Windows. This is the wrong place to ask about that, few folks here use Windows much, and those who do use Windows are probably running PostgreSQL on it, not Oracle.
I have installed and used the Oracle client libraries on Windows. As I recall, the Oracle installers screwed up its Windows file permissions, and the Oracle client stuff (sqlplus, etc.) would not work at all until I manually fixed the Windows file permissions. The Oracle error message also was completely useless, it said nothing at all about file permissions. So, that's one possible snafu to consider...