Tags » Oracle

ORA-01830 And ORA-06512 When Peforming Upgrade

Last week I got the next error when I was upgrading from 11.2.0.3 to 12.1.0.2

 
ERROR at line 1: 
ORA-01830: date format picture ends before converting entire input string 
ORA-06512: at "SYS.XS_OBJECT_MIGRATION", line 167 
ORA-06512: at line 28 
ORA-06512: at line 69
… 52 more words
General

Oracle ADF Online Training Demo on Wednesday, March 29 at 07:00 AM India Time


SM Consultant is pleased to invite you to join the upcoming Online Session for Oracle ADF Training.

To attend the class please login at : … 19 more words

Blogs

Is Alkaline Water A Hydration Hit Or A Big Fat Hoax?

{“contentType”:”NEWS_STORY”,”id”:{“value”:”61d637fa071e56f80c41d2a04b3fb1ee”,”link”:”http:\/\/api.newsapi.com.au\/content\/v2\/61d637fa071e56f80c41d2a04b3fb1ee”},”originId”:”Whimn-18961″,”origin”:”WORDPRESS”,”channel”:”NONE”,”title”:”Is Alkaline Water A Hydration Hit Or A Big Fat Hoax?”,”subtitle”:”Alkaline Water: Hydration Hit Or Hoax?”,”description”:”

Here’s the lowdown on why we feel the need to alkalise.“,”link”:”http:\/\/cdn.newsapi.com.au\/link\/61d637fa071e56f80c41d2a04b3fb1ee”,”canonicalOverride”:””,”paidStatus”:”NON_PREMIUM”,”originalSource”:”whimn.com.au”,”creditedSource”:”whimn.com.au”,”version”:”PUBLISHED”,”dateUpdated”:”2017-03-28T01:39:40.000Z”,”dateLive”:”2017-03-28T02:00:17.000Z”,”customDate”:”2017-03-28T00:26:15.000Z”,”dateCreated”:”2017-03-28T01:04:33.000Z”,”status”:”ACTIVE”,”thumbnailImage”:{“contentType”:”IMAGE”,”id”:{“value”:”9a2a443277c74c952323d11ddfe88af0″,”link”:”http:\/\/api.newsapi.com.au\/image\/v1\/9a2a443277c74c952323d11ddfe88af0″},”originId”:”Whimn-18973-spp_thumbnail”,”origin”:”WORDPRESS”,”title”:”We just want water that takes like real water. 2,611 more words

Strength

execute immediate

1.
sql_stmt := ‘insert into t’||tbcounter||’ values (:1, :2)’;
execute immediate sql_stmt using s, s;

2.
sqlstring := q'’;

execute immediate sqlstring;

3.
begin
execute immediate ‘create table abcd (efgh number)’; 162 more words

The road so far...

WHEW! I FINALLY did it! I started a blog!

I have no idea what I’m doing! A HUGE thanks to my awesome friend Mrs. MommyMack, for making my featured images and all the help and advice she has given me the past few months as I stewed this blog adventure over. 211 more words

Brand New

local_listener is set to a wrong port

The parameter local_listener of the asm instanceĀ is maintained by the clusterware and sometimes set to a wrong value. A port which is higher then the defined port of the local listener. 398 more words

Oracle