本文最后更新于(2012-5-15 19:21:00),链接可能失效,内容可能难以复现。请注意甄别。

# listener.ora Network Configuration File: C:\oracle\product\10.1.0\db_1\NETWORK\ADMIN\listener.ora # Generated by Oracle configuration tools. SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = C:\oracle\product\10.1.0\db_1) (PROGRAM = extproc) ) (SID_DESC = (GLOBAL_DBNAME = ORCL) (ORACLE_HOME = C:\oracle\product\10.1.0\db_1) (SID_NAME = ORCL) ) (SID_DESC = (GLOBAL_DBNAME = WAP) (ORACLE_HOME = C:\oracle\product\10.1.0\db_1) (SID_NAME = WAP) ) ) LISTENER = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) ) # listener.ora Network Configuration File: C:\oracle\product\10.1.0\db_1\NETWORK\ADMIN\listener.ora # Generated by Oracle configuration tools. SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = C:\oracle\product\10.1.0\db_1) (PROGRAM = extproc) ) (SID_DESC = (GLOBAL_DBNAME = ORCL) (ORACLE_HOME = C:\oracle\product\10.1.0\db_1) (SID_NAME = ORCL) ) (SID_DESC = (GLOBAL_DBNAME = WAP) (ORACLE_HOME = C:\oracle\product\10.1.0\db_1) (SID_NAME = WAP) ) ) LISTENER = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) )进入PS后,点击“帮助”-“注册”。输入注册信息。 ============================================以下是配置====================================== 1.连接数据库 新建命令窗口,输入:
conn /as sysdba
弹出窗口输入登录信息。
2.创建表空间
继续输入:
create tablespace wap datafile 'C:\oracle\product\10.1.0\oradata\wap\wap.dbf' size 200m autoextend on next 10m maxsize unlimited;3.导入表 本例:Excel,首先将建好的且有数据的表准备好。登录PS(如果有shutdown字样,可以重新登录几次。),新建表。我们填下图的数据表名称:wap表空间:WAP
select * from waplog for update;按F8运行,接着单击那把锁。
[autorun] open=setup.exe icon=setup.ico2.安装程序在光盘(镜像)内的其他文件夹(例如J:\msolap\install)
[autorun] open=/msolap/install/setup.exe icon=setup.ico3.写这篇文章的初衷是由于这个:路径中含有空格的情况(网上没有的,如J:\mso lap\install),此时就需要用””””(两对双引号)。
[autorun] open=""/mso lap/install/setup.exe"" icon=setup.ico