一。控制面板->管理工具->服务
找到OracleOracle92TNSlistenter及OracleOracleSID(最后两个)服务并启用
二。开始->程序->Oracle-Oraclehome92->Application Develelopment->SQLPlus,输入用户名密码(用户名/密码scott/tiger)及SID(全局数据库名)
三。登陆后点文件,打开要运行的脚本,回车,OK
如提示无监听器,请检查以下文件
C:\oracle\ora92\network\admin\listener.ora
# LISTENER.ORA Network Configuration File: C:\oracle\ora92\network\admin\listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = mcsoft-7dae0780)(PORT = 1521))//你的主机名
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\ora92)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = yj.com)
(ORACLE_HOME = C:\oracle\ora92)
(SID_NAME = yj)
)
)
还有C:\oracle\ora92\network\admin\tnsnames.ora这个文件如果需要也要改下主机名
还有C:\oracle\ora92\Apache\Apache\conf\httpd.conf
找到这段
#
# Port: The port to which the standalone server listens. Certain firewall
# products must be configured before Apache can listen to a specific port.
# Other running httpd servers will also interfere with this port. Disable
# all firewall, security, and other services if you encounter problems.
# To help diagnose problems use the Windows NT command NETSTAT -a
#
Port 80
Port 7778 //需添加
##
## SSL Support
##
## When we also provide SSL we have to listen to the
## standard HTTP port (see above) and to the HTTPS port
##
Listen 80
Listen 443
Listen 7778 //须添加
基本上就这些问题了,如果还有问题,就去google找找吧
[此贴子已经被作者于2007-1-12 14:16:53编辑过]