Scheduled job does not work in Oracle SQL * PLUS

I'm just a newbie in Oracle and can't seem to get this work to work: –

I want to delete the old lines from my database. And created a job as follows: –

CREATE OR REPLACE PROCEDURE delete_trips
AS
    BEGIN
        DBMS_OUTPUT.PUT_LINE('Here');
        DELETE FROM trip y where sysdate > y.arrival_date;
    END;
/
BEGIN
    DBMS_SCHEDULER.CREATE_JOB(
        job_name        => 'delete_old_rows',
        job_type        => 'PLSQL_BLOCK',
        job_action      => 'EXECUTE delete_trips;',
        start_date      => sysdate,
        repeat_interval => 'FREQ=SECONDLY',
        end_date        => add_months(sysdate,12),
        auto_drop       => FALSE,
        enabled         => TRUE
    );
END;
/

After running the above code, I can see that the work & # 39; delete_old_rows & # 39; is scheduled in DBA_SCHEDULER_JOBS, but neither the rows are deleted nor the output is produced in the terminal. I have tried to disconnect and reconnect, but no lines have been deleted and no output has been produced. And lines fulfilling the deletion condition exist. Please help. What am I missing?

ORACLE TABLESPACE USERS ARE 100% USED

I am having a problem with the oracle users' tablespace. It develops automatically very quickly. What type of data is stored there? And what happens when it reaches 100% of the space used? Is there a solution to reduce the amount of data in this logical disk space? At the moment we have 11 MB of free space out of a total of 33 GB. Is it a good idea to delete it? Thank you.

How to find the missing sequence number in Oracle (the sequence number can be recycled in the same or the following date)

i face the same problem already archieved one.

Can you please provide the solution for the problem below?

I have below the table group master

groupid, from_no, to_no
1,00,99
2000999
3,0000,9999

history_table groupid, date_timestamp (date || hh24: mi: ss), sequenceno
1.20200220 20: 10: 01.00
1.20200220 20: 10: 02.01
1.20200220 20: 10: 03.02
1.20200220 20: 10: 05.04
.
.
1.20200220 20: 10: 05.99
(03) missing sequence number
1.20200220 20: 11: 02.01
1.20200220 20: 11: 05.04
. .
1.20200220 20: 11: 05.99

(00.02.02) missing sequence number

2.20200220 20: 10: 02.001
2.20200220 20: 10: 03.002
2.20200220 20: 10: 05.004
. .
2.20200220 20: 10: 05.099

(000.003) missing sequence number

2.20200220 20: 11: 02.001
2.20200220 20: 11: 05.004
. .
2.20200220 20: 11: 05.099
(000.02.02) missing sequence number

another important example
3.20200220 23: 59: 57,0001
3.20200220 23: 59: 58,0002
3.20200220 23: 59: 59,0004
3.20200221 00: 59: 59,0008 (the next day)
3.20200221 01: 59: 59.0010 3,
20200221 02: 59: 59.0011
. .
3.20200221 04: 10: 05.0099
(0000,0003,0005,0006,0007) missing sequence number
3.20200221 05: 11: 02.0001
3.20200221 05: 11: 06,0004
. .
3.20200221 14: 11: 05.0099

(0000,0002,0003) missing sequence number

The real problem is that I should identify the missing sequence number. the sequence group can repeat itself on the same day or fall on another day.

Oracle 10G

Thanks in advance Naveenkumar

macos – How to configure JDBC on mac using eclipse and Oracle

I have already used eclipse to work on Java projects under Windows, Oracle and eclipse were already configured by my supervisor. I want to use it on a mid-2014 personal MacBook Pro running on Catalina.
I tried to configure VMWare Fusion on Windows, but the Oracle installation always ends with a TNS protocol error. Please guide me to configure and connect to my Mac / in a virtual machine from installation to project creation.

P.s: Right now, I have successfully installed eclipse in macOS.

sql – Doubts about data transformation in ORACLE

Hello, I wonder if there is a way in the ORACLE database to do some transformation:

How it looks x How I want it to be presented.

The data is all mixed on one line in the region column, so I would break it up by taking the commas and transforming it into a table like this second format.

I appreciate if you can help me.

Oracle Goldengate Service Does Not Start: Cannot Retrieve Name of Missing Oracle Recovery Log

I am trying to start the GG service, when I try to "start my_service" and then start it but it has not started, the status is changed, always starting at s & # 39; 39; stop.
I need to start the Goldengate service .. I don't know what happened to its service and what should fix the problem. Help me guys

My service name is: MY_SERVICE

