I am getting an error with the install. It says DBMS_Profiler does not exist, but it does and I am installing under SYS.

Then when I run the SQL Profiler and try to execute some code I get a Table not found Oracle Error.

Regards
JD

Oracle DBMS_PROFILER package requires several tables which are not installed by default.
Oracle admin directory contains 3 scripts DBMSPBP.SQL, PROFTAB.SQL, and PRVTPDB.PLB for creating and setting up these tables

Please check that you have these tables. If not run PROFLOAD.SQL wich will rebuild the profiler package and tables.

Also make sure you have ORA_MONITOR.PROFILER_DATA table that should be created by the setup.

Here is the scipt that you can use for creating this table manually

create table ora_monitor.profiler_data (

runid number not null primary key,

run_name varchar2(100) check (rtrim(run_name) != null),

start_time date default sysdate not null,

user_runid number default 1 not null,

run_seq integer default 1 not null,

user_sid number not null,

user_name varchar2(30) default user not null,

run_cpu number default 0,

run_io number default 0,

run_memory number default 0,

run_sorts number default 0,

run_sort_ratio number default 0,

run_gets number default 0,

run_status varchar2(12) default 'INCOMPLETE',

session_name varchar2(100) check (rtrim(session_name) != null),

session_comments varchar2(4000),

run_source long);

create index ora_monitor.i_profiler_data on ora_monitor.profiler_data (user_name, session_name);
GRANT SELECT, INSERT, DELETE, UPDATE ON ora_monitor.profiler_data TO PUBLIC;

: I am getting an error with the install. It says DBMS_Profiler does not exist,
: but it does and I am installing under SYS.

: Then when I run the SQL Profiler and try to execute some code I get a Table
: not found Oracle Error.

: Regards
: JD

: Oracle DBMS_PROFILER package requires several tables which are not installed
: by default.
: Oracle admin directory contains 3 scripts DBMSPBP.SQL, PROFTAB.SQL, and
: PRVTPDB.PLB for creating and setting up these tables
: Please check that you have these tables. If not run PROFLOAD.SQL wich will
: rebuild the profiler package and tables.
: Also make sure you have ORA_MONITOR.PROFILER_DATA table that should be
: created by the setup.
: Here is the scipt that you can use for creating this table manually
: create table ora_monitor.profiler_data ( ...
: GRANT SELECT, INSERT, DELETE, UPDATE ON ora_monitor.profiler_data TO PUBLIC;

Please note that to grant the privileges mentioned previously, this script must have something to change the user that grant these privileges...

SQL> connect system@teste
Informe a senha: *******
Conectado.
SQL> GRANT SELECT, INSERT, DELETE, UPDATE ON ora_monitor.profiler_data TO PUBLIC;
GRANT SELECT, INSERT, DELETE, UPDATE ON ora_monitor.profiler_data TO PUBLIC

*
ERRO na linha 1:
ORA-01031: insufficient privileges

SQL> connect ora_monitor@teste
Informe a senha: ********
Conectado.
SQL> GRANT SELECT, INSERT, DELETE, UPDATE ON ora_monitor.profiler_data TO PUBLIC;

Operação de Grant bem-sucedida.

SQL>

I noted that this problem appeared to be the same as the SYS user. Than, I looked back to find the right owner and its password. Tried again and the problem remain...

Rgds,
Sven

Connect as ORA_MONITOR/IMONITOR and then execute
GRANT SELECT, INSERT, DELETE, UPDATE ON ora_monitor.profiler_data TO PUBLIC;

: Please note that to grant the privileges mentioned previously, this script
: must have something to change the user that grant these privileges...

: SQL> connect system@teste
: Informe a senha: *******
: Conectado.
: SQL> GRANT SELECT, INSERT, DELETE, UPDATE ON ora_monitor.profiler_data TO
: PUBLIC;
: GRANT SELECT, INSERT, DELETE, UPDATE ON ora_monitor.profiler_data TO PUBLIC

: *
: ERRO na linha 1: ORA-01031: insufficient privileges

: SQL> connect ora_monitor@teste
: Informe a senha: ********
: Conectado.
: SQL> GRANT SELECT, INSERT, DELETE, UPDATE ON ora_monitor.profiler_data TO
: PUBLIC;

: Operação de Grant bem-sucedida.

: SQL>

: I noted that this problem appeared to be the same as the SYS user. Than, I
: looked back to find the right owner and its password. Tried again and the
: problem remain...

: Rgds,
: Sven

I am getting the same error after installing the profload.sql as the sys user.
does anyone know how to resolve?

Thnx

Iain

: I am getting an error with the install. It says DBMS_Profiler does not exist,
: but it does and I am installing under SYS.

: Then when I run the SQL Profiler and try to execute some code I get a Table
: not found Oracle Error.

: Regards
: JD

Do you have SYS.PLSQL_PROFILER_RUNS table installed?
What about ORA_MONITOR.PROFILER_DATA table?

: I am getting the same error after installing the profload.sql as the sys
: user.
: does anyone know how to resolve?

: Thnx

: Iain