본문 바로가기
카테고리 없음

oracle error

tiletocode 2025. 2. 4.

JDBC DRIVER = ./jdbc/ojdbc8.jar
20250204 07:28:25 [main][Logo.print(44)]  _       ____         ______
20250204 07:28:25 [main][Logo.print(44)] | |     / / /_  ____ /_  __/___ _____
20250204 07:28:25 [main][Logo.print(44)] | | /| / / __ \/ __ `// / / __ `/ __ \
20250204 07:28:25 [main][Logo.print(44)] | |/ |/ / / / / /_/ // / / /_/ / /_/ /
20250204 07:28:25 [main][Logo.print(44)] |__/|__/_/ /_/\__,_//_/  \__,_/ .___/
20250204 07:28:25 [main][Logo.print(44)]                              /_/
20250204 07:28:25 [main][Logo.print(44)] Realtime Observability Platform
20250204 07:28:25 [main][Logo.print(44)] WhaTap DBX version 2.3.7 20250123
20250204 07:28:25 [main][AgentBoot.main(116)] Admin: root
20250204 07:28:25 [main][AgentBoot.main(117)] PID: 2416640
20250204 07:28:25 [main][AgentBoot.main(118)] Java Path: /usr/lib/jvm/java-1.8.0-openjdk-1.8.0.345.b01-5.el8.x86_64/jre
20250204 07:28:25 [main][AgentBoot.main(119)] Java Version: 1.8.0_345
20250204 07:28:25 [main][AgentBoot.main(133)] (WHATAP-804) Whatap DBX Agent Started
        -Dwhatap.server.host=[10.20.20.102]
        -Dwhatap.server.port=6600
20250204 07:28:25 [main][Logo.print(44)]  _       ____         ______
20250204 07:28:25 [main][Logo.print(44)] | |     / / /_  ____ /_  __/___ _____
20250204 07:28:25 [main][Logo.print(44)] | | /| / / __ \/ __ `// / / __ `/ __ \
20250204 07:28:25 [main][Logo.print(44)] | |/ |/ / / / / /_/ // / / /_/ / /_/ /
20250204 07:28:25 [main][Logo.print(44)] |__/|__/_/ /_/\__,_//_/  \__,_/ .___/
20250204 07:28:25 [main][Logo.print(44)]                              /_/
20250204 07:28:25 [main][Logo.print(44)] Realtime Observability Platform
20250204 07:28:25 [main][Logo.print(44)] WhaTap DBX version 2.3.7 20250123
20250204 07:28:25 [TcpSession][SecurityMaster.decideAgentOnameOid(116)] (WA168) OID: 532283688 NAME: {DEF1} ONAME: DBX-0-1-31521 IP: 172.17.208.72
20250204 07:28:25 [TcpSession][TcpSession.open(126)] (WA123) The license key is ok
20250204 07:28:25 [TcpSession][TcpSession.open(135)] (WA124) New session is ready 10.20.20.102:6600
20250204 07:28:25 [main][AgentBoot.init(183)] (WA106) Counter collector start
20250204 07:28:25 [main][DaoProxy.read(267)] (WA310) DaoProxy.read H2 [942]: java.sql.SQLSyntaxErrorException: ORA-00942: 테이블 또는 뷰가 존재하지 않습니다

https://docs.oracle.com/error-help/db/ora-00942/: select /* WhaTap3N#1 */ version,instance_name,instance_number from v$instance
20250204 07:28:25 [main][DaoProxy.read(305)] (WA310a) Connection closed!
20250204 07:28:25 [main][DaoProxy.read(267)] (WA310) DaoProxy.read H2 [942]: java.sql.SQLSyntaxErrorException: ORA-00942: 테이블 또는 뷰가 존재하지 않습니다

https://docs.oracle.com/error-help/db/ora-00942/: select /* WhaTap3N#3 */ value from v$parameter where name='cpu_count'
20250204 07:28:25 [main][DaoProxy.read(305)] (WA310a) Connection closed!
20250204 07:28:25 [main][DaoProxy.read(267)] (WA310) DaoProxy.read H2 [942]: java.sql.SQLSyntaxErrorException: ORA-00942: 테이블 또는 뷰가 존재하지 않습니다

