Protected: Algoritmul de extragere al radicalului
There is no excerpt because this is a protected post.
ORA-16623: member detected role change
Playing with dataguard failover scenarios I bumped into this error: That’s due to inconsistent information within the broker files from both servers. To fix this, we can do this:
TNS-12564: TNS:connection refused while reinstating a failed database
One of the reasons for getting this error might be that the sqlnet.ora does not contain the proper settings like in this particular case: As you can see there is nothing set in sqlnet.ora. Therefor when I was trying to reinstate a former PRIMARY as STANDBY, I was seeing in alert log of the reinstated…
ORA-02304: invalid object identifier literal while executing IMPDP
While cloning a schema within the same database, I encountered the following exception: While I was interested in importing only table data, I have created the following PARFILE: And the execution was looking like this: This is happening due to the fact that when executing the import, the impdp is trying to create those objects…
Changing the Oracle Database Characterset
Hi,This is how you can change the character set of your Oracle DB. Checking the actual values: We want to change NLS_CHARACTERSET to WE8ISO8859P1 which is now WE8MSWIN1252. I checked again and:
RMAN-05609: Must specify a username for target connection when using active duplicate
While I was trying to duplicate my database I got this error: orcl_pri> rman target / auxiliary sys@orcl_dr Recovery Manager: Release 12.1.0.2.0 – Production on Mon Apr 15 13:50:51 2019 Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved. connected to target database: ORCL (DBID=XXXXXXXXXX) auxiliary database Password: connected to auxiliary database: ORCL…
How to drop a database
One of the ways is this: [oracle@srv3 ~]$ ps -eaf | grep pmon oracle 10435 10414 0 10:22 pts/1 00:00:00 grep –color=auto pmon oracle 31892 1 0 06:49 ? 00:00:00 ora_pmon_ORCL [oracle@srv3 ~]$ sqlplus / as sysdba SQL*Plus: Release 12.2.0.1.0 Production on Tue Jan 22 10:22:55 2019 Copyright (c) 1982, 2016, Oracle. All rights reserved.…
Linux mpstat Command
What is mpstat? mpstat is used to monitor cpu utilization on your system. It will be more useful if your system has multiple processors. The first processors will signed as CPU 0. The second one will be signed CPU 1 and so on. The mpstat command writes to standard output activities for each available processor,…
EM 12c, 13c: Enterprise Manager Cloud Control Agent Install Fails at Initialization Step With Error: SSH daemon (sshd) is not running on port 22
This error can occur due to one of the following reasons: 1. SSH port 22 is blocked by proxy / firewall on the Target machine 2. SSH is not running on the Target machine 3. SSH daemon is running on non-default port (other than 22) 1. Verify that the SSH port 22 is not blocked…
