where is the oracle 12c logfile?

up vote 1 down vote favorite

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

share improve 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

share improve 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

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

where is the oracle 12c logfile

where is the oracle 12c logfile?

2 Answers

猜你在找的Oracle相关文章