menu
  • Register
Recent questions tagged oracle

Recent questions tagged oracle

0 votes
1 answer 3 views
ora 02049 timeout distributed transaction waiting for lock
Problem: ora 02049 timeout distributed transaction waiting for lock
asked Feb 19 Dan phillip 1.9k points
0 votes
1 answer 7 views
ora-28009: connection as sys should be as sysdba or sysoper
Problem: ora-28009: connection as sys should be as sysdba or sysoper
asked Feb 18 Ethan ross 1.8k points
0 votes
1 answer 3 views
java sql sqlexception no suitable driver found for
Problem: Java program to demonstrate this error. This program reproduce this error by first leaving out the required JDBC JAR from classpath and also not explicitly registering the driver before use by not calling Class.forName() method.
asked Feb 18 Ali 4.4k points
0 votes
1 answer 8 views
tns listener was not given the service_name in connect_data
Problem: tns listener was not given the service_name in connect_data
asked Feb 17 Dan phillip 1.9k points
0 votes
1 answer 7 views
java.sql.sqlexception: ora-28040: no matching authentication protocol
Problem: java.sql.sqlexception: ora-28040: no matching authentication protocol.
asked Feb 15 Ethan ross 1.8k points
0 votes
1 answer 32 views
Ora-24247: network access denied by access control list (acl).
Problem: I have good knowledge of Oracle. Currently I am trying my hand on Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production and also I am trying to use the ftp package (UTL_TCP). Here is the procedure which I have written: declare     l_conn ... setup of a ACL as mentioned by them but still I am unable to figure it out why my network access is denied after the login.
asked Aug 15, 2020 Raphael Pacheco 4.9k points
0 votes
1 answer 32 views
Date format picture ends before converting entire input string.
Problem: I am a beginner in the programming world I badly need to execute the query through Java like shown below: public ResultSet execSumStatment2() throws SQLException{ String query = "Select SUM(A) as NCCSeptember from NCC where Datum >= '01-09-2013 00:00:00' and Datum ... the issue is a datatype of my date in my above query which must be Date and everything which I have tried is not working.
asked Jul 25, 2020 Raphael Pacheco 4.9k points
1 vote
1 answer 117 views
Ora-02270: no matching unique or primary key for this column-list.
Problem: I am trying to learn Oracle. I have created two tables their names are Table Employee and Table USER, here is the structure. CREATE TABLE Employee ( ID NUMBER NOT NULL , USERID NUMBER, CONSTRAINT B_PK PRIMARY KEY ( ID ) ENABLE ); CREATE TABLE USER ( ... above error but because of my elementary knowledge on Oracle I am unable to fix it. Kindly guide me in fixing above Oracle error.
asked May 29, 2020 Martin K 6.6k points
1 vote
1 answer 216 views
Ora-02449: unique/primary keys in table referenced by foreign keys.
Problem : I am learning Oracle and trying to create and drop tables. If I try to drop my table it is always showing me below error: DROP TABLE SUBURB; DROP TABLE CITY; DROP TABLE STATE; Error at line 1: ORA-02449: unique/primary keys in table referenced ... already used by an existing object. I am unable to understand the above errors. Can someone guide me in fixing above Oracle related errors?
asked May 12, 2020 Martin K 6.6k points
1 vote
1 answer 64 views
Ora 00119 invalid specification for system parameter local_listener.
Problem : I am very new to Oracle. I can very clearly see from the SQLPLUS startup output that my database is not starting up because in my init.ora file local_listener is setup as the LISTENER and now it says that it is unable to resolve that name. ... figure out my mistake. I need Oracle experts help to fix my bellow error: Ora 00119 invalid specification for system parameter local_listener .
asked Apr 22, 2020 stewart 4k points
0 votes
1 answer 40 views
Java.sql.sqlexception: io exception: the network adapter could not establish the connection
Problem : I am very new to JDBC. Now I am trying to connect to the Oracle 11g database using my ojdbc14 jar on the eclipse kepler IDE with the java 8 on my windows 7 PC. But when I try to run the below code I often face the following error. import ... DB"); } } } And the encountered Error is as below : java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
asked Feb 14, 2020 mphil 2.3k points
0 votes
1 answer 77 views
Ora-00205: error in identifying control file, check alert log for more info
Problem : I am newly installing the Oracle XE database on my Ubuntu by following below steps: Downloaded the latest rpm file for the Oracle XE and ran below commands to install my database: sudo apt-get install alien alien oracle-xe-11.2.0-1.0.x86_64.rpm ... to start my database then I am facing below error “Ora-00205: error in identifying control file, check alert log for more info”
asked Jan 29, 2020 jwilliam 3.9k points
0 votes
2 answers 457 views
Ora-06502: pl/sql: numeric or value error: character string buffer too small
Problem : I tried my Oracle code in different ways, like by taking out a while loop or a if loop, but when I put both loops together (if and while), I always face below error at the end. ERROR: ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at line 13 06502. 00000 -  "PL/SQL: numeric or value error%s"
asked Jan 22, 2020 jwilliam 3.9k points
0 votes
1 answer 98 views
Tns:listener does not currently know of service requested in connect descriptor
Problem : We have the application running locally where we are experiencing the below error: “ORA-12514: TNS:listener does not currently know of service requested in connect descriptor” I have already tested the connection using the TNSPing which resolved it correctly ... running. We are unable to know of any changes that were made to my environment. Anything else that we can test?
asked Jan 6, 2020 alecxe 7.5k points
0 votes
2 answers 321 views
java.sql.sqlrecoverableexception no more data to read from socket
Problem : I am facing bellow error java.sql.sqlrecoverableexception no more data to read from socket
asked Nov 5, 2019 peterlaw 6.9k points
To see more, click for the full list of questions or popular tags.
Dark theme