反正就是避开1521 端口sid =allen
ORACLE_HOME 已知baidu 之后 我这修改的
修改listen。oraSID_LIST_LSN20 =
( SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = CUG)
(ORACLE_HOME = /u01/app/oracle/product/10.2.1/db_1)
(SID_NAME = ALLEN)
)
)LSN20 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.59.199)(PORT = 1522))
)
)在tnsname。ora里边 增加这段123 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.11.199)(PORT = 1522))
)
(CONNECT_DATA =
(SERVICE_NAME = cug)
)
)我重新启动了lsn20 这个监听
可是
netca 检查连接 总是 01034 和27101
反正有点头晕
还请达人 给个正确的配置方法
ORACLE_HOME 已知baidu 之后 我这修改的
修改listen。oraSID_LIST_LSN20 =
( SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = CUG)
(ORACLE_HOME = /u01/app/oracle/product/10.2.1/db_1)
(SID_NAME = ALLEN)
)
)LSN20 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.59.199)(PORT = 1522))
)
)在tnsname。ora里边 增加这段123 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.11.199)(PORT = 1522))
)
(CONNECT_DATA =
(SERVICE_NAME = cug)
)
)我重新启动了lsn20 这个监听
可是
netca 检查连接 总是 01034 和27101
反正有点头晕
还请达人 给个正确的配置方法
在
lsnrctl stop/start lsn20
sqlplu scott/passwd@123
连接成功之后已经确定下边的配置是正确的其中
监听 lsn20
服务名 helen (这个服务名 在很多 sql 客户端上边 叫做连接名或者连接别名之类的)
sid allen
连接别名 123SID_LIST_LSN20 =
( SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = helen)
(ORACLE_HOME = /u01/app/oracle/product/10.2.1/db_1)
(SID_NAME = allen)
)
)LSN20 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.11.199)(PORT = 1522))
)
)在tnsname。ora里边 增加这段123 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.11.199)(PORT = 1522))
)
(CONNECT_DATA =
(SERVICE_NAME = helen)
)
)