EXPDP Error ORA-39374 + ORA-13158 The Oracle object does not exist

When exporting one of the tables from my database, I had the following error:

Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
ORA-39374: Statistics failed to export. Failing error is
ORA-13158: Oracle object 3752503189677886288 does not exist
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT

After that, on the general impression where my export is going, I saw . . Exported TABLE_NAME 51.31 GB 273283803 rows but the same is not printed in the log expdp ..

Moreover, the export order could not come back for nearly 8 hours, after which I tried to close it with force. Ctrl-C + Export> kill_job which also did not close the export session in a clean way.

dba_datapump_jobs:

+------------+---------------------+-----------+----------+-----------+--------+-------------------+-------------------+
| OWNER_NAME | JOB_NAME            | OPERATION | JOB_MODE | STATE     | DEGREE | ATTACHED_SESSIONS | DATAPUMP_SESSIONS |
+------------+---------------------+-----------+----------+-----------+--------+-------------------+-------------------+
| APPUSER    | SYS_EXPORT_TABLE_02 | EXPORT    | TABLE    | EXECUTING | 1      | 0                 | 2                 |
+------------+---------------------+-----------+----------+-----------+--------+-------------------+-------------------+

I can not understand why my export job failed and, more importantly, how to close the active sessions cleanly.

expdp command

expdp user/pass directory=TEST_DIR dumpfile=xxx.dmp logfile=xxx.log tables=TABLE_NAME

Databases – How to securely access Oracle system user credentials from my installation program

