800xA IMS how to change/repair oracle user settings/location of DB
So, trying to fix one problem, I have managed to completely mess up IMS. Maybe it has to do with adding/removing the computer from the domain, or some other user setting, but now hsDbMaint cannot access oracle database. Also history service in PAS reports "oracle instance not available".
How to configure oracle user settings and oracle database path?
Voted best answer
Oracle need all its database files to go online; maybe you have accidentally made one or more unavailable?
By checking the ALERT file you can probably find out if you are simply missing a file after a disk drive partition renaming, etc.:
Below, an example of how a corrupted database file might show up in the ALERT file:
Errors in file c:\oracle\\admin\adva\bdump\adva_ckpt_2828.trc:
ORA-00202: controlfile: 'C:\ORACLE\ORADATA\ADVA\CONTROL02.CTL'
ORA-27091: skgfqio: unable to queue I/O
ORA-27070: skgfdisp: async read/write failed
OSD-04006: ReadFile() failure, unable to read from file
O/S-Error: (OS 23) Data error (cyclic redundancy check).
NOTE: All database files must come from the very same moment in time; you can't just pull one file out of 15 from an old drive image backup, etc. Also, there is probably no reason to revert the DB back to a 12 months old backup of all files since all configuration work made since then may cause conflicts if blended with today's aspect directory.
Do you have any IM backup (hsBAR.exe) to restore? It would probably save your day...
If not, your only option might be to erase the old corrupt database instance and create a new. Log Configurations will be synchronized with the aspect directory so no config is lost; but all logged data will be erased and all logs will start collecting from scratch once you have activated them with the IM Log List tool.
To put your damaged instance down you may have to resort to command line tools unless the Oracle Instance Wizard allows you to drop it.
C:\> oradim -DELETE -SID adva
Once the old instance has been dropped or "put down", you can use the Oracle Instance Wizard to create a new database.
This is detailed in the IM Configuration User's Guide and briefly touched in the Post Installation Guide: