Oracle 8i 在 XP 下的安装问题 你在DOS下执行NET START ORACLETNSLISTENER80,看看报什么错误?我在XP下安装过8I,没有出现你的错误。 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 看一下会不会有帮助:http://download-west.oracle.com/docs/cd/B10501_01/em.920/a96673/ch3.htm#1656 好运! to aweihz():因为已经以手动方式启动OracleTNSListener80 ,所有在DOS下执行后提示“请求的服务已经启动。”。帮助里的版本好像是8.05to yuepengfei(凤栖梧):该页面需要用户名和密码登录才可以进入,没看到可以注册的地方。to nicholaz(九思·逢尤):有网卡,清华紫光Realtek RTL8139。 the messages are listed with the prefix TNS in that chapter even though they are displayed with the prefix ORA 这句话不太好理解…这个消息提示以TNS开头,但其实是为了以ORA开头的而显示的。这样? 我在home版的xp下遇到过此种问题,后来改了tnsname.ora就勉强能用了 把你X:\Oracle\Ora81\network\ADMIN目录下的,listener.ora和tnsnames.ora帖出来看看如果需要手工启动监听器,请使用windows run,运行lsnrctl,进入监听控制平台后,用HELP查询自己需要的事情一般停止监听器:LSNRCTL>STOP开始监听:LSNRCTL>START net start 某服务名 这个命令和可视化管理服务是一样的 停止某服务为:net stop 某服务名 to xyzhh(逍遥者寒号):我的是Professional,不知道8.05可不可以用你的方法。to sanoul(垃圾):在我硬盘上的实际目录是C:\orant\NET80\ADMINlistener.ora文件LISTENER = (ADDRESS_LIST = (ADDRESS= (PROTOCOL= IPC) (KEY= oracle.world) ) (ADDRESS= (PROTOCOL= IPC) (KEY= ORCL) ) (ADDRESS= (PROTOCOL= IPC) (KEY= EXTPROC0) ) (ADDRESS= (COMMUNITY= NMP.world) (PROTOCOL= NMP) (SERVER= BILLGATES) (PIPE= ORAPIPE) ) (ADDRESS= (PROTOCOL= TCP) (Host= billgates) (Port= 1521) ) (ADDRESS= (PROTOCOL= TCP) (Host= billgates) (Port= 1526) ) (ADDRESS= (PROTOCOL= TCP) (Host= 127.0.0.1) (Port= 1521) ) )STARTUP_WAIT_TIME_LISTENER = 0CONNECT_TIMEOUT_LISTENER = 10TRACE_LEVEL_LISTENER = 0SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = billgates) (SID_NAME = ORCL) ) (SID_DESC = (SID_NAME = extproc) (PROGRAM=extproc) ) )PASSWORDS_LISTENER = (oracle) 监听器已经以手动方式启动。lsnrctl没有找到。tnsnames.ora文件Beq-local.world = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = BEQ) (PROGRAM = oracle80) (ARGV0 = oracle80ORCL) (ARGS = '(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))') ) ) (CONNECT_DATA = (SID = ORCL) ) )Tcp-loopback.world = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (Host = 127.0.0.1) (Port = 1521) ) ) (CONNECT_DATA = (SID = ORCL) ) )TcpExample.world = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (Host = Production1) (Port = 1521) ) ) (CONNECT_DATA = (SID = ORCL) ) )SpxExample.world = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = SPX) (Service = Server_lsnr) ) ) (CONNECT_DATA = (SID = ORCL) ) )NmpExample.world = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = NMP) (Server = FinanceServer1) (Pipe = ORAPIPE) ) ) (CONNECT_DATA = (SID = ORCL) ) )CMExample.world = (DESCRIPTION=(address_list= (ADDRESS= (PROTOCOL=tcp)(PORT=1610)(HOST=CM_SERVER)) (ADDRESS= (PROTOCOL=tcp)(PORT=1521)(HOST=LSNR_SERVER))) (CONNECT_DATA=(SID=ORCL)) (SOURCE_ROUTE=yes) )extproc_connection_data.world = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC0) ) (CONNECT_DATA = (SID = extproc) ) ) C:\svrmgrl进入之后...SVRMGRL>connect internal/oracleSVRMGRL>startup 像前面所说到的lsnrctl 和 svrmgrl都未找到可执行文件。请问如何在命令行中进入该模式? 还要问一下,9i会不会在XP下出现问题。 oracle中文乱码的问题 关于表分区。。。 请教xmltype字段查询效率问题 创建数据库时提示sysaux01.dbf无效 oracle中 connect as 的作用? 问个oracle怎么调试存储过程问题 oracle大数据备份问题 求证 Oracle 导表的数据进入文本形式方法 有多少?参与提供方法者有分! 日期型字段插入数据。 OEM无法启动,请高手指点! dmp文件能够进行分析么?? 如何在 oracle(win NT)中建立表啊??
http://download-west.oracle.com/docs/cd/B10501_01/em.920/a96673/ch3.htm#1656 好运!
这个消息提示以TNS开头,但其实是为了以ORA开头的而显示的。这样?
开始监听:LSNRCTL>START
停止某服务为:net stop 某服务名
to sanoul(垃圾):在我硬盘上的实际目录是C:\orant\NET80\ADMIN
listener.ora文件
LISTENER =
(ADDRESS_LIST =
(ADDRESS=
(PROTOCOL= IPC)
(KEY= oracle.world)
)
(ADDRESS=
(PROTOCOL= IPC)
(KEY= ORCL)
)
(ADDRESS=
(PROTOCOL= IPC)
(KEY= EXTPROC0)
)
(ADDRESS=
(COMMUNITY= NMP.world)
(PROTOCOL= NMP)
(SERVER= BILLGATES)
(PIPE= ORAPIPE)
)
(ADDRESS=
(PROTOCOL= TCP)
(Host= billgates)
(Port= 1521)
)
(ADDRESS=
(PROTOCOL= TCP)
(Host= billgates)
(Port= 1526)
)
(ADDRESS=
(PROTOCOL= TCP)
(Host= 127.0.0.1)
(Port= 1521)
)
)
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = 0
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = billgates)
(SID_NAME = ORCL)
)
(SID_DESC =
(SID_NAME = extproc)
(PROGRAM=extproc)
)
)
PASSWORDS_LISTENER = (oracle)
lsnrctl没有找到。tnsnames.ora文件
Beq-local.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = BEQ)
(PROGRAM = oracle80)
(ARGV0 = oracle80ORCL)
(ARGS = '(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')
)
)
(CONNECT_DATA = (SID = ORCL)
)
)
Tcp-loopback.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(Host = 127.0.0.1)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = ORCL)
)
)
TcpExample.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(Host = Production1)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = ORCL)
)
)
SpxExample.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = SPX)
(Service = Server_lsnr)
)
)
(CONNECT_DATA = (SID = ORCL)
)
)
NmpExample.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = NMP)
(Server = FinanceServer1)
(Pipe = ORAPIPE)
)
)
(CONNECT_DATA = (SID = ORCL)
)
)
CMExample.world =
(DESCRIPTION=(address_list=
(ADDRESS=
(PROTOCOL=tcp)(PORT=1610)(HOST=CM_SERVER))
(ADDRESS=
(PROTOCOL=tcp)(PORT=1521)(HOST=LSNR_SERVER)))
(CONNECT_DATA=(SID=ORCL))
(SOURCE_ROUTE=yes)
)
extproc_connection_data.world =
(DESCRIPTION =
(ADDRESS =
(PROTOCOL = IPC)
(KEY = EXTPROC0)
)
(CONNECT_DATA = (SID = extproc)
)
)
进入之后...
SVRMGRL>connect internal/oracle
SVRMGRL>startup
都未找到可执行文件。请问如何在命令行中进入该模式?