在orcale里执行sql语句，提示ORA-03114：未连接到oracle，求解。
发布网友
发布时间：2022-06-06 09:48
我来回答
共5个回答
热心网友
时间：2023-10-08 20:28
ORA-03114 not connected to ORACLE
Cause: A call to Oracle was attempted when no connection was established.
Usually this happens because a user-written program has not logged on. It may
happen if communication trouble causes a disconnection. In addition, this
message could occur when ALTER SYSTEM KILL SESSION or ALTER SYSTEM
DISCONNECT SESSION were issued with the IMMEDIATE qualifier because,
in those cases, the client’s connection to the database is terminated without
waiting for the client to issue a request.
Action: Try again. If the message recurs and the program is user written, check
the program.
热心网友
时间：2023-10-08 20:29
都没有连上数据库，怎么执行的sql语句，或者是用到一半断开了。
热心网友
时间：2023-10-08 20:29
重新连接数据库
热心网友
时间：2023-10-08 20:30
重新登陆
估计在使用的时候，oracle连接断掉了。
热心网友
时间：2023-10-08 20:30
未登陆成功,用户密码或者连接服务名有问题
在orcale里执行sql语句,提示ORA-03114:未连接到oracle,求解。
Cause: A call to Oracle was attempted when no connection was established.Usually this happens because a user-written program has not logged on. It may happen if communication trouble causes a disconnection. In addition, this message could occur when ALTER SYSTEM KILL SESSION or ALTER ...
General SQL error:ORA-03114
ORA-03114: not connected to ORACLE Cause: The connection between Client and Server process was broken. This may also happen if the external agent extproc crashes for some reason.Action: There was a communication error which requires further investigation. First, check for network problem...
ORA-03114: 未连接到 ORACLE奇怪问题
可以正常连接，但是获取用户概要信息有错误 提示清楚， 让你在服务器上用system用户登陆数据库，运行pupbld.sql 参考百度“忽视细节导致简单问题的复杂化 关于PUPBLD.SQL”
创建用户时ORA-03114:未连接到ORACLE什么情况呀?
解决方法为：去掉cdc功能。操作为：DROP TRIGGER sys.cdc_alter_ctable_before;DROP TRIGGER sys.cdc_create_ctable_after;DROP TRIGGER sys.cdc_create_ctable_before ;DROP TRIGGER sys.cdc_drop_ctable_before;CALL sys.dbms_java.dropjava('-s rdbms/jlib/CDC.jar');
用reman恢复时出现ora-03114未连接到Oracle
1.nomount instance 用默认的init.ora文件就可以nomount 2.restore spfile and controlfile 指定dbid和backuppiece，或者将源库中$oracle_home/dbs/c-$dbid-$date复制到目标库$oracle_home相应位置 3.shutdown and mount instance 应用了还原的spfile和控制文件 4.restore and recover database 5.resetlo...
网页提示 ora-03114ORA-03114:未连接到ORACLE 时好时坏啊 到底是哪的...
下面的都有可能，Unix核心参数设置不当 Oracle执行文件权限不正确／环境变量问题 客户端通信不能正确处理 数据库服务器崩溃/操作系统崩溃/进程被kill Oracle 内部错误 特定SQL、PL/SQL引起的错误 空间不够 防火墙的问题 其它原因 建议当前首先的尝试就是重启，数据库，系统，应用，进一步做排除 ...
创建数据库时出现:ORA-03114:not connected to ORACLE怎么办_百度...
基本上你的数据库没启动，或者哪里有问题导致数据文件或什么的没创建成功，直接导致oracle没启动起来，然后后面的步骤都不成功，会提示这样的错误。代表没连接到oracle。
...ORACLE数据库时,有时会报错 ORA-03114: 未连接到 ORALCE 是什么原因...
数据库未打开 监听未开 环境变量设置不对，oracle_sid 这种的
Oracle RAC 配置 手动创建数据库的时候报ORA-03114: not connected to...
是不是tnsname文件不对 通常建议安装RAC时不做DBCA，完全装完后在执行DBCA
ora 12560的问题
1 重置init.ora参数文件，调小以下四个参数的值：...short_area_size ...hash_area_size ...bitmap_merge_area_size ...create_bitmap_area_seze ...open_cursone 2 调小SGA的大小 3 减小oracle Job队列数量(job_queue_processes)和并发队列数(parallel_max_servers)4 重置并减小会话/线程...
