Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: DBLINK problem
From metalink:
Doc ID: Note:18579.1
Subject: OERR: ORA 988 missing or invalid password(s)
Type: REFERENCE
Status: PUBLISHED
Content Type: TEXT/PLAIN
Creation Date: 02-MAR-1995
Last Revision Date: 10-JUN-1999
Error: ORA 988
Text: missing or invalid password(s)
Cause: More usernames than passwords were specified in a GRANT statement.
A valid password must be specified for each username listed in the
GRANT statement.
Action: Enter a valid password for each username.
-- Ron Reidy Oracle DBA news.tin.it wrote:Received on Fri Mar 28 2003 - 06:51:04 CST
> I have these situation:
> PC-A with 1 database OR1
> PC-B with 2 database OR2 and OR3
>
> from OR1 I can do a dblink to OR2 and "SELECT" any table
> from OR3 if I try to set up a dblink (same as OR1 with the same
> username/password), I recive these error:
> ORA-00988: missing or invalid password(s)
>
> The problem is that I have a Table in ORA2 that I must use from the other 2
> database, How I can to it?
>
> P.S. I search in internet and newsgroup for the solution, but nothing ...
> :-(
>
> Thanx
> Gianfranco Poli
> gianfranco_at_REMOVEtin.it
>
>