文档章节

where is the oracle 12c logfile

rootliu
 rootliu
发布于 2017/08/23 15:49
字数 499
阅读 8
收藏 0

where is the oracle 12c logfile?

up vote 1 down vote favorite

1

I am getting all of the following error first:

ORA-12162: TNS:net service name is incorrectly specified

When I export the ORACLE_SID , I can run any command and I get the following error:

connected to an idle instance

Where is the ALERTLOG file in 12C?

I can't see any file in ORACLE_HOME/log folder. I am using ubuntu 14.04 BTW.

oracle

shareimprove this question

edited Dec 3 '15 at 10:01

Julien Vavasseur

8,57421736

asked Sep 21 '14 at 11:42

Tamim Addari

136139

 
    

I think the question is useful in terms of "where is the log file". But the sub-question about the idle instance should just be removed from this question to improve the quality, no? – Wouter Dec 3 '15 at 9:56

add a comment

2 Answers

active oldest votes

 

up vote 5 down vote

The alert log never has been under ORACLE_HOME/log.

It is in $ORACLE_BASE/diag/rdbms/<sid>/<sid>/trace and is named alert_<sid>.log

If you don't have $ORACLE_BASE, this typically is equivalent to $ORACLE_HOME/../../..

This is no different in 12c than it was in 11g (or 10g if I recall correctly).

You can also use the ADRCI tool: http://docs.oracle.com/database/121/SUTIL/adrci.htm#SUTIL1474

shareimprove this answer

answered Sep 21 '14 at 12:15

a_horse_with_no_name

28.8k75488

 
    

thanks , I have resolved the error by allocating more memory in sysctl.conf file , Now I can login to the commandline sql , but I cant login to the web EM though , I am posting another question here , can you please help ? – Tamim Addari Sep 21 '14 at 12:42

add a comment

 

up vote 1 down vote

alert log find better way;------

step 1

select * from v$diag_info;

step 2

$ORACLE_BASE/diag/rdbms/<sid>/<sid>/trace and is named alert_<sid>.log

or

desc v$diag_info



Name                                                                Null?    Type
 ------------------------------------------------------------------- -------- ---------------
 INST_ID                                                                      NUMBER
 NAME                                                                         VARCHAR2(64)
 VALUE                                                                        VARCHAR2(512)
 CON_ID                                                                       NUMBER

Quick sql*plus script to get it out

-- diag_info
-- quick check of the new v$diag_info view that came in with 11
col inst_id form 9999 head inst
col name form a25
col value form a60 wrap
spool diag_info.lst
set lines 120
select * from v$diag_info
order by name
/
spool off

INST_ID NAME                 VALUE                                                            CON_ID
-------- -------------------- ---------------------------------------------------------------- -------
       1 Diag Enabled          TRUE                                                                  0
       1 ADR Base              D:\APP\ORACLE                                                         0
       1 ADR Home              D:\APP\ORACLE\diag\rdbms\ora122\ora122                                0
       1 Diag Trace            D:\APP\ORACLE\diag\rdbms\ora122\ora122\trace                          0
       1 Diag Alert            D:\APP\ORACLE\diag\rdbms\ora122\ora122\alert                          0
       1 Diag Incident         D:\APP\ORACLE\diag\rdbms\ora122\ora122\incident                       0
       1 Diag Cdump            D:\app\oracle\diag\rdbms\ora122\ora122\cdump                          0
       1 Health Monitor        D:\APP\ORACLE\diag\rdbms\ora122\ora122\hm                             0
       1 Default Trace File    D:\APP\ORACLE\diag\rdbms\ora122\ora122\trace\ora122_ora_7416.trc      0
       1 Active Problem Count  0                                                                     0
       1 Active Incident Count 0                                                     

本文转载自:https://dba.stackexchange.com/questions/77184/where-is-the-oracle-12c-logfile

共有 人打赏支持
rootliu
粉丝 2
博文 252
码字总数 2796
作品 0
海淀
数据库管理员
12c rman中输入sql命令

12c之前版本,要在rman中执行sql语句,必须使用sql "alter system switch logfile"; 而在12c版本中,可以支持大量的sql语句了: 比如: C:Userszhengquan>rman target / 恢复管理器: Release 12....

tututu_jiang
06/23
0
0
Oracle使用数据泵 (expdp/impdp)实施迁移

Oracle使用数据泵 (expdp/impdp)实施迁移 实验环境: 1、导出环境:RedHat6.4+Oracle 11.2.0.4.0,利用数据库自带的scott示例用户进行试验测试。 Directory:wjq à /tmp/seiang_wjq 2、导入...

SEianG
2017/04/24
0
0
ORACLE 12C ADRCI-老司机的小技巧

DBA技巧类每日一文 查看数据库日志的时候你还需要自己去找目录么,学会使用ADRCI就好了。我一般会怎么用的,不妨你也试试啊。adrci 其实有很多我们可以研究的地方,help一下可以自学哦。...

roidba
2017/12/16
0
0
Oracle 12c Data Guard 纯小白部署手册

子公司需要搭建数据仓库,并且新建ADG作为主从,硬件设备Dell R730机器; 192.168.1.11 dwjrdb --主库 192.168.1.12 dwjrstdyd --备库 --数据库软件:linuxx6412201database.zip --数据库补丁...

yangjunfeng
07/04
0
0
12c DataGuard 无法删除归档日志

一、环境描述 Oracle 12c 单实例DataGuard Rhel 7.3 二、测试过程 主库操作 1.关闭DG,切换日志 SQL> alter system set logarchivedeststate2=defer; System altered. SQL> show parameter lo......

roidba
2017/11/26
0
0

没有更多内容

加载失败,请刷新页面

加载更多

通过ajax访问远程天气预报服务

http://www.webxml.com.cn/zh_cn/index.aspx 更改wsdl文件 打开文件将15行,51行,101行去掉 然后把文件复制到c盘 然后在桌面上面就生成了文件 将文件打成jar包 package cn.it.ws.weather;...

江戸川
今天
1
0
聊聊storm的tickTuple

序 本文主要研究一下storm的tickTuple 实例 TickWordCountBolt public class TickWordCountBolt extends BaseBasicBolt { private static final Logger LOGGER = LoggerFactory.getLogg......

go4it
今天
1
0
自动装箱和自动拆箱

自动装箱和自动拆箱 Java 提供了 8 种基本数据类型,每种数据类型都有其对应的包装类型,包装类是面向对象的类,是一种高级的数据类型,可以进行一些比较复杂的操作,它们是引用类型而不再基...

tsmyk0715
今天
2
0
简易审计系统

1、有时候我们需要对线上用户的操作进行记录,可以进行追踪,出现问题追究责任,但是linux自带的history并不会实时的记录(仅仅在内存中,当用户正常退出(exit logout )时才会记录到history文件里...

芬野de博客
今天
3
0
Qt那些事0.0.6

QML中使用Image,在设置source的后,通过Qt Quick2 Preview(qmlscene)遇到了图片找不到的问题: Image { id: success_img anchors.centerIn: parent ...

Ev4n
今天
3
0

没有更多内容

加载失败,请刷新页面

加载更多

返回顶部
顶部