Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> OEM Problem NMS-01018
Hi there.
I'm using the Oracle Enterprise Manager 9.2.0.1.0 and tried to check for blocks on some databases (8.0.6.1.0 to 8.1.7.0.0 db's) and I get the error NMS-01018 on some of them. It says I should run the smptsixx.sql where xx stands for the version I'm using (it creates the view sys.dba_blockers) but I cannot find those smptsixx.sql files. The docu says their should be in $ORA_HOME\sysman\admin but I cannot find them, neither on the database server, neiter on the Oracle Enterprise Manager Server nor on the OEM Console machine.
What am I missing here? Where can I find those smptsixx.sql files?
-- mfg Marc EggenbergerReceived on Wed Jul 23 2003 - 04:00:57 CDT
![]() |
![]() |