ASM

How to Resolve SPFILE in DB_UNKNOWN

Posted on
SPFILE in DB_UNKNOWN When I tried to restore SPFILE to the default location at nomount state, I found that SPFILE was restored to a DB_UNKNOWN in ASM. Is it a bug dedicated to Oracle 10g RAC (Bug 5370663)? No, I saw it too in 12c R1 RAC restoration. Let’s reproduce the problem. First, check what […]
Oracle Home

How to Move ORACLE HOME

Posted on
Allow me to ask you a question before going further: why would you like to move ORACLE HOME to another place? You may leave your comment below this post, I am curious about it. As for me, it’s because my client like old-fashioned file structure and don’t like Optimal Flexible Architecture (OFA) to be used, […]
Listener

How to Add Static Service Registered in Listener

Posted on
Static Service Registration Dynamic service is a representative which is registered with the listener when the instance is up and running on the server, whereas static service can be used to service external connections with or without a running instance on the server. According to Oracle 18c Advanced Features of Oracle Net Services, the use […]
Administration

How to Know Everything about an Unfamiliar Database

Posted on
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 […]
Database

What Symbols are Used in Oracle Database

Posted on
Several symbols that are used in Oracle might represent different meanings in different place. Question mark ? ORACLE HOME ? (a Question Mark) in a path string represents the environmental variable of ORACLE_HOME. It’s usually $ORACLE_HOME in UNIX or Linux, %ORACLE_HOME% in Windows. SQL> alter tablespace temp add datafile ‘?/dbs/temp02.dbf’ size 200M; You may also […]
Listener

How to Resolve ORA-12560 on Windows Server

Posted on
I have two error patterns on ORA-12560, one is related to ORACLE_SID problem, the other is related to the limitation of PROCESSES. ORA-12560 due to Incorrect ORACLE_SID First of all, allow me reproduce the error ORA-12560 for you. Check the instance name and current status. C:\Users\Administrator>sqlplus / as sysdba SQL*Plus: Release 12.2.0.1.0 Production on Thu […]