1.开始菜单,程序,oracle的菜单里有一个是配置oms的。
2.现配置sta1.domain.com上的listener.ora文件
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = sta1.domain.com)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
)SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\ora92) ---你的安装oracle的目录
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = db1.domain.com)
(ORACLE_HOME = D:\oracle\ora92) ---你的安装oracle的目录
(SID_NAME = db1.domain.com)
)
)运行lsnrctl start
再在客户端sta2.domain.com配置tnsnames.ora
db1.domain.com =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = sta1.domain.com)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = db1.domain.com)
)
)
然后,tnsping db1.domain.com 应该可以通
配置odbc是只要输入db1.domain.com 即可
2.现配置sta1.domain.com上的listener.ora文件
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = sta1.domain.com)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
)SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\ora92) ---你的安装oracle的目录
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = db1.domain.com)
(ORACLE_HOME = D:\oracle\ora92) ---你的安装oracle的目录
(SID_NAME = db1.domain.com)
)
)运行lsnrctl start
再在客户端sta2.domain.com配置tnsnames.ora
db1.domain.com =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = sta1.domain.com)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = db1.domain.com)
)
)
然后,tnsping db1.domain.com 应该可以通
配置odbc是只要输入db1.domain.com 即可
2、通过Net8 Configuration Assistant来配置,具体步骤:
Network Administration->Net8 Configuration Assistant->本地网络服务名配置->添加->Oracle8i数据库或服务。按向导一步步配就可以了
配置完以后你可以sta2.domain.com的DOS下输入sqlplus user/password@yourservicename,就可以访问你的db1数据库了。
启动服务就可以登陆oracle management server了 。
第一次登陆的用户名:sysman,密码:oem_temp
Oracle Management Server是一个ORACLE的集中管理平台,包含了Oracle的所有工具
你应该可以看出它的好处了。