https://docs.oracle.com/error-help/db/ora-00942/: select name,value from v$parameter where name='cluster_database' or name='service_names'
20250204 07:28:25 [main][DaoProxy.read(305)] (WA310a) Connection closed!
20250204 07:28:25 [main][OraInfo.Init(155)] [OraInfo]Oracle Version : (0) : 0.0
20250204 07:28:25 [main][OraActiveSessionList.<init>(656)] ora_opt = 6
20250204 07:28:25 [main][OraIndex2.<init>(330)] OraIndex2 load last time ( /whatap/dbx/Index2Last.dat ) : 1738647375455
20250204 07:28:25 [main][OraParameter.<init>(240)] OraSettings load last time ( /whatap/dbx/SettingsLast.dat ) : 1738647375455
c20250204 07:28:30 [CountCollector][OraActiveSessionList.process(3222)] ===== ora active session index send
20250204 07:28:30 [CountCollector][DaoProxy.read(267)] (WA310) DaoProxy.read H2 [942]: java.sql.SQLSyntaxErrorException: ORA-00942: 테이블 또는 뷰가 존재하지 않습니다

https://docs.oracle.com/error-help/db/ora-00942/: select /* WhaTap3D#2 */ statistic#,name from v$sysstat where name in ('session logical reads','physi ...
20250204 07:28:30 [CountCollector][DaoProxy.read(305)] (WA310a) Connection closed!
20250204 07:28:30 [CountCollector][OraActiveSessionList.process(3288)] sesstat idx : 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0
sqlActiveSession : select /* WhaTap3D#5 */ 0 as con_id,saddr,s.sid,s.serial#,s.username,command,taddr,lockwait,s.status,schemaname,
osuser,p.spid,process,machine,s.terminal,s.program,type,sql_address,s.sql_hash_value,s.sql_id,
sql_child_number,prev_sql_addr,prev_hash_value,prev_sql_id,
prev_child_number,s.module,s.action,client_info,row_wait_obj#,
row_wait_file#,row_wait_block#,row_wait_row#,logon_time,last_call_et,pdml_status,
pddl_status,pq_status,client_identifier,blocking_session_status,
blocking_instance,blocking_session,
seq#,event#,event,p1,p2,p3,wait_class#,wait_time,
seconds_in_wait,service_name,
x.xidusn,x.used_ublk,x.used_urec,q.sql_fulltext,q2.sql_fulltext prev_sql_text
from v$session s,v$sqlarea q,v$sqlarea q2,v$process p,v$transaction x
where s.sql_id=q.sql_id(+)
and s.prev_sql_id=q2.sql_id(+)
and s.taddr=x.addr(+)
and s.paddr=p.addr(+)
and (s.status='ACTIVE'  and type='USER' and s.sid = %d)
20250204 07:28:30 [CountCollector][DaoProxy.read(267)] (WA310) DaoProxy.read H2 [942]: java.sql.SQLSyntaxErrorException: ORA-00942: 테이블 또는 뷰가 존재하지 않습니다

https://docs.oracle.com/error-help/db/ora-00942/: select /* WhaTap3D#3 */ l1.type,l1.sid waiter_sid,l1.request,l2.sid holder_sid,l2.lmode,l1.id1,l1.id ...
20250204 07:28:30 [CountCollector][DaoProxy.read(305)] (WA310a) Connection closed!
20250204 07:28:30 [CountCollector][DaoProxy.read(267)] (WA310) DaoProxy.read H2 [942]: java.sql.SQLSyntaxErrorException: ORA-00942: 테이블 또는 뷰가 존재하지 않습니다

