Oracle Database

79K

Solutions

26K

Contributors

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.

Share tech news, updates, or what's on your mind.

Sign up to Post

Dear EE,

My Web server stuck and i restarted it. In event log below is the error i see.

1.      Message : ORA-03113: end-of-file on communication channel

Details:
Message: HandlingInstanceID: 12d6bbb6-8560-4a7d-9eb7-2a5ea0adfdd0
An exception of type 'Oracle.DataAccess.Client.OracleException' occurred and was caught.
----------------------------------------------------------------------------------------
10/16/2019 09:13:18
Type : Oracle.DataAccess.Client.OracleException, Oracle.DataAccess, Version=2.112.1.0, Culture=neutral, PublicKeyToken=89b483f429c47342
Message : ORA-03113: end-of-file on communication channel
Process ID: 144215
Session ID: 554 Serial number: 15831
Source : Oracle Data Provider for .NET
Help link :
Errors : Oracle.DataAccess.Client.OracleErrorCollection
DataSource : NETSOLprod
Procedure : PAC_SER_ChangePOSStatus
Number : 3113
ErrorCode : -2147467259
Data : System.Collections.ListDictionaryInternal
TargetSite : Void HandleErrorHelper(Int32, Oracle.DataAccess.Client.OracleConnection, IntPtr, Oracle.DataAccess.Client.OpoSqlValCtx*, System.Object, System.String, Boolean)
HResult : -2147467259
Stack Trace :    at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)
   at Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx,
0
I can update this one column UWI but I would like to turn this into a procedure, where if there is a new uwi in the table which  meet the requirement, it updates automatically.

