Friday, September 24, 2004

Reinstall Notes part 2

I found where those names and numbers are taken from. There's an "inventory" located in ... C:\Program Files\Oracle\! I was sure there's only c:\oracle. So i renamed that folder to Oracle_, but when i ran OUI again, it still offered me creating the new home in Db_3. So i deleted all oracle directories on all drives. On one hand it feels literally creepy that Oracle creeps in all corners of my computer -- file system, registry, environment variables, and God knows where else, but on the other hand it is well documented, if you know how to use the docs, of course.

Eventually i installed it using the basic method and called the starter database "OrclStrt".

The installation process, including database creation took about half an hour.

The output at the end:

The following J2EE Applications have been deployed and are accessible
at the URLs listed below.

Your database configuration files have been installed in
C:\oracle\product\10.1.0 while other components selected for
installation have been installed in C:\oracle\product\10.1.0\Db_1.
Be cautious not to accidentally delete these configuration files.

Ultra Search URL:
http://sugarcube:5620/ultrasearch

Ultra Search Administration Tool URL:
http://sugarcube:5620/ultrasearch/admin

iSQL*Plus URL:
http://sugarcube:5560/isqlplus

Enteprise Manager 10g Database Control URL:
http://sugarcube:5500/em

It's really important to know how to access the Enteprise (sic) Manager. Pressing the "Exit" button pops a "Do you really want to exit?" dialog. Funny -- there's not much else to do at this point.

After exiting the web-based Enterprise Manager (EM from now on) appears asking for username and password, then there's an obscure license, to which i, of course, agree, and finally the OrclStrt database summary with all the options -- Maintenance, Performance, Management etc. I wonder why didn't it work smoothly the first time around. Oh, and for some reason there's an untitled Java window saying: "VTA-1000: The browser could not be launched with the file of URL: http://sugarcube:5500/em". But it was launched. Whatever.

Before i reboot, these are the Windows services created:

  1. OracleCSService
  2. OracleDBConsoleOrclStrt
  3. OracleJobSchedulerORCLSTRT (Disabled)
  4. OracleOraDb10g_home1iSQL*Plus
  5. OracleOraDb10g_home1SNMPPeerEncapsulator (Manual)
  6. OracleOraDb10g_home1SNMPPeerMasterAgent (Manual)
  7. OracleOraDb10g_home1TNSListener
  8. OracleServiceORCLSTRT

All of them are set to Automatic and started, unless otherwise noticed. I hope that after the reboot there won't be anything weird, like the first time ... i admit that maybe it's because i screwed around back then.

In the Home screen of the EM i already see two alerts: the CPU is at 100%, because of Folding@Home and there is only 10.64% available space on filesystem E:\. I wonder if these are configurable somehow, because both are fine with me. I don't even understand why does the EM care about filesystem E:\ at all -- the datafiles are on C:\.

Anyway, i'm going to shut the computer down now and go to sleep. It looks good and i don't want to ruin anything. Tomorrow i'll start fresh and face the terrible truth ... or something.

No comments: