Hi all!
Found the error below?
greporadb> alter table TABLE_TEST modify COLUMN_TEST not null; alter table TABLE_TEST modify COLUMN_TEST not null * ERROR at line 1: ORA-02296: cannot enable (MATHEUSDBA.) - null values found
It happen basically because you have null values for this column. Let’s check:
More“ORA-02296: cannot enable (string.) – null values found”
Due to ease in which we can go to the future or return to the past using Goldengate, it becomes increasingly necessary recover archives from backup, sometimes it is necessary to recover a several days.
To do it, generally we need large disk space, at this time, starts a searching for storage disks.
After finding a disk, is need to mount it, i performed with simply mount options in AIX.
ORA-06512 ORA-48168 ORA-12012 for ADR Job Raising Errors
A database is raising stack below on alertlog:
Errors in file /db/u7011/oracle/admin/MYDB/trace/MYDB_j002_22935.trc: ORA-12012: error on auto execute of job "SYS"."DRA_REEVALUATE_OPEN_FAILURES" ORA-48168: the ADR sub-system is not initialized ORA-06512: at "SYS.DBMS_IR", line 522
More“ORA-06512 ORA-48168 ORA-12012 for ADR Job Raising Errors”
Hi,
Today, as in another normal days, I found a problem with ODI schedule in the newly created enviroment. While creating a schedule to scenario execution, then clicked in update schedule in Topology > Agents > OracleDIAgent, I received an exception:
ODI-1274: Agent Exception Caused by: Could not find the AgentScheduler instance in order to process 'OdiComputePlanning' request
Oracle support has a solution for this exception, but only for ODI 12c, it happens that my enviroment is ODI 11.1.1.6, in community oracle, has the same question, but, without answer.
A few months ago, i had a problem in Persistence Store of JMS queues, soon after perform server restart, I get error from persistence store to recover message:
weblogic.store.PersistentStoreFatalException: [Store:280064]invalid handle 55981 (server="EVENTS01" store="JDBCStore_3022" table="JDBCStore_3022WLStore"),
To resolve this problem, just add this parameter on server startup arguments:
-Dweblogic.store.StoreBootOnError = true
With this parameter, the server starts with OK status in WebLogic 11g and with FAILED status in Weblogic 12c, but in both the processing of the messages continues when active,
to remove FAILED status in Weblogic 12c, just need to truncate persistence table in database and restart server (This solution can be found in Oracle Docs).
This solution did not solved my problem, because I can’t lost or delete messages.
Let’s go analyse the problem:
More“Avoiding lost messages in JDBC Persistent Store, when processing Global Transactions with JMS.”
Hi all,
What if your arch processes hangs or get killed? How to keep archive going without restart database?
Take a look…
It’s very common to automate application startup in rc.local on Linux systems.
Was testing Red Hat 7.2 (Maipo), and found that apps was’t started.
Found this on some Red Hat blog:
“Systemd is a system and service manager for Linux operating systems. It is designed to be backwards compatible with SysV init scripts, and provides a number of features such as parallel startup of system services at boot time, on-demand activation of daemons, support for system state snapshots, or dependency-based service control logic. In Red Hat Enterprise Linux 7, systemd replaces Upstart as the default init system.”
On default /etc/rc.local comes useful info:
#!/bin/bash
# THIS FILE IS ADDED FOR COMPATIBILITY PURPOSES
#
# It is highly advisable to create own systemd services or udev rules
# to run scripts during boot instead of using this file.
#
# In contrast to previous versions due to parallel execution during boot
# this script will NOT be run after all other services.
#
# Please note that you must run ‘chmod +x /etc/rc.d/rc.local’ to ensure
# that this script will be executed during boot.touch /var/lock/subsys/local
Then, this ‘chmod’ turns rc.local enable during system startup.
To familiarize this new feature:
[root@somesystem~]# systemctl status rc-local ● rc-local.service - /etc/rc.d/rc.local Compatibility Loaded: loaded (/usr/lib/systemd/system/rc-local.service; static; vendor preset: disabled) Active: active (running) since Mon 2016-07-11 13:16:18 BRT; 28min ago Process: 1046 ExecStart=/etc/rc.d/rc.local start (code=exited, status=0/SUCCESS) CGroup: /system.slice/rc-local.service ├─2272 /bin/sh /oracle/domains/mywl_domain/startWebLogic.sh ├─2284 /bin/sh /oracle/domains/mywl_domain/bin/startWebLogic.sh ├─2374 /bin/sh /oracle/domains/mywl_domain/bin/startNodeManager.sh ├─2377 /bin/sh /oracle/binaries/wlserver/server/bin/startNodeManager.sh ├─2428 /oracle/jdk1.7.0_25/bin/java -Dwls.home=/oracle/binaries/wlserver/server -Dweblogic.home=/oracle/binaries/wlserver/server -server -Xms1g -Xmx1g -XX:MaxPermSize=512m -Dcoherence... └─2442 /oracle/jdk1.7.0_25/bin/java -server -Xms1g -Xmx1g -XX:MaxPermSize=512m -Dweblogic.Name=AdminServer -Djava.security.policy=/oracle/binaries/wlserver/server/lib/weblogic.policy .
Maiquel.
Sounds weird creating table does not raise any error, but inserting a correct tuple in this table raise a permission error, right? Just take a look:
SQL> create table matheusdba.table_test(a number) tablespace TEST_TABLESPACE; Table created. SQL> insert into matheusdba.table_test values (1); insert into matheusdba.table_test values (1) * ERROR at line 1: ORA-01950: no privileges on tablespace 'TEST_TABLESPACE'
Hi all!
Just a curiosity: Have you ever noticed in a database alert log the occourance of the following message for every logfile switch:
Thread 1 cannot allocate new log, sequence 9281 Private strand flush not complete Current log# 5 seq# 9280 mem# 0: /db/u5001/oradata/GREPORADB/redo05a.log Thread 1 advanced to log sequence 9281 (LGWR switch) Current log# 6 seq# 9281 mem# 0: /db/u5001/oradata/GREPORADB/redo06a.log
More“Alert Log: “Private Strand Flush Not Complete” on Logfile Switch”
Hi all!
The package body APEX_030200.WWV_FLOW_HELP become invalid after Oracle Text installation with the follow errors:
Compilation errors for PACKAGE BODY APEX_030200.WWV_FLOW_HELP #13#10Error: PL/SQL: ORA-00942: table or view does not exist Line: 189 #13#10Error: PL/SQL: SQL Statement ignored Line: 188 #13#10Error: PLS-00201: identifier 'CTX_DDL.DROP_PREFERENCE' must be declared Line: 191 #13#10Error: PL/SQL: Statement ignored Line: 191 #13#10Error: PL/SQL: ORA-00942: table or view does not exist Line: 197 #13#10Error: PL/SQL: SQL Statement ignored Line: 196 #13#10Error: PLS-00201: identifier 'CTX_DDL.DROP_PREFERENCE' must be declared Line: 199 #13#10Error: PL/SQL: Statement ignored Line: 199 #13#10Error: PLS-00201: identifier 'CTX_DDL.CREATE_PREFERENCE' must be declared Line: 261 #13#10Error: PL/SQL: Statement ignored Line: 261 #13#10Error: PLS-00201: identifier 'CTX_DDL.SET_ATTRIBUTE' must be declared Line: 262 #13#10Error: PL/SQL: Statement ignored Line: 262 #13#10Error: PLS-00201: identifier 'CTX_DDL.SET_ATTRIBUTE' must be declared Line: 265 #13#10Error: PL/SQL: Statement ignored Line: 265 #13#10Error: PLS-00201: identifier 'CTX_DDL.CREATE_PREFERENCE' must be declared Line: 280 #13#10Error: PL/SQL: Statement ignored Line: 280 #13#10Error: PLS-00201: identifier 'CTX_DOC.FILTER' must be declared Line: 292 #13#10Error: PL/SQL: Statement ignored Line: 292 #13#10Error: PLS-00201: identifier 'CTX_DOC.FILTER' must be declared Line: 312 #13#10Error: PL/SQL: Statement ignored Line: 312
It happens bassically because APEX schema has not been granted with execute privileges for CTX_DDL and CTX_DOC. The note below it’s exactly about it:
The WWV_FLOW_HELP PACKAGE Status is Invalid After Installing Oracle Text (Doc ID 1335521.1)
The solution is simple:
mydb> grant execute on ctx_ddl to APEX_030200; Grant succeeded. mydb> grant execute on ctx_doc to APEX_030200; Grant succeeded. mydb> alter package APEX_030200.WWV_FLOW_HELP compile; Package altered. mydb> alter package APEX_030200.WWV_FLOW_HELP compile body; Package body altered.
Have a nice day!
Matheus.