https://docs.oracle.com/error-help/db/ora-00942/: select sid,qcsid,qcinst_id from v$px_session where sid<>qcsid
20250204 07:28:30 [CountCollector][DaoProxy.read(305)] (WA310a) Connection closed!
20250204 07:28:30 [CountCollector][OraActiveSessionList.process(3671)] select /* WhaTap3D#4 */ 0 as con_id,pl.plan_hash_value, pl2.plan_hash_value prev_plan_hash_value,saddr,s.sid,s.serial#,s.username,command,taddr,lockwait,s.status,schemaname,
osuser,p.spid,process,machine,s.terminal,s.program,type,sql_address,s.sql_hash_value,s.sql_id,
sql_child_number,prev_sql_addr,prev_hash_value,prev_sql_id,
prev_child_number,s.module,s.action,client_info,row_wait_obj#,
row_wait_file#,row_wait_block#,row_wait_row#,logon_time,last_call_et,pdml_status,
pddl_status,pq_status,client_identifier,blocking_session_status,
blocking_instance,blocking_session,
seq#,event#,event,p1,p2,p3,wait_class#,wait_time,
seconds_in_wait,service_name,
x.xidusn,x.used_ublk,x.used_urec
from v$session s,v$process p,v$transaction x ,v$sql pl,v$sql pl2
where s.taddr=x.addr(+)
and s.sql_id=pl.sql_id(+) and s.sql_child_number = pl.child_number(+) and s.prev_sql_id=pl2.sql_id(+) and s.prev_child_number = pl2.child_number(+)
and s.paddr=p.addr(+)
and (s.status='ACTIVE'  and type='USER' )
20250204 07:28:30 [CountCollector][DaoProxy.readParam(632)] (WA318) DaoProxy.readParam [942]: java.sql.SQLSyntaxErrorException: ORA-00942: 테이블 또는 뷰가 존재하지 않습니다

https://docs.oracle.com/error-help/db/ora-00942/: select /* WhaTap3D#4 */ 0 as con_id,pl.plan_hash_value, pl2.plan_hash_value prev_plan_hash_value,sad ...
20250204 07:28:30 [CountCollector][DaoProxy.readParam(658)] (WA318a) Connection closed!
20250204 07:28:30 [CountCollector][OraActiveSessionList.process(3724)] [16:28:30] Session:
20250204 07:28:30 [CountCollector][OraSessionCounts.buildSql(104)] Session count sql: select /* WhaTap3C#1 */ count(1) tot_sess_cnt,
        sum (case when status='ACTIVE' then 1 else 0 end) act_sess_cnt,
        sum (case when status='ACTIVE' and last_call_et>=10 then 1 else 0 end) long_run_cnt,
        sum (case when status='ACTIVE' and wait_time=0 then 1 else 0 end) wait_sess_cnt,
        sum (case when taddr is not null then 1 else 0 end) txn_sess_cnt,
        sum (case when status='ACTIVE' and type='USER' then last_call_et else 0 end) total_et
from v$session
 where type='USER'

20250204 07:28:30 [CountCollector][DaoProxy.read(267)] (WA310) DaoProxy.read H2 [942]: java.sql.SQLSyntaxErrorException: ORA-00942: 테이블 또는 뷰가 존재하지 않습니다

https://docs.oracle.com/error-help/db/ora-00942/: select /* WhaTap3C#1 */ count(1) tot_sess_cnt,
        sum (case when status='ACTIVE' then 1 else 0 end) ac ...
20250204 07:28:30 [CountCollector][DaoProxy.read(305)] (WA310a) Connection closed!
20250204 07:28:30 [CountCollector][OraDBStat.process(456)] IndexNames (stat): 'logons current','user commits','session logical reads','CPU used by this session','DB time','enqueue waits','physical reads','physical writes','execute count','db block changes','opened cursors current','parse count (total)','parse count (hard)','sorts (memory)','transaction tables consistent reads - undo records applied','data blocks consistent reads - undo records applied','rollback changes - undo records applied','db block gets','consistent gets','redo entries','user rollbacks','sorts (disk)'
20250204 07:28:30 [CountCollector][OraDBStat.process(466)] select /* WhaTap3Q#1 */ statistic#,name from v$sysstat where name in ('logons current','user commits','session logical reads','CPU used by this session','DB time','enqueue waits','physical reads','physical writes','execute count','db block changes','opened cursors current','parse count (total)','parse count (hard)','sorts (memory)','transaction tables consistent reads - undo records applied','data blocks consistent reads - undo records applied','rollback changes - undo records applied','db block gets','consistent gets','redo entries','user rollbacks','sorts (disk)')
20250204 07:28:30 [CountCollector][DaoProxy.read(267)] (WA310) DaoProxy.read H2 [942]: java.sql.SQLSyntaxErrorException: ORA-00942: 테이블 또는 뷰가 존재하지 않습니다

https://docs.oracle.com/error-help/db/ora-00942/: select /* WhaTap3Q#1 */ statistic#,name from v$sysstat where name in ('logons current','user commits ...
20250204 07:28:30 [CountCollector][DaoProxy.read(305)] (WA310a) Connection closed!
20250204 07:28:30 [CountCollector][OraDBStat.process(515)] StatNo : (0)
20250204 07:28:30 [CountCollector][DaoProxy.read(267)] (WA310) DaoProxy.read H2 [936]: java.sql.SQLSyntaxErrorException: ORA-00936: 누락된 표현식

