求救到底怎样才行啊,这问题困扰我好久了
解决方案 »
- Oracle 启动定时任务的问题
- oracle 多列数据转化为一行数据
- 求助,ORACLE查询结果排序问题,难!(急!!!)
- oracle 10g Net Manager 连接问题
- 如何进行行列转换?
- SOS!!!在windows操作系统下安装运行的oracle 9i可否在Red Hat Linux 9 下安装运行?(在线解决马上结帖)
- 求教dba_data_files,dba_free_space中的问题
- oracle大数据汇总统计问题
- oracle数据库两张表的数据结构一样,如何检查两张表其中一个字段不同的数据
- Oracle11g的SQLDeveloper卡顿现象
- 如果将一张表中的10万条数据导入另一张表,需要增量导入,每300条提交一次
- DBLink远程连接数据库和连接池无关吗?DBLink有很多问题?
lsnrctl start
配置: Flag '-repos' set to true
2012-11-7 5:35:41 oracle.sysman.emcp.ParamsManager setFlag
配置: Flag 'db' set to true
2012-11-7 5:35:41 oracle.sysman.emcp.ParamsManager setFlag
配置: Flag 'create' set to true
2012-11-7 5:35:41 oracle.sysman.emcp.ParamsManager setParam
配置: Setting param: ORACLE_HOME value: D:\oracle\product\10.2.0\db_1
2012-11-7 5:35:51 oracle.sysman.emcp.ParamsManager setParam
配置: Setting param: SID value: orcl
2012-11-7 5:35:55 oracle.sysman.emcp.ParamsManager setParam
配置: Setting param: PORT value: 1521
2012-11-7 5:35:58 oracle.sysman.emcp.ParamsManager getParam
配置: 未设置参数 SYS_PWD 的值。
2012-11-7 5:35:58 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
配置: SQLEngine connecting with SID: orcl, oracleHome: D:\oracle\product\10.2.0\db_1, and user: SYS
2012-11-7 5:35:59 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
配置: SQLEngine created successfully and connected
2012-11-7 5:36:03 oracle.sysman.emcp.ParamsManager setParam
配置: Setting param: CONFIRMATION ANSWER value:
2012-11-7 5:36:05 oracle.sysman.emcp.ParamsManager setParam
配置: Setting param: CONFIRMATION ANSWER value: yes
2012-11-7 5:36:05 oracle.sysman.emcp.ParamsManager getParam
配置: 未设置参数 LOG_FILE 的值。
2012-11-7 5:36:05 oracle.sysman.emcp.ParamsManager setFlag
配置: Flag 'db' set to true
2012-11-7 5:36:05 oracle.sysman.emcp.ParamsManager getParam
配置: 未设置参数 DB_UNIQUE_NAME 的值。
2012-11-7 5:36:05 oracle.sysman.emcp.ParamsManager getParam
配置: 未设置参数 DB_UNIQUE_NAME 的值。
2012-11-7 5:36:05 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
配置: SQLEngine connecting with SID: orcl, oracleHome: D:\oracle\product\10.2.0\db_1, and user: SYS
2012-11-7 5:36:06 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
配置: SQLEngine created successfully and connected
2012-11-7 5:36:06 oracle.sysman.emcp.DatabaseChecks getDbUniqueName
配置: No Database unique name available. Will try to retrieve it from DB itself
2012-11-7 5:36:06 oracle.sysman.emcp.ParamsManager setParam
配置: Setting param: DB_UNIQUE_NAME value: orcl
2012-11-7 5:36:06 oracle.sysman.emcp.EMConfig perform
信息: 正在将此操作记录到 D:\oracle\product\10.2.0\db_1\cfgtoollogs\emca\orcl\emca_2012-11-07_05-35-41-上午.log。
2012-11-7 5:36:06 oracle.sysman.emcp.ParamsManager setParam
配置: Setting param: EM_HOME value: D:\oracle\product\10.2.0\db_1
2012-11-7 5:36:06 oracle.sysman.emcp.ParamsManager setFlag
配置: Flag 'db' set to true
2012-11-7 5:36:06 oracle.sysman.emcp.ParamsManager getParam
配置: 未设置参数 MODIFY_SID 的值。
2012-11-7 5:36:06 oracle.sysman.emcp.DatabaseChecks getDbServiceName
配置: No service name available. Will try to set db_unique_name.db_domain
2012-11-7 5:36:06 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
配置: SQLEngine connecting with SID: orcl, oracleHome: D:\oracle\product\10.2.0\db_1, and user: SYS
2012-11-7 5:36:07 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
配置: SQLEngine created successfully and connected
2012-11-7 5:36:07 oracle.sysman.emcp.ParamsManager setParam
配置: Setting param: DB_UNIQUE_NAME value:
2012-11-7 5:36:07 oracle.sysman.emcp.ParamsManager getParam
配置: 未设置参数 DB_UNIQUE_NAME 的值。
2012-11-7 5:36:07 oracle.sysman.emcp.DatabaseChecks getDbUniqueName
配置: No Database unique name available. Will try to retrieve it from DB itself
2012-11-7 5:36:07 oracle.sysman.emcp.ParamsManager setParam
配置: Setting param: DB_UNIQUE_NAME value: orcl
2012-11-7 5:36:07 oracle.sysman.emcp.ParamsManager getParam
配置: 未设置参数 DB_DOMAIN 的值。
2012-11-7 5:36:07 oracle.sysman.emcp.DatabaseChecks getDbDomain
配置: No db domain available. Will query db for db_domain parameter
2012-11-7 5:36:07 oracle.sysman.emcp.ParamsManager setParam
配置: Setting param: DB_UNIQUE_NAME value: orcl
2012-11-7 5:36:07 oracle.sysman.emcp.ParamsManager setParam
配置: Setting param: SERVICE_NAME value: orcl
2012-11-7 5:36:07 oracle.sysman.emcp.ParamsManager getParam
配置: 未设置参数 MODIFY_SID 的值。
2012-11-7 5:36:07 oracle.sysman.emcp.ParamsManager getParam
配置: 未设置参数 MODIFY_SID 的值。
2012-11-7 5:36:07 oracle.sysman.emcp.ParamsManager getParam
配置: 未设置参数 GLOBAL_DB_UNIQUE_NAME 的值。
2012-11-7 5:36:07 oracle.sysman.emcp.DatabaseChecks getGlobalDbUniqueName
配置: No Global database unique name available. Will try to retrieve it from DB itself
2012-11-7 5:36:07 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
配置: SQLEngine connecting with SID: orcl, oracleHome: D:\oracle\product\10.2.0\db_1, and user: SYS
2012-11-7 5:36:08 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
配置: SQLEngine created successfully and connected
2012-11-7 5:36:08 oracle.sysman.emcp.ParamsManager getParam
配置: 未设置参数 DB_DOMAIN 的值。
2012-11-7 5:36:08 oracle.sysman.emcp.DatabaseChecks getDbDomain
配置: No db domain available. Will query db for db_domain parameter
2012-11-7 5:36:08 oracle.sysman.emcp.ParamsManager setParam
配置: Setting param: GLOBAL_DB_UNIQUE_NAME value: orcl
2012-11-7 5:36:08 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
配置: SQLEngine connecting with SID: orcl, oracleHome: D:\oracle\product\10.2.0\db_1, and user: SYS
2012-11-7 5:36:09 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
配置: SQLEngine created successfully and connected
2012-11-7 5:36:09 oracle.sysman.emcp.EMReposConfig createRepository
配置: ORA-01219: 数据库未打开: 仅允许在固定表/视图中查询oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-01219: 数据库未打开: 仅允许在固定表/视图中查询 at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeImpl(SQLEngine.java:1467)
at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeQuery(SQLEngine.java:694)
at oracle.sysman.emcp.EMReposConfig.createRepository(EMReposConfig.java:351)
at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:182)
at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:124)
at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:142)
at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:479)
at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1123)
at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:463)
at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:412)
2012-11-7 5:36:09 oracle.sysman.emcp.EMReposConfig invoke
严重: 创建资料档案库时出错
2012-11-7 5:36:09 oracle.sysman.emcp.EMReposConfig invoke
信息: 有关详细资料, 请参阅 D:\oracle\product\10.2.0\db_1\cfgtoollogs\emca\orcl\emca_repos_create_<日期>.log 中的日志文件。
2012-11-7 5:36:09 oracle.sysman.emcp.EMConfig perform
严重: 创建资料档案库时出错
有关详细资料, 请参阅 D:\oracle\product\10.2.0\db_1\cfgtoollogs\emca\orcl\emca_2012-11-07_05-35-41-上午.log 中的日志文件。
2012-11-7 5:36:09 oracle.sysman.emcp.EMConfig perform
配置: Stack Trace:
oracle.sysman.emcp.exception.EMConfigException: 创建资料档案库时出错
at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:194)
at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:124)
at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:142)
at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:479)
at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1123)
at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:463)
at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:412)