Re: Oracle 9i Portal 3.0 Configuration Assistant

"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 Tue May 28 2002 - 19:05:21 CDT