What Oracle DBAs must know in a new environment

Here, without talking about the big things, like knowing the whole IT environment, assuming you already know that, then you have to deal with these living database. Here is a summary of some general ideas to face a full first database, so that you quickly understand the environment you are facing summary.

This is not a teaching section, just some experience and experience, for this problem, everyone's perspective is different. Welcome you to continue to complement the perfect.

1, first to understand the current Oracle database version and platform and related information

This is very important, busy for a long time also know what version of your database, running on what system, it is not very sad, so I personally think this is the first step need to understand. The following scripts can help you get the information you need.

select　*　from　v$version;
select　*　from　dba_registry_database;
select　 dbid,　name,　open_mode,　database_role,　platform_name　from　v$instance;
select　 dbms_utility.port_string　from　dual;
set　serveroutput　on
declare
ver　VARCHAR2 (100);
compat　VARCHAR2(100);
begin
dbms_utility.db_version(ver,　 compat);
dbms_output.put_line('Version:　'　||　ver　||'　Compatible:　'　||　 compat);
end;
/

2. Second, understand what components are loaded in your database

select　*　from　dba_registry;

3. Do you know if this environment is a stand-alone or a cluster?

There are a lot of ways to judge this, and I'm going to give you a way to judge using dbms_utility.

set　serveroutput　on
declare
inst_tab　 dbms_utility.instance_table;
inst_cnt　NUMBER;
begin
if　 dbms_utility.is_cluster_database　then
dbms_utility.active_instances(inst_tab,　 inst_cnt);
dbms_output.put_line('-'　||　inst_tab.FIRST);
dbms_output.put_line (TO_CHAR(inst_cnt));
else
dbms_output.put_line('Not　A　Clustered　Database');
end 　if;
end;
/

[NextPage]