Top "Oracle12c" questions

ORA-28040: No matching authentication protocol exception

I am trying to connect my grails project to Oracle databse(Oracle 12c) in windows(8) system. However, whenever I run …

oracle oracle12c

error: ORA-65096: invalid common user or role name in oracle

I just installed Oracle, and it was missing the Scott schema. So i am trying to generate it myself. I …

oracle oracle12c

Return results of a sql query as JSON in oracle 12c

Background I need to fetch a few thousands rows from Oracle and convert them to JSON for use in SlickGrid. …

json oracle oracle12c

ORA-00119: invalid specification ORA-00132: syntax error

Below are outputs from my SQLPLUS startup , LSNRCTRL SERVICES, LSNRCTRL STATUS and TNSPING. Also included are my LISTENER.ORA file, …

oracle listener oracle12c

ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT

I came across ORA-04036 (on 12c) while one of my team members was creating an oracle text index. ORA-29855: error …

oracle oracle12c

Oracle Joins - Comparison between conventional syntax VS ANSI Syntax

Preamble Of late, I see too many geeks commenting on Oracle questions saying that "Do not use (+) operator, rather use …

sql oracle oracle11g oracle10g oracle12c

Why do I get ORA-39001: invalid argument value when I try to impdp in Oracle 12c?

When I run this command in Oracle 12c SE2: impdp system/Oracle_1@pdborcl directory=DATA_PUMP_DIR dumpfile=mydb.dmp …

oracle import oracle12c datapump

ORA-28040: No matching authentication protocol : Oracle 12c Upgrade

We have migrated our Oracle database to 12c from 11g. We have a legacy application running in Java 1.5 and using …

oracle11g struts-1 oracle12c ojdbc java-5

Oracle 12c datapump error when exporting from 11g database

I am using the following in cmd. expdp system/*****@11.11.1.11:1521/orcl schemas=HR directory=DATADIR dumpfile=HR_20150625.dmp logfile=HR_20150625.log …

oracle11g oracle12c datapump

oracle 12c - select string after last occurrence of a character

I have below string: ThisSentence.ShouldBe.SplitAfterLastPeriod.Sentence So I want to select Sentence since it is the string after …

sql string oracle oracle12c