HERE IS THE JOURNAL:

 2020-02-17 14:52:37  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): start MY_SERVICE.
2020-02-17 14:52:37  INFO    OGG-00963  Oracle GoldenGate Manager for Oracle, mgr.prm:  Command received from GGSCI on host (192.168.1.100 ):37022 (START EXTRACT MY_SERVICE ).
2020-02-17 14:52:37  INFO    OGG-00960  Oracle GoldenGate Manager for Oracle, mgr.prm:  Access granted (rule #6).
2020-02-17 14:52:37  INFO    OGG-00975  Oracle GoldenGate Manager for Oracle, mgr.prm:  EXTRACT MY_SERVICE starting.
2020-02-17 14:52:37  INFO    OGG-00992  Oracle GoldenGate Capture for Oracle, MY_SERVICE.prm:  EXTRACT MY_SERVICE starting.
2020-02-17 14:52:37  INFO    OGG-03059  Oracle GoldenGate Capture for Oracle, MY_SERVICE.prm:  Operating system character set identified as UTF-8.
2020-02-17 14:52:37  INFO    OGG-02695  Oracle GoldenGate Capture for Oracle, MY_SERVICE.prm:  ANSI SQL parameter syntax is used for parameter parsing.
2020-02-17 14:52:37  INFO    OGG-02095  Oracle GoldenGate Capture for Oracle, MY_SERVICE.prm:  Successfully set environment variable NLS_LANG=AMERICAN_AMERICA.AL32UTF8.
2020-02-17 14:52:37  INFO    OGG-02095  Oracle GoldenGate Capture for Oracle, MY_SERVICE.prm:  Successfully set environment variable ORACLE_SID=MYSNAME.
2020-02-17 14:52:37  INFO    OGG-02095  Oracle GoldenGate Capture for Oracle, MY_SERVICE.prm:  Successfully set environment variable ORACLE_HOME=/u01/app/oracle/product/12.1.0/db_1.
2020-02-17 14:52:37  INFO    OGG-02095  Oracle GoldenGate Capture for Oracle, MY_SERVICE.prm:  Successfully set environment variable NLS_LANG=AMERICAN_AMERICA.AL32UTF8.
2020-02-17 14:52:37  INFO    OGG-02095  Oracle GoldenGate Capture for Oracle, MY_SERVICE.prm:  Successfully set environment variable ORACLE_SID=MYSNAME.
2020-02-17 14:52:37  INFO    OGG-02095  Oracle GoldenGate Capture for Oracle, MY_SERVICE.prm:  Successfully set environment variable ORACLE_HOME=/u01/app/oracle/product/12.1.0/db_1.
2020-02-17 14:52:38  INFO    OGG-03522  Oracle GoldenGate Capture for Oracle, MY_SERVICE.prm:  Setting session time zone to source database time zone 'GMT'.
2020-02-17 14:52:38  INFO    OGG-01815  Oracle GoldenGate Capture for Oracle, MY_SERVICE.prm:  Virtual Memory Facilities for: BR
    anon alloc: mmap(MAP_ANON)  anon free: munmap
    file alloc: mmap(MAP_SHARED)  file free: munmap
    target directories:
    /u01/ogg/BR/MY_SERVICE.
2020-02-17 14:52:38  INFO    OGG-01851  Oracle GoldenGate Capture for Oracle, MY_SERVICE.prm:  filecaching started: thread ID: 140383342216960.
2020-02-17 14:52:38  INFO    OGG-01815  Oracle GoldenGate Capture for Oracle, MY_SERVICE.prm:  Virtual Memory Facilities for: COM
    anon alloc: mmap(MAP_ANON)  anon free: munmap
    file alloc: mmap(MAP_SHARED)  file free: munmap
    target directories:
    /u01/ogg/dirtmp.
2020-02-17 14:52:38  INFO    OGG-01639  Oracle GoldenGate Capture for Oracle, MY_SERVICE.prm:  BOUNDED RECOVERY:  ACTIVE: for object pool 1: p49266_extr.
2020-02-17 14:52:38  INFO    OGG-01640  Oracle GoldenGate Capture for Oracle, MY_SERVICE.prm:  BOUNDED RECOVERY: recovery start XID: 0.0.0.
2020-02-17 14:52:38  INFO    OGG-01641  Oracle GoldenGate Capture for Oracle, MY_SERVICE.prm:  BOUNDED RECOVERY: recovery start position: SeqNo: 11932, RBA: 25311476, SCN: 1.353105371 (4648072667), Timestamp: 2019-12-30 16:06:40.000000, Thread: 2.
2020-02-17 14:52:38  INFO    OGG-01642  Oracle GoldenGate Capture for Oracle, MY_SERVICE.prm:  BOUNDED RECOVERY: recovery end position: SeqNo: 11932, RBA: 25311476, SCN: 1.353105371 (4648072667), Timestamp: 2019-12-30 16:06:40.000000, Thread: 2.
2020-02-17 14:52:38  INFO    OGG-01643  Oracle GoldenGate Capture for Oracle, MY_SERVICE.prm:  BOUNDED RECOVERY: CANCELED: for object pool 1: p49266_extr.
2020-02-17 14:52:38  INFO    OGG-01579  Oracle GoldenGate Capture for Oracle, MY_SERVICE.prm:  BOUNDED RECOVERY: VALID BCP: CP.MY_SERVICE.000002823.
2020-02-17 14:52:38  INFO    OGG-01629  Oracle GoldenGate Capture for Oracle, MY_SERVICE.prm:  BOUNDED RECOVERY: PERSISTED OBJECTS RECOVERED: <>.
2020-02-17 14:52:40  WARNING OGG-02045  Oracle GoldenGate Capture for Oracle, MY_SERVICE.prm:  Database does not have streams_pool_size initialization parameter configured.
2020-02-17 14:52:40  INFO    OGG-02248  Oracle GoldenGate Capture for Oracle, MY_SERVICE.prm:  Logmining server DDL filtering enabled.
2020-02-17 14:54:47  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): info all.
2020-02-17 14:55:41  ERROR   OGG-02037  Oracle GoldenGate Capture for Oracle, MY_SERVICE.prm:  Failed to retrieve the name of a missing Oracle redo log.
2020-02-17 14:55:41  ERROR   OGG-00662  Oracle GoldenGate Capture for Oracle, MY_SERVICE.prm:  OCI Error retrieving bind info for query (status = 100).
2020-02-17 14:55:41  ERROR   OGG-01668  Oracle GoldenGate Capture for Oracle, MY_SERVICE.prm:  PROCESS ABENDING.

