Re: Oracle 9i Portal 3.0 Configuration Assistant

Henry had it right, I had to do
set O7_DICTIONARY_ACCESSIBILITY=TRUE

which I actually did do - put the database was not using my init.ora file - I had to restart the database with startup pfile=.../initsid.ora

oh well I'll investigate later which pfile it is actually using by default.

Tim

"Howard J. Rogers" <dba_at_hjrdba.com> wrote in message news:<ad162r$i9s$1_at_lust.ihug.co.nz>...
> "Tim Smith" <timasmith_at_hotmail.com> wrote in message
> news:a7234bb1.0205271254.7c11acb3_at_posting.google.com...
> > Hi,
> > I have just installed an Oracle 9.0.1 database and now the
> > application server. When I run the Oracle 9i Portal 3.0 Configuration
> > Assistant it prompts for the sys password and a database connection.
> > I entered:
> >
> > <mypassword>
> > myhost:1521:mysid1
> >
>
> Is there no proper TNSNAMES file from which an alias could have been
> extracted?
>
> > I can confirm the above information because I CAN do the following:
> > sqlplus app/pass_at_mysid1
> > >connect sys/<mypassword> as sysdba;
> >
>
> Yeah, but the magic there is that you are specifying (1) a tnsnames alias,
> not a concatenation of pieces of information and (2) you're connecting AS
> SYSDBA (the only valid SYS connection in 9i, unless you change
> 07_dictionary_accessibility to equal TRUE, whereupon normal SYS connections
> are permitted again).
>
> > Despite this I get the message:
> >
> > could not connect
> > 1) Make sure db is running
> > 2) Ensure pass/connect is valid
> > 3) specify hostname:port:sid
> > 4) TNS names alias is not allowed
> >
>
> Oh well, since Number 4 rules out my concern about lack of a tnsnames alias,
> I can only think you're running up against the 'no connections as SYS except
> as a privileged user' feature of 9i.
>
> When it prompts for the password, how about typing
>
> "<password> as sysdba" (within the quotes)?
>
> Alternatively, abandon hope all ye who enter here, and make 9i behave in
> this respect like ye venerable version 7, and set
> o7_dictionary_)accessibility=true in the init.ora and bounce the instance.
>
> > I have removed mysid1 from the TNS alias just to validate 4) but it
> > makes no difference.
> >
> > If anyone can offer help then that would be awesome.
> >
>
> Mega.
>
> Regards
> HJR
>
>
>
> > thanks
> >
> > Tim
Received on Wed May 29 2002 - 11:28:35 CDT