Run into a strange question,
The same database instance on the client to create two TNS, log in two instances, each in toad

Use the same account, found out information,
The question is, for a great god look! Genuflect is begged!

CodePudding user response:

Full text tnsnames. Ora stick, in addition, confirmed:
1, connect the use of two network service name is what? With sufficient permissions user login, database of the query results, select the value from v $parameter where name='services an instance belongs to';
2, the connection user is what?
3, what is the query SQL?
4, whether in a database on the server using a TOAD? If so, multiple Oracle software is installed, or is it already installed the software on the server and installed the client software? Should create multiple database on the server? On the server, use the CMD execution LSNRCTL status command, posted the command output

CodePudding user response:

1, posted on the complete configuration of TNS content
2, search tnsnames. Ora file, see whether both server_name only exists

CodePudding user response:

The same database instance on the client to create two TNS, log in two instances, each in toad

Note: the original poster is a toad respectively in two instances,
Check whether the two instances of the same below caused by data sync user name?