Month: July 2016

Database, Errors and Bugs, SQL | PLSQL

ORA-01950 On Insert but not on Create Table

 , , ,

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'

More“ORA-01950 On Insert but not on Create Table”

Application | Middleware | GoldenGate, Linux, Shell Scripts, Weblogic

Weblogic starting with the operating system

 ,

Hi,
Today, let’s to configure weblogic services startup, when machines starts.
In some blogs, we can find a bunch of customized scripts that create and set variables to startup the adminservers, nodemanagers and managed server, but, in my case, i just need to start adminserver and nodemanger, when machines start just after an incident.

For this situation, we need that the startup of application do not interrupt the operation system startup.

*The operation system in subject is Red-Hat 6.5

More“Weblogic starting with the operating system”

Community, Events

Oracle OpenWorld Latin America 2016 : Review

 , ,

Hi Folks!
As I told you here, last 28, 29 and 30th I was at Oracle OpenWorld LA 2016, in São Paulo/SP – Brazil.
Before my considerations, I’d like to remember that some presentation materials used by speakers are available at here.

There was a lot of sessions, so the review for is as short as possible for each one of them:

More“Oracle OpenWorld Latin America 2016 : Review”

Database, Errors and Bugs

Alert Log: “Private Strand Flush Not Complete” on Logfile Switch

 , , , , ,

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”

Database

Flashback – Part 4 (Flashback Transaction Query)

Hi all,

If you have missed the previous Flashback posts, please go through these links to find it and read them if you feel like!

Flashback – Part 1 (Flashback Drop)
Flashback – Part 2 (Flashback Query)
Flashback – Part 3 (Flashback Versions Query)
Flashback – Part 5 (Flashback Table)
Flashback – Part 6 (Flashback Database)
Flashback – Part 7 (Flashback Data Archive)

And now, we are half way there to the end of the Flashback posts, let’s see a little more about FLASHBACK TRANSACTION QUERY.

More“Flashback – Part 4 (Flashback Transaction Query)”