How to find the administrator user of a pluggable database in Oracle 12c

I am creating a script and I need to know who is the administrator of the pluggable database. I can't find anything in the documentation.

Another question is, what happens if I delete an administrator user from the pluggable database? Is there a problem?

oracle – SELECT TO_NUMBER (& # 39; MUST_BE_SAME_TIMEZONE_FILE_VERSION & # 39;) – Database administrators stack the exchange

I am upgrading Oracle from 11.1.0.6.0 (32 bit version) to 11.2.0.1.0 (64 bit version) using RMAN on the same Windows computer (64 bit).

Once RMAN is restored and recovered, I then try to launch

SQL> startup upgrade;
SQL> @?/admin/catupgrd.sql

I had the following errors:

SELECT TO_NUMBER('MUST_BE_SAME_TIMEZONE_FILE_VERSION')
ERROR at line 1: ORA-01722: invalid number

My time zone version is

SELECT version FROM v$timezone_file;
timezlrg_11.dat VERSION: 11

select * from sys.registry$database;
Microsoft Windows IA (32-bit)
TZ_VERSION: 4

Oracle – impdp – import partition

I truncated a partition and would like to import it from the backup.

How can I import a partition from the dump file?

Export the log:

. . exported "XY_PROD"."XY_LOG_PLSQL"              69.16 MB  320459 rows
. . exported "XY_PROD"."XY_RESPONSE":"SYS_P25129"  2.198 GB   67804 rows
. . exported "XY_PROD"."XY_RESPONSE":"SYS_P26385"  973.4 MB   31742 rows
. . exported "XY_PROD"."XY_RESPONSE":"SYS_P25395"  2.184 GB   88242 rows
. . exported "XY_PROD"."XY_RESPONSE":"SYS_P25891"  3.366 GB  106484 rows

Tried:

INCLUDE=PARTITION:"IN ('SYS_P25129')"
INCLUDE=PARTITION:"XY_RESPONSE":"SYS_P25129"
INCLUDE=PARTITION:"XY_RESPONSE":"SYS_P25129"

Get:

ORA-39001: invalid argument value
ORA-39071: Value for INCLUDE is badly formed.
ORA-00920: invalid relational operator

The whole table is several GB. If there is a way, I don't want to import the whole table.

oracle – Listener (lsnrctl) reload vs stop / start

Some blogs say that reloading is an equal stop and start, but in my test this does not interrupt the listener (availability does not change).

When can I only use the reload and when should I stop / start the listener? Does stop / start simply validate the configuration applied for all current connections? (force all connections to reconnect in the listener)?