Re: DBLINK problem

From: news.tin.it <gianfranco_at_REMOVEneotech.it>
Date: Fri, 28 Mar 2003 13:44:58 GMT
Message-ID: <ulYga.23472$Jg1.507601@news1.tin.it>

Ok, thanx for your replay, but I'm not so stupid :-)

I have an update:
on all the 3 database I have the same user (with same password), and if I try to make the dblink with these user, only the database on a remote machine can connect; the 2 database locally can't, but if I use (in the dadatases on the same machine) a user different from the current the link is ok ?!?

these is my solution for the moment.

Is not possible use the same user name to connect to 2 database on the same pc?

thanx
Gianfranco Poli
gfrancop_at_tin.it

"Ron Reidy" <rereidy_at_indra.com> ha scritto nel messaggio news:3E844538.2030603_at_indra.com...
> 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:
> > 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
> >
> >
>
Received on Fri Mar 28 2003 - 07:44:58 CST