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

8,57421736

asked Sep 21 '14 at 11:42

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

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:APPORACLE                                                         0
       1 ADR Home              D:APPORACLEdiagrdbmsora122ora122                                0
       1 Diag Trace            D:APPORACLEdiagrdbmsora122ora122trace                          0
       1 Diag Alert            D:APPORACLEdiagrdbmsora122ora122alert                          0
       1 Diag Incident         D:APPORACLEdiagrdbmsora122ora122incident                       0
       1 Diag Cdump            D:apporaclediagrdbmsora122ora122cdump                          0
       1 Health Monitor        D:APPORACLEdiagrdbmsora122ora122hm                             0
       1 Default Trace File    D:APPORACLEdiagrdbmsora122ora122traceora122_ora_7416.trc      0
       1 Active Problem Count  0                                                                     0
       1 Active Incident Count 0

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!