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