Re: WEBDB wants SYS password and TNS alias

Hi guys,

I experianced the same problem too.

When I try to use the SQL plus to test login the Oracle server w/ the sys account, it return an error message something like 'Max Role of SYS account exceeded......'

This limit is related to a default value of a system parameter

MAX_ENABLED_ROLES = 20 you may change this value to something >20, by adding this statement to the 'INIT.ORA' file of your own DB.

The file is located in 'C:\Oracle\admin\[yourdb]\pfile', please backup the old one before editing.

I can successfully overcome this blocking with this.

regards...............adam

[Quoted] "Dipak Patel" <dpatel_at_uakron.edu> wrote in message news:38F7342A.CE71F19E_at_uakron.edu...
> Jim,
> This probably won't help you much, but I am having exactly the same
> problem on NT. I have been trying to find solution to this for quite some
> time now. If you find a solution, could you please share it with me? And
> I will do the same.
>
> Thanks,
> Dipak
> dpatel_at_uakron.edu
>
> Jim Lewis wrote:
>
> > I'm trying to install WEBDB 2.2 on top of Oracle8i on RedHat 6.1.
> >
> > Oracle8i is running fine, and the NET8 config is fine too, apparently,
> > allowing access to Oracle8i from client machines.
> >
> > Unfortunately, my attempts at installing WebDB are blocked at the
> > point where it asks for the password for the SYS account and for a TNS
> > alias. I enter the SYS password and the net_service_name from the
> > tsnnames.ora file but an error message pops up saying I have entered
> > either an invalid SYS password or an invalid TNS alias. Don't you
> > just LOVE "either"-type error messages!
> >
> > Perhaps I don't understand just what a "TNS alias" is. Here is the
> > contents of the tnsnames.ora file:
> >
> > OR8IDB =
> > (DESCRIPTION =
> > (SOURCE_ROUTE = OFF)
> > (ADDRESS_LIST =
> > (ADDRESS = (PROTOCOL = TCP) (HOST = <ip address>)(PORT = 1521))
> > )
> > (CONNECT_DATA =
> > (SERVICE_NAME = or8iDB)
> > )
> >
> > When the WebDB install asks for the TNS alias, I give it OR8IDB.
> >
> > I have also tried adding another entry in the tnsnames.ora file,
> > identical to the OR8IDB entry but with WEBDB in place of OR8IDB.
> >
> > In either case the WebDB install coughs up the "either invalid SYS
> > password or invalid TNS alias" error. By the way, I am sure I'm
> > typing in the correct SYS password. I've been very careful about
> > that.
> >
> > Does anyone have a guess what I may be doing wrong here?
> >
> >
> >
>
Received on Sat Apr 15 2000 - 06:20:16 CEST