我现在想把环境搭建起来 主要是数据库能跑起来啊 老板催的急 今天在网上找了一天的资料也没有解决这个问题 所以才来这里麻烦大家的啊
现在我面对的问题是:
1.orcale数据库10G 企业版(安装完了 ,但是提示数据库没有启动什么的 要进入http://***/me 进行启动搞不明白几个要添的参数:我填的参数 :机器用户名 机器密码 数据库用户名我用的是 SYS 数据库密码 启动不了 但是我用SQLPLUS里 可以进入的,我进入的方式是:
1.进入控制台
2.输入sqlplus 回车
3.输入用户名 system
4. 输入密码
2.我有一个脚本文件,怎么导入这个脚本文件并创建数据库
我目前所要做的就是把数据库建好 至于orcale的学习以后可以学习 现在请大家给我救救急啊 在下感激不尽
先谢谢了
----------------解决方案--------------------------------------------------------
一。控制面板->管理工具->服务
找到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编辑过]
----------------解决方案--------------------------------------------------------
真的非常感谢啊
您的这些东西省去我好长的时间啊
终于可以睡个安稳觉了
----------------解决方案--------------------------------------------------------
一。控制面板->管理工具->服务
找到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找找吧
这样同志真认真!!
----------------解决方案--------------------------------------------------------