SPI Oracle - dbspiocr.sql manual (879 Views)
Reply
Regular Advisor
Toberts
Posts: 254
Registered: ‎10-21-2007
Message 1 of 9 (879 Views)
Accepted Solution

SPI Oracle - dbspiocr.sql manual

 

HI

 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

 

Pleaser advise,

 
@c:\dbspiocr.sql

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

Trusted Contributor
Mahmoud_Ibrahim
Posts: 113
Registered: ‎03-13-2011
Message 2 of 9 (879 Views)

Re: SPI Oracle - dbspiocr.sql manual

[ Edited ]

Hi

change directory where the sql file is located and run the command as below

sqlplus sys/<password> as sysdba 
@dbspiocr.sql instanceName defaulttablespace

This will execute the and will ask you for the dbspi user and password and the other information.

 

I have replaced the variable in the original sql file

so you can connect to

 

sqlplus sys/<password> as sysdba

Then copy the code from the file and paste it; it will create the user (hp_dbspi) with temp as default tablespace and assign the required permission.

 

Regards,
Mahmoud Ibrahim
http://www.mahmoudthoughts.com
  • Say thanks by clicking the "Kudos! Star" which is on the left.

  • Make it easier for other people to find solutions, by marking my answer with "Accept as Solution" if it solves your issue.
  • Regular Advisor
    Toberts
    Posts: 254
    Registered: ‎10-21-2007
    Message 3 of 9 (879 Views)

    Re: SPI Oracle - dbspiocr.sql manual

    It's work the script but got the below error in some object , due to not exist in my database

    Our Oracle 10g is running in windows 2003 sp2

    Please advise , why geeting this error

     

     


    grant select on V_$COMPATIBILITY to hp_dbspi
    *
    ERROR at line 1:
    ORA-00942: table or view does not exist

    grant select on V_$COMPATSEG to hp_dbspi
    *
    ERROR at line 1:
    ORA-00942: table or view does not exist

    grant select on V_$CURRENT_BUCKET to hp_dbspi
    *
    ERROR at line 1:
    ORA-00942: table or view does not exist

    grant select on V_$LOADCSTAT to hp_dbspi
    *
    ERROR at line 1:
    ORA-00942: table or view does not exist

    grant select on V_$LOADTSTAT to hp_dbspi
    *
    ERROR at line 1:
    ORA-00942: table or view does not exist

    grant select on V_$MTS to hp_dbspi
    *
    ERROR at line 1:
    ORA-00942: table or view does not exist
    .

    grant select on V_$RECENT_BUCKET to hp_dbspi
    *
    ERROR at line 1:
    ORA-00942: table or view does not exist






    Trusted Contributor
    Mahmoud_Ibrahim
    Posts: 113
    Registered: ‎03-13-2011
    Message 4 of 9 (879 Views)

    Re: SPI Oracle - dbspiocr.sql manual

    Hello Again,

     

    The issue of the table or view does not exist is related to permission mainly so you have to ensure that you typed as sysdba and try again

    sqlplus sys/<password> as sysdba

    Another suspesion is that you may need to uses sys. before the view name and type them like

    

    grant select on sys.V_$COMPATIBILITY to hp_dbspi;
    

    grant select on sys.V_$COMPATSEG to hp_dbspi;

    grant select on sys.V_$CURRENT_BUCKET to hp_dbspi;

    grant select on sys.V_$LOADCSTAT to hp_dbspi;
    grant select on
    sys.V_$LOADTSTAT to hp_dbspi;
    grant select on
    sys.V_$MTS to hp_dbspi;
    grant select on sys.V_$RECENT_BUCKET to hp_dbspi;

     

     

     

    If it is not working add quotes

    change

    sys.V_$RECENT_BUCKET

    to

    "sys"."V_$RECENT_BUCKET"

     

    Regards,

    Mahmoud Ibrahim

    http://www.mahmoudthoughts.com

    ---

    • Say thanks by clicking the "Kudos! Star" which is on the left.
    • Make it easier for other people to find solutions, by marking my answer with "Accept as Solution" if it solves your issue.
    Regards,
    Mahmoud Ibrahim
    http://www.mahmoudthoughts.com
  • Say thanks by clicking the "Kudos! Star" which is on the left.

  • Make it easier for other people to find solutions, by marking my answer with "Accept as Solution" if it solves your issue.
  • Regular Advisor
    Toberts
    Posts: 254
    Registered: ‎10-21-2007
    Message 5 of 9 (879 Views)

    Re: SPI Oracle - dbspiocr.sql manual

    Thanks again guy's and let me try again and I'll give you update

     

    Valued Contributor
    thaolv
    Posts: 116
    Registered: ‎05-07-2013
    Message 6 of 9 (515 Views)

    Re: SPI Oracle - dbspiocr.sql manual

    H Mahmoud_Ibrahim,

    I followed your steps, but it's still show me the error "ORA-00942: table or view does not exist". Please help, urgent!!!!

    Thank you
    Trusted Contributor
    UliD
    Posts: 71
    Registered: ‎05-21-2012
    Message 7 of 9 (457 Views)

    Re: SPI Oracle - dbspiocr.sql manual

    Hello Thaolv, 

     

    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.

     

    Hth,

    Uli

    HP Support

    If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.
    Occasional Contributor
    VigneshS3
    Posts: 3
    Registered: ‎01-24-2014
    Message 8 of 9 (399 Views)

    Re: SPI Oracle - dbspiocr.sql manual

    Hi

     

    I am new to DBSPI.

     

    Could someone please help me in step by step procedure of creating a new DBSPI.

     

    All i know is we need to use dbspiocr.sql file, but dont know its location or how it is to be used.

     

    Any help is appreciated.

     

    Thanks

    -Vignesh

    Trusted Contributor
    UliD
    Posts: 71
    Registered: ‎05-21-2012
    Message 9 of 9 (393 Views)

    Re: SPI Oracle - dbspiocr.sql manual

    Hello Vignesh,

     

    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:

     

    OM Windows:

     

    http://support.openview.hp.com/selfsolve/document/KM1076326/binary/SPIDB12.04_Win_InstallConfig.pdf

     

    OM Linux/HP-UX/Solaris:

     

     

    http://support.openview.hp.com/selfsolve/document/KM1030354/binary/SPIDB12.04_InstallConfig

     

    Hth,

    Uli

    HP Support

    If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.
    The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.