1.cd oracle目录,修改tnsname.ora 以testdb数据库为例
testdb=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=TCP)(HOST=10.10.20.151)(PORT=1521))
(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=testdb))
)
2.修改listener.ora
(SID_DESC=
(GLOBAL_DBNAME=testdb)
(Oracle_home=/home/oracle/10g)
(SID_NAME=testdb)
)