https://docs.oracle.com/error-help/db/ora-00936/: select /* WhaTap3Q#2 */ statistic#,value from v$sysstat where statistic# in ()
20250204 07:28:30 [CountCollector][DaoProxy.read(305)] (WA310a) Connection closed!
20250204 07:28:30 [CountCollector][OraDBEvent.process(362)] IndexNames (event): 'db file sequential read','db file scattered read','enq: TX - row lock contention','direct path read','direct path write','latch free','library cache pin','library cache lock'
20250204 07:28:30 [CountCollector][OraDBEvent.process(368)] select /* WhaTap3E#1 */ event#,name from v$event_name where name in ('db file sequential read','db file scattered read','enq: TX - row lock contention','direct path read','direct path write','latch free','library cache pin','library cache lock')
20250204 07:28:30 [CountCollector][DaoProxy.read(267)] (WA310) DaoProxy.read H2 [942]: java.sql.SQLSyntaxErrorException: ORA-00942: 테이블 또는 뷰가 존재하지 않습니다

https://docs.oracle.com/error-help/db/ora-00942/: select /* WhaTap3E#1 */ event#,name from v$event_name where name in ('db file sequential read','db f ...
20250204 07:28:30 [CountCollector][DaoProxy.read(305)] (WA310a) Connection closed!
20250204 07:28:30 [CountCollector][OraDBEvent.process(432)] EventNo : (0)
20250204 07:28:30 [CountCollector][DaoProxy.read(267)] (WA310) DaoProxy.read H2 [936]: java.sql.SQLSyntaxErrorException: ORA-00936: 누락된 표현식

https://docs.oracle.com/error-help/db/ora-00936/: select /* WhaTap3E#2 */ n.event#,total_waits,total_timeouts,time_waited from v$system_event e,v$even ...
20250204 07:28:30 [CountCollector][DaoProxy.read(305)] (WA310a) Connection closed!
20250204 07:28:30 [CountCollector][OraOSStat.process(267)] select /* WhaTap3E#3 */ osstat_id,stat_name,value from v$osstat
20250204 07:28:30 [CountCollector][DaoProxy.read(267)] (WA310) DaoProxy.read H2 [942]: java.sql.SQLSyntaxErrorException: ORA-00942: 테이블 또는 뷰가 존재하지 않습니다

https://docs.oracle.com/error-help/db/ora-00942/: select /* WhaTap3E#3 */ osstat_id,stat_name,value from v$osstat
20250204 07:28:30 [CountCollector][DaoProxy.read(305)] (WA310a) Connection closed!
20250204 07:28:30 [CountCollector][DbInfo.readCpuCores(123)] /whatap/dbx/whatap.cpc created.
20250204 07:28:30 [CountCollector][AgentInfo.process1(171)] (WA552) Read cpu cores:0
20250204 07:28:30 [CountCollector][AgentInfo.Common_AgentInfo_V1(387)] AgentInfo DB version: null
20250204 07:28:30 [CountCollector][AgentInfo.Common_AgentInfo_V1(389)] AgentInfo Is db multi? false
20250204 07:28:30 [CountCollector][AgentInfo.process1(204)] AgentInfo Agent IP : 172.17.208.72
20250204 07:28:30 [CountCollector][CountCollector.process(970)] (W010) java.lang.NullPointerException
java.lang.NullPointerException
        whatap.dbx.counter.task.AgentInfo.Ora_AgentInfo(AgentInfo.java:456)
        whatap.dbx.counter.task.AgentInfo.process1(AgentInfo.java:223)
        whatap.dbx.counter.task.AgentInfo.process(AgentInfo.java:995)
        whatap.dbx.counter.CountCollector.process(CountCollector.java:968)
        whatap.dbx.counter.CountCollector.run(CountCollector.java:802)
20250204 07:28:30 [CountCollector][CountCollector.process(975)] null
java.lang.NullPointerException
        whatap.dbx.counter.task.AgentInfo.Ora_AgentInfo(AgentInfo.java:456)
        whatap.dbx.counter.task.AgentInfo.process1(AgentInfo.java:223)
        whatap.dbx.counter.task.AgentInfo.process(AgentInfo.java:995)
        whatap.dbx.counter.CountCollector.process(CountCollector.java:968)
        whatap.dbx.counter.CountCollector.run(CountCollector.java:802)
