Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

10046 trace not being enable...

user097815Mar 31 2009 — edited Mar 31 2009
i have been trying to enable a 10046 trace thru toad and i dont get what i am doing wrong..i get the below error when i run this in toad or any other thrid party tool...

alter session set tracefile_identifier='test_look';

exec dbms_support.start_trace_in_session( -
sid => 527, -
serial# => 6515, -
waits => true, -
binds => true);

select * from scott.emp;
select ename from scott.emp;

-- To turn off the tracing:
exec dbms_support.stop_trace_in_session(
sid => 527, -
serial# => 6515);

BEGIN dbms_support.start_trace_in_session(
sid => 527,
serial# => 6515,
waits => true,
binds => true); END;
Error at line 4
ORA-06550: line 1, column 7:
PLS-00201: identifier 'DBMS_SUPPORT.START_TRACE_IN_SESSION' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored


or is there any other way that i can get this done easily for my session ?? so i can take a look at the trace file later...thanks...

database is on 10.2.0.3

Edited by: user630084 on Mar 31, 2009 6:36 AM
This post has been answered by dask99 on Mar 31 2009
Jump to Answer

Comments

Hans Forbrich
You may want to start by reviewing http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/create.htm#sthref483

Host is the physical computer, machine, operating system ... but not the database.

So in general, 'Host Login Credentials' means 'what is the computer username and password (not database user/pwd) of the user who is to login on the host (machine) in order to do the work?'

In this case, it's probably the userid that owns Oracle .... surely you did not install the database as 'Administrator'.
damorgan
There is a demo here:
http://www.morganslibrary.org/reference/wallet.html
that shows all of the moving pieces.

The page is part of the library located at:
http://www.morganslibrary.org/library.html
699363
Actually, this post provided the solution to my problem: 3755696

Thanks for the replies to my original post.
Hans Forbrich
Excellent. And thanks for posting the pointer to solution.
1 - 4
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 28 2009
Added on Mar 31 2009
#general-database-discussions
5 comments
2,515 views