Im trrying to run the command below in the sqlplus using sys account, but I'm not successfull
May I know if there a procedure on this , step by step . I'm trying to create account in manual because i'm stack in the console instance console . but when I tried in command I'm getting the same issue ?
Is there a manual in HP that easy to understand and giving the step by step procedure ?
The node i;m working is oracle 10g in windows
enter value for 2: ??? db-spi username (hp_dbspi) ??? db-spi pasword (hp_dbspi) ??? enter value for system_pass: ??? default_ts: ???
Another thiig is there any procedure how to used the below option withm sample , from log-in to oracle DB up to finish ..
REM sqlplus system/<password> @dbspiocr.sql REM sqlplus sys/<password> @dbspiocr.sql REM sqlplus /NOLOG @dbspiocr.sql
Such a ORA-00942 error is quite normal for some tables. The same script is used to create the user for different versions of Oracle, which means that from one version to the other new tables might have been added and others deprecated, meaning that not all tables will exist for all versions of Oracle and such an alert is quite normal.
If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.
The script is located in the instrumentation directory on the agent. It is given as a reference in case you or your DBA would like to review all the permissions given to the Oracle SPI user configured for monitoring.
The script itself will be used by the 'Create Oracle User' application to, as the name itself already explains, create an Oracle User with all specific permissions for monitoring by the Oracle SPI.
If you need help on configuring the DBSPI, please have a look at the installation/configuration guide which contains a step by step list of actions to perform: