Oracle Database link with error

Question

I'm trying to create a database link form an Oracle server to another. The command I'm using is:

 create public database link mylink connect to myuser identified by 0000 authenticated by myuser identified by 0000 using 'myTNSNameRemoteServer';

sqlplus give me this error:

ERROR at line 1:
ORA-00933: SQL command not properly ended

Putting the '*' under the first character of the password in its first instance.

Have I to escape it in someway?

Thanks

possible duplicate of Error creating database link in Oracle — Yasir Arsanukayev
– Yasir Arsanukayev, Commented Sep 5, 2014 at 5:27

Stefania · Accepted Answer · 2014-04-29 12:16:33Z

5

The solution was to double quote the password:

create public database link mylink connect to myuser identified by "0000" authenticated by myuser identified by "0000" using 'myTNSNameRemoteServer';

answered Apr 29, 2014 at 12:16

Stefania

7131 gold badge12 silver badges38 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

detoro84 Over a year ago

Even though there are another correct answers, this is the explicit one, so this should be marked as correct.

CompEng · Accepted Answer · 2014-04-29 10:56:24Z

3

you can try this:

CREATE DATABASE LINK "dblink_name"
             CONNECT TO "user_user"
             IDENTIFIED BY "user_pass"
             USING '(DESCRIPTION =
                (ADDRESS_LIST =
                  (ADDRESS = (PROTOCOL = TCP)(HOST = "user_server" )(PORT ="user_port" ))
                )
                (CONNECT_DATA =
                  (SERVICE_NAME = "user_service_name")
                  (SRVR = DEDICATED)
                )
              )' ;

answered Apr 29, 2014 at 10:56

CompEng

7,41618 gold badges77 silver badges135 bronze badges

Comments

RaviSK · Accepted Answer · 2014-04-29 09:46:53Z

0

Try this one: CREATE DATABASE LINK ABCD CONNECT TO USER IDENTIFIED BY PASSWORD USING 'DBALIASAME';

answered Apr 29, 2014 at 9:46

RaviSK

133 bronze badges

4 Comments

Stefania Over a year ago

I think that the problem is the password, that as you can see is a sequence of four 0 (number). What I wrote is not a fake password sadly.

RaviSK Over a year ago

@StefaniaLori I've tried to create a user with password '0000' and it doesn't allow to create at the first instance, so if you have any other user with you, could you please with that one else get your password reset to something else :)

Stefania Over a year ago

Unfortunately I can't change the user password because it is a production database, but I tried the same db link with another user, with a simple password and it worked perfectly.

RaviSK Over a year ago

thats great, you got the solution finally :)

Collectives™ on Stack Overflow

Oracle Database link with error

3 Answers 3

1 Comment

Comments

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related