Error ORA-27492 Found error ORA-27492 when executed a tuning job. BEGIN SYS.DBMS_SCHEDULER.RUN_JOB (job_name => ‘SYS.SQLTUNE_JOB_61535_2043’ ,use_current_session => FALSE); END; Error at line 2 ORA-27492: unable to run job “SYS”.”SQLTUNE_JOB_61535_2043″: scheduler unavailable ORA-06512: in “SYS.DBMS_ISCHED”, line 209 ORA-06512: in “SYS.DBMS_SCHEDULER”, line 594 ORA-06512: in line 2 […]
If we were trying to change parameters in an unfamiliar database that was handed over from other DBA, we have to figure it out whether the database started with SPFILE or PFILE. Moreover, if PFILE is used, you have to know the location of PFILE. Of course, we can ask the former DBA for the […]
Names Among MAA Under Oracle Maximum Availability Architecture (MAA), we might be confused about various kinds of name. Here I try to clarify these names by chart and table. DB_NAME (Enterprise-wide Name) You must set this parameter for every instance in order to startup the database. If you didn’t assign DB_NAME at installation-time, then DB_NAME […]
STATSPACK ORA-00001 Login as PERFSTAT and took a snapshot like the following statement. But it failed with ORA-00001. SQL> exec statspack.snap(i_snap_level=>5); BEGIN statspack.snap(i_snap_level=>5); END; * ERROR at line 1: ORA-00001: unique constraint (PERFSTAT.STATS$SQL_SUMMARY_PK) violated ORA-06512: at “PERFSTAT.STATSPACK”, line 1361 ORA-06512: at “PERFSTAT.STATSPACK”, line 2442 ORA-06512: at “PERFSTAT.STATSPACK”, line 91 ORA-06512: at line 1 This is […]
ORA-02085 I created a database link without any problem. But when I tried to test the link, I got ORA-02085. SQL> select sysdate from dual@source_link; select sysdate from dual@source_link * ERROR at line 1: ORA-02085: database link SOURCE_LINK connects to SOURCE_DATABASE Let’s see […]
Given a session was consuming lots of resource on Oracle database server, what should we do about the session? Killing the session might be an option for DBA, but all the uncommitted transactions will be rolled back and there could be no one knows how to continue the job.Set the target PID for debug.SQL> oradebug […]
In an unfamiliar environment, if there’s only oracle or grid account is available for DBA to use, how can he to know everything about the database in a short time?StandaloneFor a standalone, you can do this:Oracle Home[oracle@test ~]$ echo $ORACLE_HOME/u01/app/oracle/product/11.2.0Oracle SID (Instance Name)[oracle@test ~]$ echo $ORACLE_SIDORCLIf there’s no $ORACLE_SID, you may check smon, the background process […]
You can have this one:SQL> ALTER DATABASE OPEN READ ONLY;And also this one:SQL> ALTER DATABASE OPEN RESETLOGS;But there’s NO combined statement like this.SQL> ALTER DATABASE OPEN READ ONLY RESETLOGS;You cannot use the RESETLOGS clause with a READ ONLY clause. (Reference: Opening a Database in Read-Only Mode)That is, you have to go there by three steps.Open the database […]
At times, you may find out or feel that UNDO_RETENTION is useless at all. Raising the number of seconds cannot resolve ORA-01555. This is true under some specific conditions. Here I quote the requisites from the official document below: Fix-sized Undo Tablespace The UNDO_RETENTION parameter is ignored for a fixed size undo tablespace. The database […]
In my opinion, the reason in short is that the unified audit systematically unify all required audit operations into a single, consolidated fashion.According Oracle 12c documentation, you can see what UA is about.The unified audit trail, which resides in a read-only table in the AUDSYS schema in the SYSAUX tablespace, makes this information available in […]