We have an installation program that we have built with the help of scripts. When we start the installation program, it asks the user and password of the database system, which it needs to create application users. We do not want the user performing the installation to know the password of the system user. Therefore, we are looking for ways to proceed with the installation without sharing the password of the system user. Few things we have explored.
Encrypting the password of the system user with the help of a utility. This is not very feasible, since we have to integrate the key in the installation program, which is not obscured / encrypted (basically, the user can read it in l & # 39; opening)
Darken the utility used for encryption and installation program. It was ok, but it is still not safe, because the darkening itself is not foolproof.

Is there another way, it can be managed. Is there an Oracle API that we can use? Please suggest.

Upgrading Oracle Linux 6.8 to 7.x

I'm trying to upgrade my Oracle Linux operating system from 6.8 t0 7.x by following the steps provided here https://docs.oracle.com/en/operating-systems/ oracle-linux / 7 / relnotes7.5 / ol7 -upgrade-ol6.html

However, I'm stuck with the step below where I get the treeinfo Error not found.

redhat-upgrade-tool-cli --network=7.5 --instrepo=http://yum.oracle.com/​repo/​OracleLinux/​OL7/​UEKR5/​RDMA/​x86_64 --debuglog=/tmp/upgrade.log --cleanup-post

MISTAKE

redhat_upgrade_tool.yum ERROR: Error downloading .treeinfo or treeinfo from repo http://yum.oracle.com/repo/OracleLinux/OL7/UEKR5/RDMA/x86_64/: [Errno 14] PYCURL ERROR 22 - "The requested URL returned error: 404 Not Found"

I do not know if it is possible to do an on-site upgrade for OLS or not, any help would be really appreciated.

Oracle Cloud Stopping for Inactivity

I have an Oracle Cloud standalone database running in the free level. Sometimes the database stops. During the consultation on the website, the details indicate that he was arrested due to inactivity.

However, this sometimes happens only a few minutes after reading and writing in the database!

Why is this happening? Is there anything I can do about it?

What is the default quota on a tablespace for a given user in oracle if you do not set it?

My environment

j & # 39; uses Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

Explanation of the situation

I created a user with the following command

create user USRPRACTICA2 identified by 1234 default tablespace users;

So, I gave it a default tablespace, but I did not specify any quota limits. So I went to the Oracle documentation, and I read this:

By default, a user has no quota on the tablespaces in the database. If the user has the privilege of creating a schema object, you must assign a quota to allow him to create objects. Minimize the quota for the default table space and additional quotas for other tablespaces where they can create objects.

So I said good, okay! Now, I want to test if this user really can not create tables, for example, if I have not assigned a quota.
Then I granted him these privileges:

grant create session to USRPRACTICA2;
grant create table to USRPRACTICA2; 

Well, I should not be able to create tables because I did not specify a quota for tablespace users. Let's try.
I'm creating a connection with USRPRACTICA2 to Oracle, I'm trying to create a table and here's what happens:

SQL> CREATE TABLE EMP
  2  (EMPNO NUMBER(4) NOT NULL,
  3  ENAME VARCHAR2(10),
  4  JOB VARCHAR2(9),
  5  MGR NUMBER(4),
  6  HIREDATE DATE,
  7  SAL NUMBER(7, 2),
  8  COMM NUMBER(7, 2),
  9  DEPTNO NUMBER(2));

Tabla creada.

Oops! The table has been created.

Right now, it's when I think "well, now we should try to figure out what the quota is for this user on this tablespace, maybe there's a default quota in oracle". So I tried this:

SQL> select tablespace_name, username, max_bytes
  2     from dba_ts_quotas
  3     where username = 'USRPRACTICA2' and TABLESPACE_NAME = 'USERS';

no rows selected

At this point, I thought that "it's nonsense, maybe I did not write the query properly", so I tried this:

SQL> select * from dba_ts_quotas;

TABLESPACE_NAME                USERNAME                                                                                                                      BYTES  MAX_BYTES     BLOCKS MAX_BLO
------------------------------ -------------------------------------------------------------------------------------------------------------------------------- ---------- ---------- ----------
SYSAUX                         AUDSYS                                                                                                                       655360         -1         80
SYSAUX                         GSMADMIN_INTERNAL                                                                                                            917504         -1        112
SYSAUX                         DBSFWUSER                                                                                                                         0         -1          0
SYSAUX                         APPQOSSYS                                                                                                                         0         -1          0
SYSAUX                         GGSYS                                                                                                                             0         -1          0
SYSAUX                         OLAPSYS                                                                                                                           0         -1          0

6 rows selected.

So with this information, I assumed that, of course, no quota was allocated to the users' table space for the user I had created.
In addition, I assumed that in Oracle, it should contain a value with the default quota on tablespaces, if you do not set it. Moreover, this user does not have unlimited space on the tablespace either, because it would have appeared in this view with a value "MAX_BYTES -1".

I've gone through a lot of things looking for a default quota value in Oracle, and all I've been able to get, is an oracle extract saying "If the user has the privilege to create a schema object, you must assign him a quota to allow him to create objects." . But obviously, as I showed here, this should be a default quota value somewhere.

Finally, I just tried something else. If you assign a quota value to the user like this

alter user USRPRACTICA2 quota 1M on USERS; 

Now, if you query the tablespace quotas, you will find the information

SQL> select tablespace_name, username, max_bytes
  2     from dba_ts_quotas
  3     where username = 'USRPRACTICA2' and TABLESPACE_NAME = 'USERS';

TABLE USERNAME      MAX_BYTES
----- ------------ ----------
USERS USRPRACTICA2    1048576

So my question is this …

Is there a default quota value assigned to a user in a tablespace if you do not specify it? If so, how can I show this value?

Script to install the Oracle 12c2 client on Redhat linux 7.5

Anyone can help me provide a script that I can use to install the Oracle client as part of building the server or the AMI. The script below was taken from the Oracle site guide. But I still miss something. I've added the main code. Prerequisites are supported.

By this code does not work if it is run as a script. Due to the passage of the user to Oracle just before the execution of the installation program and once completed, it continues to be launched. But the required permissions are already granted. Someone please help.

[INS-30131] Initial setup required for the execution of installer validations failed.
   CAUSE: Failed to access the temporary location.
   ACTION: Ensure that the current user has required permissions to access the temporary location.
*ADDITIONAL INFORMATION:*
 - PRVG-1901 : failed to setup CVU remote execution framework directory "/tmp/CVU_12.2.0.1.0_oracle/" on nodes "ip-10-81-140-134"
 - Cause:  An operation requiring remote execution could not complete because the attempt to set up the Cluster Verification Utility remote execution framework failed on the indicated nodes at the indicated directory location because the CVU remote execution framework version did not match the CVU java verification framework version. The accompanying message provides detailed failure information.
 - Action:  Ensure that the directory indicated exists or can be created and the user executing the checks has sufficient permission to overwrite the contents of this directory. Also review the accompanying error messages and respond to them.
Summary of the failed nodes
ip-10-81-140-134
groupadd oinstall
groupadd dba
sudo useradd -g oinstall -G dba oracle; echo Nbst@AWS01 | passwd oracle --stdin
cd /opt
mkdir app
mkdir app/oracle
chown oracle:oinstall app
chown oracle:oinstall app/oracle
cd /tmp

wget https://amazonaws.com/linuxx64_12201_client.zip
chown oracle:oinstall linuxx64_12201_client.zip
unzip linuxx64_12201_client.zip
chown oracle:oinstall client
cd /tmp/client/
wget https://amazonaws.com/client_install.rsp
chown oracle:oinstall client_install.rsp 
chmod 775 client_install.rsp
sudo su oracle; echo Nbst@AWS01 | passwd oracle --stdin 
export ORACLE_BASE=/opt/app/oracle
export ORACLE_HOME=/opt/app/oracle/product/12.2.0/client_1
/tmp/client/runInstaller -silent -responseFile /tmp/client/client_install.rsp
exit
cd /opt/app/oraInventory/
./orainstRoot.sh
cd /opt/app/oralinventory/
./orainstRoot.sh

cd /opt/app/oracle/product/12.1.0/client_1/network/admin/
wget https://amazonaws.com/tnsnames.ora
chown oracle:oinstall tnsnames.ora
chmod 775 tnsnames.ora

restore – deleted oradata folder under oracle home by accident

When setting up a new server, I accidentally deleted the oradata folder of the active database server.
I do not have backup of the database of work, I have searched on Google and flashback option found to recover, but the oradata folder is deleted, I work on centos.

Are there any options for recovering the database, there was only one schema (user) and user sys.

Thanks in advance

automation – Automation of SQL queries in Oracle

I want to automate an SQL query. This request is executed once a week and a field must be modified by execution. For example, the query is the total number of cars in stock, but changes country each time.

By doing this manually, I would simply run the query, paste the results into Excel, change the country code and relaunch it until the end, the best packages to use to achieve that goal?

I've read about dmbs_scheduler but I'm not sure how to get the results of my queries from this and also not knowing how I combine all my queries, thinking about using procedures

pathfinder 1e – The child cursed Oracle confers eternal youth

There is thus the curse of oracle, called child, which reads as follows. Leaving aside the large number of design flaws. as it is written could it be interpreted as having eternal youth or would it simply prevent you from growing old until you reach the age when you would have died of old age?

Child (3PP) Source Oracle's Curse, copyright 2014 by RJ Grady,
published by Tripod Machine.

You became an oracle at the beginning of your life and your body remained that of a child.

EFFECT You take a penalty of -4
to your force modifier for force checks and your
bonus to maneuver, and earn a bonus of +2 to Escape Artist and Stealth
checks. Your age can not be changed like magic. NPCs can become friends
or hostile (GM's choice) depending on your behavior and the
situation. A non-magic armor must be tailor-made for you, otherwise
it can not be donned in a hurry, though it can be worn at all.

On the 5th level, your Force penalty is reduced to -2.

At level 10, you get a bonus revelation.

At level 15, add either a sacred aura or an impure aura (your choice) to your known spells.

Oracle – How to import a composite primary key in SQL?

I have two entities:

CREATE TABLE COMPRA(
IDCOMPRA INT NOT NULL,
IDCLIENTES INT,
PEDIDO INT,
IDPRENDA INT,
TOTAL NUMBER(8,2),
CONSTRAINT PKCOMPRA
PRIMARY KEY (IDCOMPRA)
);

And order:

CREATE TABLE PEDIDO(
IDCOMPRA INT,
IDPRENDA INT,
TOTAL NUMBER (8,2),
CONSTRAINT PKPEDIDO
PRIMARY KEY (IDCOMPRA,IDPRENDA)
);

The important thing is to be able to access all purchases made by a customer with a unique purchase number.
What is the use of the requested entity if I still need the Prenda entity to import it?
I am pretty confused.