Re: explain in tkprof

From: Steve Howard <stevedhoward_at_gmail.com>
Date: Thu, 02 Aug 2007 21:00:15 -0000
Message-ID: <1186088415.261560.315920@d30g2000prg.googlegroups.com>

On Aug 1, 12:14 pm, Eugene <epi..._at_gmail.com> wrote:
> Hi all,
> I am running Oracle 8.1.6.3 on Win NT4 and having a prblem displaying
> explain plan in tkprof.
> -----------------------------------------------------------------------
> set oracle_sid=sid
> tkprof ora00128.trc tk_out.txt sort=exeela,fchela explain=sys/
> pass_at_my_db;
> -----------------------------------------------------------------------
> I am getting an output file just fine, but w/out explain plan.
> File has the fillowing error it:ORA-12154: TNS:could not resolve
> service name,
> I can login using same usernam/pass in SQL*Plus however.
>
> Thanks,
> Eugene

I'm not sure and didn't test, but any connection as sys usually requires SYSDBA qualifier (with the exception of RMAN). It may be something to check, at least, trying another user.

HTH, Steve Received on Thu Aug 02 2007 - 16:00:15 CDT