UPDATE well_core_analysis a
SET    a.active_ind = 'N'
WHERE  active_ind = 'Y'
       AND a.analysis_source = 'GOVT'
       AND uwi IN (SELECT uwi
                   FROM  (SELECT DISTINCT e.string02 AS License_num,
                                          b.uwi,
                                          e.string03 AS Province,
                                          b.analysis_source,
                                          b.row_quality,
                                          b.active_ind
                          FROM   data_entry.well_core_analysis b
                                 join well a
                                   ON b.uwi = a.uwi
                                 join well_license c
                                   ON a.uwi = c.uwi
                                 join license l
                                   ON c.license_id = l.license_id
                                 join publicdata.entity e
                                   ON l.license_id = e.string03  || '|'|| e.string02
                                 join publicdata.l_entity_document led
                                   ON e.entity_id = led.entity_id
                                 join publicdata.document d
                                   ON led.document_id = d.document_id
  …
0
I have been haggling with this (seemingly) simple stored procedure (In the left margin, I have provided line numbers where errors occur):

Replace PROCEDURE MyProc()
BEGIN
	Insert into 
		MyTable
	Select
		*
    From
        ReferenceTable;
		
	Declare cur1 Cursor with return only For
	    Select
			*
	    From
	        MyTable;

	Open cur1;
END;

Open in new window


When I try to run this, I get the following error, between the two statements:

Missing/Invalid SQL statement'E(3707):Syntax error, expected something like an 'END' keyword between ';' and the 'Declare' keyword.'.

Open in new window


I have run the two processes individually, outside of a stored procedure, and they work.  Please help explain this mysterious error.  Thank you.
0
hi,

Now I have convert Oracle to MariaDB/MySQL and we have a convern, how can we know the number of table is the same! but the main idea should be what tables is missed from MariaDB/MySQL side?

any easy way to compare what table is missed on MySQL/mariaDB side ?
0
hi am trying to download file in oracle form using webutil am geting the following error
Application server file INT.REQ-4805-18152.TXT does not exist or is of zero length
this si the log Java Plug-in 11.211.2.12 x86
Using JRE version 1.8.0_211-b12 Java HotSpot(TM) Client VM
User home directory = C:\Users\username
----------------------------------------------------
c:   clear console window
f:   finalize objects on finalization queue
g:   garbage collect
h:   display this help message
l:   dump classloader list
m:   print memory usage
o:   trigger logging
q:   hide console
r:   reload policy configuration
s:   dump system and deployment properties
t:   dump thread list
v:   dump thread stack
x:   clear classloader cache
0-5: set trace level to <n>
----------------------------------------------------
network: Connecting http://hostname:9001/forms/lservlet;jsessionid=CDhmdLLV7Wc2WgSJhyfxshNgpT263YnF3dGfGRTGgyKnbmwgpfq5!2075368613 with proxy=DIRECT
network: Connecting http://hostname:9001/ with proxy=DIRECT
network: Connecting http://hostname:9001/forms/lservlet;jsessionid=CDhmdLLV7Wc2WgSJhyfxshNgpT263YnF3dGfGRTGgyKnbmwgpfq5!2075368613 with proxy=DIRECT
2019-Sep-25  08:42:43.580 WUF[setProperty()] Setting property WUF_GFN_DIRNAME to /usr2/dev/maint/apps/ncs/appfiles/arc/
2019-Sep-25  08:42:43.580 WUF[setProperty()] Setting property WUF_FILENAME to INT.REQ-4805-18152.TXT
2019-Sep-25  08:42:43.580 WUF[setProperty()] Setting property WUF_FILTER to
0
Hi,
Where can I get recent sample questions and answers for Oracle exam: 1Z0-071 - Oracle Database SQL.

I don't mind having it from a pay site so long as I can be assured they can help to pass it.


Thanks
0
Can anyone share a sample full contents of recommended / hardened settings
of postgresql.conf ?

What's indicated in CIS benchmark for Postgresql 10 is unclear & in bits & pieces;
some of the extracts from the benchmarks are posted below:

- configuration file enumerates all tunable parameters and even though most of them are
commented out it is understood that they are in fact active and at those very same
documented values.

- shared_preload_libraries = 'pgaudit'
OR
shared_preload_libraries = 'pgaudit,somethingelse'

- $ vi ~postgres/10/data/postgresql.conf
# load set_user libs before anything else
shared_preload_libraries = 'set_user, other_libs'
0
Hello Experts,
I am facing an issue while exporting one schema which is taking huge time without any rows.

Command used:
exp username/password@instance file=user_name.dmp log=username_exp.log GRANTS=y CONSTRAINTS=y  ROWS=n statistics=none

Open in new window



Cannot use data pump as directory access to servers are restricted.
0
Hello,

I'm trying to make this Crystal Report like the Excel report.  I'm having trouble with making it like the Excel report.

I've attached both files...  Thanks for your help.

JoelEE.xlsx

LG.rpt
0
Why is Oracle 12c db installation stuck at 91%?
I have added a screen capture of the installation information on UI.
Kind regards
Erreur-Oracle-Issue.PNG
0
hi,

I am reading:

https://www.oracle.com/technetwork/testcontent/jdbc-ch5-131209.pdf

https://docs.oracle.com/database/121/JJDBC/oraperf.htm#JJDBC28767

for Oracle prepared statement.

and I do not understand what it means as it says:

Starting from Oracle Database 12c Release 1 (12.1), Oracle update batching is deprecated. Oracle recommends that you use standard JDBC batching instead of Oracle update batching.

Open in new window


when I check standard JDBC batching it says:

The Oracle implementation of standard update batching does not implement true batching for generic statements and callable statements. Even though Oracle JDBC supports the use of standard batching for Statement and CallableStatement objects, you are[b][u] unlikely[/u][/b] to see performance improvement.

Open in new window


so in order to use a  REAL batch mode for PL/SQL prepare statement, what should I do ?

or it means must be handle in java library when calling:

...
Statement stmt = conn.createStatement();

stmt.addBatch("INSERT INTO emp VALUES(1000, 'Joe Jones')");
stmt.addBatch("INSERT INTO dept VALUES(260, 'Sales')");
stmt.addBatch("INSERT INTO emp_dept VALUES(1000, 260)");
...

Open in new window


?

then it still related to prepared statement ?
0
is there a easy way of writing the below query
in the below query MAX (SIGN (act_qty) is creating an issue
0
hi,

I ask this :

https://www.experts-exchange.com/questions/29148979/MariaDB-coding-standard.html

and

https://www.experts-exchange.com/questions/29148737/MariaDB-SQL-standard.html

before on MariaDB. how about for oracle 12c or 19c, any good URL for me to reference ?
0
I have a oracle table in which a column has image stored in BLOB datatype. Image types stored are TIFF,JPG,GIFF etc . I want to move data from this table and insert into another table with a BLOB column but i want to convert all images to only JPEG format and i want to compress the image size to 20KB and store in new table.

Please advise how to achieve this using some Oracle plsq program
0
We are looking at a used Dell MD4310 Powervault to use as the storage array for a 2 node Oracle RAC setup. Will a Powervault work for setting up ASM and be accessible from both nodes? It looks like it only has SAS connectivity (2 cards). If thats the case I'm not sure how/if it would work.
0
I am working on creating a conceptual model based on the business requirement document. Plan to use sql server as a backend (agreed db has nothing to do with conceptual model).

Can you please suggest  some tools which can help me to build the model quickly.
0
What is the difference between Oracle Data Guard & Oracle Active Data Guard ?
0
Help, I have a problem and I don't even know where to start:

Write a PL/SQL procedure, parse_name, which accepts a string representing names and returns the first name, the
last name, and the title. The first name and last name returned from the procedure should be in upper cases while the title
returned should presever the orginal case. The input name string is in one of the following two formats:
FIRST_NAME LAST_NAME TITLE
LAST_NAME, FIRST_NAME TITLE

The first format depicts that the name string starts with a person’s first name and last name with a space in between, followed by
a space, and then the title of the person. On the other hand, the second format states that the name string starts with a person’s
first name, followed by a comma and a space, and then the last name suffixed with the title with a space before it.

The following are examples of valid name strings conforming to the formats:
1) Jane Doe Ms.
2) Doe, Jane Ms.
Your procedure should return JANE for first name, DOE for last name, and Ms. for title for the above two input strings.

Also, the following are examples of valid name strings conforming to the formats:
1) Jane Doe MS.
2) Doe, Jane MS.
Your procedure should return JANE for first name, DOE for last name, and MS. for title for the above two input strings.