20250204 07:28:30 [CountCollectorSlow][OraIndex2.process(127)] OraIndex2 date check : 250204 , 250204
20250204 07:28:30 [CountCollectorSlow][OraParameter.process(62)] OraSettings date check : 250204 , 250204
20250204 07:28:30 [CountCollectorSlow][CountCollectorSlow.process(62)] (W010s) java.lang.NullPointerException
java.lang.NullPointerException
        whatap.dbx.counter.task.oracle.OraParameter.process(OraParameter.java:203)
        whatap.dbx.counter.CountCollectorSlow.process(CountCollectorSlow.java:60)
        whatap.dbx.counter.CountCollectorSlow.run(CountCollectorSlow.java:42)
20250204 07:28:30 [CountCollectorSlow][CountCollectorSlow.process(67)] null
java.lang.NullPointerException
        whatap.dbx.counter.task.oracle.OraParameter.process(OraParameter.java:203)
        whatap.dbx.counter.CountCollectorSlow.process(CountCollectorSlow.java:60)
        whatap.dbx.counter.CountCollectorSlow.run(CountCollectorSlow.java:42)
20250204 07:28:30 [main][AgentBoot.init(273)] (WA107) pcode=6,oid=532283688,okind=0,onode=0, id=2 (AGENT_BOOT_ENV) , request=0, response=0
        java.version=1.8.0_345
        java.vendor=Red Hat, Inc.
        java.home=/usr/lib/jvm/java-1.8.0-openjdk-1.8.0.345.b01-5.el8.x86_64/jre
        os.name=Linux
        os.arch=amd64
        file.encoding=UTF-8
        user.dir=/whatap/dbx
        user.home=/root
        user.country=KR
        user.timezone=Asia/Seoul
        user.language=ko
        -Xms=64m
        -Xmx=128m
        java.name=2416640@localhost.localdomain
        java.start=1738654099802
        whatap.pid=2416640
        whatap.home=/whatap/dbx
        whatap.ip=172.17.208.72
        whatap.oid=532283688
        whatap.oname=DBX-0-1-31521
        whatap.version=2.3.7 20250123
        whatap.cpu.count=16
        whatap.physical.memory=31407MB
        whatap.disk.free=521474MB
        whatap.disk.total=1108704MB

Tue Feb 04 16:28:30 KST 2025  Whatap DBX Agent Started  DBX-0-1-31521
20250204 07:28:30 [CountCollectorSlow][DaoProxy.read(267)] (WA310) DaoProxy.read H2 [942]: java.sql.SQLSyntaxErrorException: ORA-00942: 테이블 또는 뷰가 존재하지 않습니다

https://docs.oracle.com/error-help/db/ora-00942/: SELECT /* WhaTap3S#2 */ '' con_name,df.tablespace_name tbs,df.file_name dat,
round(df.bytes/1024/102 ...
20250204 07:28:30 [CountCollectorSlow][DaoProxy.read(305)] (WA310a) Connection closed!
20250204 07:28:31 [CountCollectorSlow][DaoProxy.read(267)] (WA310) DaoProxy.read H2 [942]: java.sql.SQLSyntaxErrorException: ORA-00942: 테이블 또는 뷰가 존재하지 않습니다

https://docs.oracle.com/error-help/db/ora-00942/: select /* WhaTap3S#3 */ '' con_name,d.tablespace_name tbs,d.file_name dat,sum(d.bytes)/1048576 "SIZE ...
20250204 07:28:31 [CountCollectorSlow][DaoProxy.read(305)] (WA310a) Connection closed!
20250204 07:28:31 [CountCollectorSlow][DaoProxy.read(267)] (WA310) DaoProxy.read H2 [942]: java.sql.SQLSyntaxErrorException: ORA-00942: 테이블 또는 뷰가 존재하지 않습니다

https://docs.oracle.com/error-help/db/ora-00942/: select /* WhaTap3S#4 */ * from v$sga
20250204 07:28:31 [CountCollectorSlow][DaoProxy.read(305)] (WA310a) Connection closed!
20250204 07:28:31 [CountCollectorSlow][OraTableSpace.process(798)] SGA:

저작자표시 (새창열림)

티스토리툴바