Re: Oracle 9i Portal 3.0 Configuration Assistant

From: Fred Pierce <fpierce_at_avialantic.com>
Date: Wed, 29 May 2002 10:11:34 -0400
Message-ID: <3CF4E196.EE2E918E@avialantic.com>

I think somewhere in the IAS installation docs it says you have to have a password file and the remote_login_passwordfile parameter set to shared or exclusive. I don't know the 9i way of doing that though.

fdp

---

Fred Pierce (DNRC) QSS Group Oracle DBA
Avialantic.com fpierce_at_avialantic.com
www.avialantic.com
MAAM WWII Weekend Airshow 2002 - June 7-9 www.maam.org/maamwwii.html
MAAM Transportation Show 2002 - Sept. 21-22 www.maam.org/transhow.html

---

Tim Smith wrote:
>
> 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
>
> I can confirm the above information because I CAN do the following:
> sqlplus app/pass_at_mysid1
> >connect sys/<mypassword> as sysdba;
>
> 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
>
> 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.
>
> thanks
>
> Tim

--

Received on Wed May 29 2002 - 09:11:34 CDT