Your procedure should generate exceptions if any one of the three components of the input name string is missing. Further, a
message should be printed indicating that the …
0
How do I generate a QR code in APEX 5.0, I know very little about apex.
Thanks
0
Hello,

To begin with, I am new entrant into Oracle SOA technology.

In the current SOA 12c production environment hosted on Windows server we have 2 node configured with High availability. Architecture looks like

Admin Server DHQAPP132
soa_server1 DHQAPP132  Listen Address DHQAPP132
soa_server2 DHQAPP129  Listen Address DHQAPP129

I could see there is Oracle SOA installation on both servers hosted on the D drive of app132 and app129

Requirement : Add one more soa server into the mix with high availability. i.e soa_server3.
We are planning to first test this in lower environment.

As I am new into this technology, can your advise the following
a) Configuration steps to extend another server

Regards
Thomas
0
we use Payara on Centos 7 Java8 with Oracle. We have enabled the JDBC cache. Now we get the ORA-01438 error. If we turn off the cache we don't get the error anymore, the application is very slow. Does anyone have the experience for this constellation?
This the Parameter.
<protocol name="http-listener-1">
   <http max-connections="500" timeout-seconds="60" default-virtual-server="server">
        <file-cache enabled="true" max-age-seconds="3600"></file-cache>
   </http>  
</protocol>

Open in new window

0
Oracle Database  - Correct privileges.

Hi,

I was hoping someone could help with with some questions around privileges.

I have a program that creates views on the fly.  The names of the views change for a number of reasons.  I have a user that I want to be able to select on any view that has been created in that particular schema.

I've been granted create any view.  So I seem to be able to create them but not select from them.


thank you,
0
Hi expert.
I have Oracle 11g r2 version on Windows.
I want to open the enterprise manager.
What kind of settings do I have to make?
ı don't work the enterprise manager.
thanks
0
I install oracle 12C client and try to connect to oracle database in server.
from oracle-developer error:
Status : Failure -Test failed: IO Error: The Network Adapter could not establish the connection

And tnsping from my local says:
TNS-12535: TNS:operation timed out
how to resolve this issue.
my tnsnames.ora entry is:
"name" =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL= TCP)(Host= ip_address )(Port= 1521))

    (CONNECT_DATA = (SID = "database_name"))

  )
0
I am trying to combine data elements from 2 Oracle 12c tables that have different date segments.    Each table contains date ranges.  I am trying to produce a resultset of the two tables with individual date segments.

DDL:

create table table_1
(cust_no varchar2(11) not null,
cust_first_name  varchar2(40),
cust_last_name   varchar2(40),
cust_aid_catg_cd varchar2(10),
beg_elig_dt    date not null,
end_elig_dt   date);
 

create table table_2
(
person_no                 varchar2(11) not null,
ELIG_CD                   varchar2(10),
VALID_FR_DT               DATE,
VALID_TO_DT               DATE );
 

DML:

insert into table_1
(cust_no, cust_first_name, cust_last_name   , cust_aid_catg_cd, beg_elig_dt, end_elig_dt)
select '0000000001','Robert','Johnson','52',to_date('09/01/2002','mm/dd/yyyy'),to_date('04/30/2011','mm/dd/yyyy')  from dual;
insert into table_1
(cust_no, cust_first_name, cust_last_name   , cust_aid_catg_cd , beg_elig_dt, end_elig_dt)
select '0000000001','Robert','Johnson','26',to_date('05/01/2011','mm/dd/yyyy'),to_date('04/30/2014','mm/dd/yyyy')  from dual; 
insert into table_1
(cust_no, cst_first_name, cust_last_name   , cust_aid_catg_cd, beg_elig_dt, end_elig_dt)
select '0000000001','Robert','Johnson','52',to_date('05/01/2014','mm/dd/yyyy'),to_date('03/31/2015','mm/dd/yyyy') from dual;


insert into table_2 (person_no, elig_cd, VALID_FR_DT   , VALID_TO_DT)
select '0000000001','99',to_date('02/07/2008','mm/dd/yyyy'),to_date('03/05/2008','mm/dd/yyyy') from 

Open in new window

0

Oracle Database

79K

Solutions

26K

Contributors

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.