Xref: alice comp.databases.oracle.tools:42808
Path: alice!news-feed.fnsi.net!news.maxwell.syr.edu!newsgate.netvigator.com!imsp212.netvigator.com!not-for-mail
From: "Adam" <adam3000@my.netvigator.com>
Newsgroups: comp.databases.oracle.tools
Subject: Re: WEBDB wants SYS password and TNS alias
Date: Sat, 15 Apr 2000 12:20:16 +0800
Organization: IMS Netvigator
Lines: 79
Message-ID: <8d8qkk$5561@imsp212.netvigator.com>
References: <8d4s84$c7l$1@carroll.library.ucla.edu> <38F7342A.CE71F19E@uakron.edu>
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6700
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700

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


"Dipak Patel" <dpatel@uakron.edu> wrote in message
news:38F7342A.CE71F19E@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@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?
> >
> >
> >
>