A dblink is being built today ORA-00911: Invalid character error,
Syntax is
Create Public database link Tmsdb
Connect to User1 identified by User1
Useing ' (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.0.110) (PORT = 1521))
(Connect_data =
(SERVER = dedicated)
(service_name = ORCL)
)
)‘;
Result hint ORA-00911: Invalid character error, with toad, PL/SQL developer tried or so
I used to use the phrase many times, no problem, today is really god. There is no way to enclose the password in quotation marks as follows:
Create Public database link Test_dblink
Connect to User1 identified by "User1"
Useing ' (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.0.110) (PORT = 1521))
(Connect_data =
(SERVER = dedicated)
(service_name = ORCL)
)
)‘;
In the execution of the row, incredibly OK, I thought this could be used, with the statement test:
SELECT * from [email protected]_dblink;
Error invalid user name or password, but this user and password I use toad or PL/SQL developer connection is not a problem, it seems that the password is still
There is a problem.
It seems that the user side of the tool character set is still a problem, so directly connected to the server, with the Sqlplus connection to run the following script
Create Public database link Tmsdb
Connect to User1 identified by User1
Useing ' (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.0.110) (PORT = 1521))
(Connect_data =
(SERVER = dedicated)
(service_name = ORCL)
)
)‘;
Connection test OK;
This article is from "the director of the audience, for Me" blog, please be sure to keep this source http://jonsen.blog.51cto.com/4559666/1632024
It's an egg. ORA-00911: Invalid character error