PLSql configures a new oracle instance

the Open the oracle installation directory and find the file tnsnames.ora, usually in the following file path the D:\oracle\product\10.2.0\db_1\network\admin (oracle 10g) the oracle11g is also in the similar network\admin directory the Create a new configuration as follows: In fact, refer to the default copy and modify it. the ORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = E1KO2ZD950PMTFH)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) ) ) www.2cto.com Parameter Description: the HOST = oracle server host name or IP address the Port = port number the SERVICE_NAME= oracle instance name (database name) or SID= instance name the And as follows: the BSY2-PWC-IP50= (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.30.50)(PORT=1521))(CONNECT_DATA=(SID=orcl))) the The display name of PLSQL login is: BSY2-PWC-IP50 the The address is: 192.168.30.50 the Port: 1521 the Link SID: ord the the the Author Yicode