Oracle 12c Pluggable Database PITR

  1. Full backup alınır.
[oracle@oel65 ~]$ rman target /
Recovery Manager: Release 12.1.0.2.0 - Production on Thu Sep 29 08:30:35 2016
Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.
connected to target database: CDBTEST (DBID=665375450)
RMAN> run
2> {
3> backup database plus archivelog;
4> }
Starting backup at 29-SEP-16
current log archived
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=263 device type=DISK
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=87 RECID=1 STAMP=923819448
channel ORA_DISK_1: starting piece 1 at 29-SEP-16
channel ORA_DISK_1: finished piece 1 at 29-SEP-16
piece handle=+FRA/CDBTEST/BACKUPSET/2016_09_29/annnf0_tag20160929t083049_0.267.923819449 tag=TAG20160929T083049 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 29-SEP-16
Starting backup at 29-SEP-16
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00004 name=+DATA/CDBTEST/DATAFILE/undotbs1.257.923321891
input datafile file number=00001 name=+DATA/CDBTEST/DATAFILE/system.259.923321811
input datafile file number=00003 name=+DATA/CDBTEST/DATAFILE/sysaux.260.923321725
input datafile file number=00006 name=+DATA/CDBTEST/DATAFILE/users.258.923321887
channel ORA_DISK_1: starting piece 1 at 29-SEP-16
channel ORA_DISK_1: finished piece 1 at 29-SEP-16
piece handle=+FRA/CDBTEST/BACKUPSET/2016_09_29/nnndf0_tag20160929t083050_0.268.923819451 tag=TAG20160929T083050 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:05:05
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00018 name=+DATA/CDBTEST/3D910880B85D365AE053673CA8C01B69/DATAFILE/system.277.923756271
input datafile file number=00019 name=+DATA/CDBTEST/3D910880B85D365AE053673CA8C01B69/DATAFILE/sysaux.275.923756271
input datafile file number=00020 name=+DATA/CDBTEST/3D910880B85D365AE053673CA8C01B69/DATAFILE/users.271.923756271
channel ORA_DISK_1: starting piece 1 at 29-SEP-16
channel ORA_DISK_1: finished piece 1 at 29-SEP-16
piece handle=+FRA/CDBTEST/3D910880B85D365AE053673CA8C01B69/BACKUPSET/2016_09_29/nnndf0_tag20160929t083050_0.269.923819757 tag=TAG2
channel ORA_DISK_1: backup set complete, elapsed time: 00:03:25
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00007 name=+DATA/CDBTEST/FD9AC20F64D244D7E043B6A9E80A2F2F/DATAFILE/sysaux.267.923322003
input datafile file number=00005 name=+DATA/CDBTEST/FD9AC20F64D244D7E043B6A9E80A2F2F/DATAFILE/system.266.923322003
channel ORA_DISK_1: starting piece 1 at 29-SEP-16
channel ORA_DISK_1: finished piece 1 at 29-SEP-16
piece handle=+FRA/CDBTEST/3D2BFC64CA164FB8E053673CA8C09958/BACKUPSET/2016_09_29/nnndf0_tag20160929t083050_0.270.923819961 tag=TAG2
channel ORA_DISK_1: backup set complete, elapsed time: 00:02:05
Finished backup at 29-SEP-16
Starting backup at 29-SEP-16
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=88 RECID=2 STAMP=923820087
channel ORA_DISK_1: starting piece 1 at 29-SEP-16
channel ORA_DISK_1: finished piece 1 at 29-SEP-16
piece handle=+FRA/CDBTEST/BACKUPSET/2016_09_29/annnf0_tag20160929t084127_0.272.923820087 tag=TAG20160929T084127 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 29-SEP-16
Starting Control File and SPFILE Autobackup at 29-SEP-16
piece handle=+FRA/CDBTEST/AUTOBACKUP/2016_09_29/s_923820088.273.923820093 comment=NONE
Finished Control File and SPFILE Autobackup at 29-SEP-16
RMAN> exit
Recovery Manager complete.
 
  1. sysdate alınır.
select sysdate from dual;
29/09/2016 08:56:08
  1. scott user’ı unlock edilir.
alter user scott identified by scott account unlock;
  1. scott schemasında değişiklikler yapılır ve commit edilir.
update scott.dept set loc='TUR';
update SCOTT.EMP set SAL=1000;
commit;
  1. pluggable database kapatılır.
alter pluggable database MYPDB12C close immediate;
  1. Point in time recovery başlatılır.
– File system ise ‘auxiliary destination’ kullanılır.
run
{
set until time="to_date('2016-09-29 08:56:08', 'yyyy-mm-dd:hh24:mi:ss')";;
restore pluggable database mypdb12c;
recover pluggable database mypdb12c auxiliary destination '/u01/test/';
alter pluggable database mypdb12c open resetlogs;
}
– ASM ise FRA’da yeterli yer olmalı ve db_recovery_file_dest_size parametresi yeterli olmalıdır.
[oracle@oel65 ~]$ rman target /
Recovery Manager: Release 12.1.0.2.0 - Production on Thu Sep 29 10:04:05 2016
Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.
connected to target database: CDBTEST (DBID=665375450)
RMAN> run
{
set until time="to_date('2016-09-29 08:56:08', 'yyyy-mm-dd:hh24:mi:ss')";
restore pluggable database mypdb12c;
recover pluggable database mypdb12c;
alter pluggable database mypdb12c open resetlogs;
}2> 3> 4> 5> 6> 7>

executing command: SET until clause

Starting restore at 29-SEP-16
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=273 device type=DISK

skipping datafile 18; already restored to file +DATA/CDBTEST/3D910880B85D365AE053673CA8C01B69/DATAFILE/system.277.923756271
skipping datafile 19; already restored to file +DATA/CDBTEST/3D910880B85D365AE053673CA8C01B69/DATAFILE/sysaux.275.923756271
skipping datafile 20; already restored to file +DATA/CDBTEST/3D910880B85D365AE053673CA8C01B69/DATAFILE/users.271.923756271
restore not done; all files read only, offline, or already restored
Finished restore at 29-SEP-16

Starting recover at 29-SEP-16
using channel ORA_DISK_1
RMAN-05026: WARNING: presuming following set of tablespaces applies to specified Point-in-Time

List of tablespaces expected to have UNDO segments
Tablespace SYSTEM
Tablespace UNDOTBS1

Creating automatic instance, with SID='hhEw'

initialization parameters used for automatic instance:
db_name=CDBTEST
db_unique_name=hhEw_pitr_mypdb12c_CDBTEST
compatible=12.1.0.2.0
db_block_size=8192
db_files=200
diagnostic_dest=/u01/app/oracle
_system_trig_enabled=FALSE
sga_target=900M
processes=200
#No auxiliary destination in use
enable_pluggable_database=true
_clone_one_pdb_recovery=true
control_files=+FRA/CDBTEST/DATAFILE/current.282.923825051
#No auxiliary parameter file used


starting up automatic instance CDBTEST

Oracle instance started

Total System Global Area     943718400 bytes

Fixed Size                     2931136 bytes
Variable Size                251659840 bytes
Database Buffers             683671552 bytes
Redo Buffers                   5455872 bytes
Automatic instance created

contents of Memory Script:
{
# set requested point in time
set until  time "to_date('2016-09-29 08:56:08', 'yyyy-mm-dd:hh24:mi:ss')";
# restore the controlfile
restore clone controlfile;

# mount the controlfile
sql clone 'alter database mount clone database';
}
executing Memory Script

executing command: SET until clause

Starting restore at 29-SEP-16
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=15 device type=DISK

channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: restoring control file
channel ORA_AUX_DISK_1: reading from backup piece +FRA/CDBTEST/AUTOBACKUP/2016_09_29/s_923820088.273.923820093
channel ORA_AUX_DISK_1: piece handle=+FRA/CDBTEST/AUTOBACKUP/2016_09_29/s_923820088.273.923820093 tag=TAG20160929T084128
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:03
output file name=+FRA/CDBTEST/DATAFILE/current.282.923825051
Finished restore at 29-SEP-16

sql statement: alter database mount clone database

contents of Memory Script:
{
# set requested point in time
set until  time "to_date('2016-09-29 08:56:08', 'yyyy-mm-dd:hh24:mi:ss')";
# switch to valid datafilecopies
switch clone datafile  18 to datafilecopy
 "+DATA/CDBTEST/3D910880B85D365AE053673CA8C01B69/DATAFILE/system.277.923756271";
switch clone datafile  19 to datafilecopy
 "+DATA/CDBTEST/3D910880B85D365AE053673CA8C01B69/DATAFILE/sysaux.275.923756271";
switch clone datafile  20 to datafilecopy
 "+DATA/CDBTEST/3D910880B85D365AE053673CA8C01B69/DATAFILE/users.271.923756271";
# set destinations for recovery set and auxiliary set datafiles
set newname for datafile  1 to
 "+FRA/CDBTEST/DATAFILE/system.283.923825063";
set newname for datafile  4 to
 "+FRA/CDBTEST/DATAFILE/undotbs1.284.923825065";
set newname for datafile  3 to
 "+FRA/CDBTEST/DATAFILE/sysaux.285.923825065";
set newname for datafile  6 to
 "+FRA/CDBTEST/DATAFILE/users.286.923825075";
# restore the tablespaces in the recovery set and the auxiliary set
restore clone datafile  1, 4, 3, 6;

switch clone datafile all;
}
executing Memory Script

executing command: SET until clause

datafile 18 switched to datafile copy
input datafile copy RECID=3 STAMP=923825074 file name=+DATA/CDBTEST/3D910880B85D365AE053673CA8C01B69/DATAFILE/system.277.923756271

datafile 19 switched to datafile copy
input datafile copy RECID=4 STAMP=923825075 file name=+DATA/CDBTEST/3D910880B85D365AE053673CA8C01B69/DATAFILE/sysaux.275.923756271

datafile 20 switched to datafile copy
input datafile copy RECID=5 STAMP=923825075 file name=+DATA/CDBTEST/3D910880B85D365AE053673CA8C01B69/DATAFILE/users.271.923756271

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting restore at 29-SEP-16
using channel ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00001 to +FRA/CDBTEST/DATAFILE/system.283.923825063
channel ORA_AUX_DISK_1: restoring datafile 00004 to +FRA/CDBTEST/DATAFILE/undotbs1.284.923825065
channel ORA_AUX_DISK_1: restoring datafile 00003 to +FRA/CDBTEST/DATAFILE/sysaux.285.923825065
channel ORA_AUX_DISK_1: restoring datafile 00006 to +FRA/CDBTEST/DATAFILE/users.286.923825075
channel ORA_AUX_DISK_1: reading from backup piece +FRA/CDBTEST/BACKUPSET/2016_09_29/nnndf0_tag20160929t083050_0.268.923819451
channel ORA_AUX_DISK_1: piece handle=+FRA/CDBTEST/BACKUPSET/2016_09_29/nnndf0_tag20160929t083050_0.268.923819451 tag=TAG20160929T083050
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:04:55
Finished restore at 29-SEP-16

datafile 1 switched to datafile copy
input datafile copy RECID=10 STAMP=923825371 file name=+FRA/CDBTEST/DATAFILE/system.283.923825063
datafile 4 switched to datafile copy
input datafile copy RECID=11 STAMP=923825371 file name=+FRA/CDBTEST/DATAFILE/undotbs1.284.923825065
datafile 3 switched to datafile copy
input datafile copy RECID=12 STAMP=923825371 file name=+FRA/CDBTEST/DATAFILE/sysaux.285.923825065
datafile 6 switched to datafile copy
input datafile copy RECID=13 STAMP=923825371 file name=+FRA/CDBTEST/DATAFILE/users.286.923825075

contents of Memory Script:
{
# set requested point in time
set until  time "to_date('2016-09-29 08:56:08', 'yyyy-mm-dd:hh24:mi:ss')";
# online the datafiles restored or switched
sql clone "alter database datafile  1 online";
sql clone "alter database datafile  4 online";
sql clone "alter database datafile  3 online";
sql clone 'MYPDB12C' "alter database datafile
 18 online";
sql clone 'MYPDB12C' "alter database datafile
 19 online";
sql clone 'MYPDB12C' "alter database datafile
 20 online";
sql clone "alter database datafile  6 online";
# recover pdb
recover clone database tablespace  "SYSTEM", "UNDOTBS1", "SYSAUX", "USERS" pluggable database
 'MYPDB12C'   delete archivelog;
sql clone 'alter database open read only';
plsql <<<begin
   add_dropped_ts;
end; >>>;
plsql <<<begin
   save_pdb_clean_scn;
end; >>>;
# shutdown clone before import
shutdown clone abort
plsql <<<begin
   pdbpitr_inspect(pdbname =>  'MYPDB12C');
end; >>>;
}
executing Memory Script

executing command: SET until clause

sql statement: alter database datafile  1 online

sql statement: alter database datafile  4 online

sql statement: alter database datafile  3 online

sql statement: alter database datafile  18 online

sql statement: alter database datafile  19 online

sql statement: alter database datafile  20 online

sql statement: alter database datafile  6 online

Starting recover at 29-SEP-16
using channel ORA_AUX_DISK_1

starting media recovery

archived log for thread 1 with sequence 88 is already on disk as file +FRA/CDBTEST/ARCHIVELOG/2016_09_29/thread_1_seq_88.271.923820087
archived log for thread 1 with sequence 89 is already on disk as file +FRA/CDBTEST/ARCHIVELOG/2016_09_29/thread_1_seq_89.274.923822601
archived log file name=+FRA/CDBTEST/ARCHIVELOG/2016_09_29/thread_1_seq_88.271.923820087 thread=1 sequence=88
archived log file name=+FRA/CDBTEST/ARCHIVELOG/2016_09_29/thread_1_seq_89.274.923822601 thread=1 sequence=89
media recovery complete, elapsed time: 00:00:05
Finished recover at 29-SEP-16

sql statement: alter database open read only



Oracle instance shut down


Removing automatic instance
Automatic instance removed
auxiliary instance file +FRA/CDBTEST/DATAFILE/sysaux.285.923825065 deleted
auxiliary instance file +FRA/CDBTEST/DATAFILE/current.282.923825051 deleted
Finished recover at 29-SEP-16

Statement processed

RMAN>
  1. Kontrol yapılır.
SQL> select * from scott.dept;

    DEPTNO DNAME          LOC
---------- -------------- -------------
        10 ACCOUNTING     NEW YORK
        20 RESEARCH       DALLAS
        30 SALES          CHICAGO
        40 OPERATIONS     BOSTON

SQL> select * from SCOTT.EMP;

     EMPNO ENAME      JOB              MGR HIREDATE                    SAL       COMM     DEPTNO
---------- ---------- --------- ---------- -------------------- ---------- ---------- ----------
      7369 SMITH      CLERK           7902 17-DEC-1980 00:00:00        800                    20
      7499 ALLEN      SALESMAN        7698 20-FEB-1981 00:00:00       1600        300         30
      7521 WARD       SALESMAN        7698 22-FEB-1981 00:00:00       1250        500         30
      7566 JONES      MANAGER         7839 02-APR-1981 00:00:00       2975                    20
      7654 MARTIN     SALESMAN        7698 28-SEP-1981 00:00:00       1250       1400         30
      7698 BLAKE      MANAGER         7839 01-MAY-1981 00:00:00       2850                    30
      7782 CLARK      MANAGER         7839 09-JUN-1981 00:00:00       2450                    10
      7788 SCOTT      ANALYST         7566 19-APR-1987 00:00:00       3000                    20
      7839 KING       PRESIDENT            17-NOV-1981 00:00:00       5000                    10
      7844 TURNER     SALESMAN        7698 08-SEP-1981 00:00:00       1500          0         30
      7876 ADAMS      CLERK           7788 23-MAY-1987 00:00:00       1100                    20
      7900 JAMES      CLERK           7698 03-DEC-1981 00:00:00        950                    30
      7902 FORD       ANALYST         7566 03-DEC-1981 00:00:00       3000                    20
      7934 MILLER     CLERK           7782 23-JAN-1982 00:00:00       1300                    10

14 rows selected.

 

  1. Incarnation’ı kontrol ediyorum.
SQL> alter session set container=mypdb12c;

Session altered.

SQL> select DB_INCARNATION#,PDB_INCARNATION#,INCARNATION_TIME from v$pdb_incarnation;

DB_INCARNATION# PDB_INCARNATION# INCARNATION_TIME
--------------- ---------------- --------------------
              2                1 29-SEP-2016 08:56:30
              2                0 23-SEP-2016 14:19:10

SQL> select INCARNATION#,RESETLOGS_TIME from v$database_incarnation;

INCARNATION# RESETLOGS_TIME
------------ --------------------
           1 07-JUL-2014 05:38:47
           2 23-SEP-2016 14:19:10
Kolay gelsin.

Exadata X6-2 EF (1/8) MBPS and IOPS results

Selamlar,

bir müşterimizde Exadata X6-2 EF 1/8 kurumunu gerçekletirdik. Aşağıdaki Flash disklerinin calibrate sonuçlarını görebilirsiniz.

Aggregate random read throughput across all flash disk LUNs: 17143 MBPS
Calibrating flash disks (read only, note that writes will be significantly slower) ...
LUN 0_0  on drive [NVME_0 ] random read throughput: 2,774.00 MBPS, and 281609 IOPS
LUN 0_1  on drive [NVME_1 ] random read throughput: 2,561.00 MBPS, and 264244 IOPS
LUN 0_10 on drive [NVME_10] random read throughput: 2,510.00 MBPS, and 275078 IOPS
LUN 0_3  on drive [NVME_3 ] random read throughput: 2,641.00 MBPS, and 287430 IOPS
LUN 0_4  on drive [NVME_4 ] random read throughput: 2,761.00 MBPS, and 290047 IOPS
LUN 0_6  on drive [NVME_6 ] random read throughput: 2,717.00 MBPS, and 284153 IOPS
LUN 0_7  on drive [NVME_7 ] random read throughput: 2,234.00 MBPS, and 255161 IOPS
LUN 0_9  on drive [NVME_9 ] random read throughput: 2,658.00 MBPS, and 287121 IOPS

Aggregate random read throughput across all flash disk LUNs: 14751 MBPS
Calibrating flash disks (read only, note that writes will be significantly slower) ...
LUN 0_0  on drive [NVME_0 ] random read throughput: 2,424.00 MBPS, and 262190 IOPS
LUN 0_1  on drive [NVME_1 ] random read throughput: 2,364.00 MBPS, and 250677 IOPS
LUN 0_10 on drive [NVME_10] random read throughput: 2,462.00 MBPS, and 266873 IOPS
LUN 0_3  on drive [NVME_3 ] random read throughput: 2,280.00 MBPS, and 259054 IOPS
LUN 0_4  on drive [NVME_4 ] random read throughput: 2,452.00 MBPS, and 273260 IOPS
LUN 0_6  on drive [NVME_6 ] random read throughput: 2,074.00 MBPS, and 254981 IOPS
LUN 0_7  on drive [NVME_7 ] random read throughput: 2,524.00 MBPS, and 265266 IOPS
LUN 0_9  on drive [NVME_9 ] random read throughput: 2,322.00 MBPS, and 268461 IOPS

Aggregate random read throughput across all flash disk LUNs: 17349 MBPS
Calibrating flash disks (read only, note that writes will be significantly slower) ...
LUN 0_0  on drive [NVME_0 ] random read throughput: 2,515.00 MBPS, and 266309 IOPS
LUN 0_1  on drive [NVME_1 ] random read throughput: 3,035.00 MBPS, and 300333 IOPS
LUN 0_10 on drive [NVME_10] random read throughput: 2,895.00 MBPS, and 301062 IOPS
LUN 0_3  on drive [NVME_3 ] random read throughput: 3,128.00 MBPS, and 327217 IOPS
LUN 0_4  on drive [NVME_4 ] random read throughput: 2,941.00 MBPS, and 299487 IOPS
LUN 0_6  on drive [NVME_6 ] random read throughput: 3,006.00 MBPS, and 300623 IOPS
LUN 0_7  on drive [NVME_7 ] random read throughput: 2,613.00 MBPS, and 277664 IOPS
LUN 0_9  on drive [NVME_9 ] random read throughput: 2,539.00 MBPS, and 284320 IOPS

İyi çalışmalar.

Step by Step Oracle RAC 12C (FLEX ASM) Installation on Linux X86_64 (VM)

Selamlar,

Oracle VM üzerine RAC 12C (flex ASM) kurulumunu içeren step by step bir guide hazırladım. Aşağıdaki linkten indirebilirsiniz.

Step by Step Oracle RAC 12C (FLEX ASM) Installation on Linux X86_64 (VM)

Kolay gelsin.

Passwordless ssh configuration on Linux 6.5

1- Generate ssh key.

$ cd $HOME
$ mkdir .ssh
$ chmod 700 .ssh
$ cd .ssh
$ ssh-keygen -t rsa
$ ssh-keygen -t dsa

2-

$ cat *.pub >> authorized_keys.<node#>

On Node 1;
$ cat *.pub >> authorized_keys.node1
On Node 2;
$ cat *.pub >> authorized_keys.node2

3- send authorized_keys to other nodes.

$ cd $HOME/.ssh
$ scp authorized_keys.<node#> <node#>:$HOME/.ssh/

On Node 1;
$ scp authorized_keys.node1 rac12c2:$HOME/.ssh/
On Node 2;
$ scp authorized_keys.node2 rac12c1:$HOME/.ssh/

4- create authorized_keys on all nodes.

$ cd $HOME/.ssh
$ cat *.node* >> authorized_keys
$ chmod 600 authorized_keys

5- Test it.

$ ssh <hostnameX> date

On Node 1;
$ ssh rac12c2 date
Mon Aug 15 13:44:22 EEST 2016
On Node 2;
$ ssh rac12c1 date
Mon Aug 15 13:45:06 EEST 2016

ORA-28374 error after create encrypted tablespace

Selamlar,

encrypted tablespace oluştururken aşağıdaki hatayı aldım.

ERROR at line 1:
 ORA-28374: typed master key not found in wallet

Çözüm olarak “How To Generate A New Master Encryption Key for the TDE (Doc ID 445147.1)” dokümanından faydalanarak yeni bir master key create ettim;

ALTER SYSTEM SET ENCRYPTION KEY IDENTIFIED BY "oracle";

ve sorun çözüldü.

Kolay gelsin.

Transparent Data Encryption (TDE) in Oracle 11.2

Selamlar,

Wallet Oluşturma

  1. sqlnet.ora dosyası editlenir.
    ENCRYPTION_WALLET_LOCATION=
      (SOURCE=(METHOD=FILE)(METHOD_DATA=
        (DIRECTORY=/u01/app/oracle/admin/DB11G/encryption_wallet/)))
  2. Database’e bağlanıp master key oluşturuyorum.
    ALTER SYSTEM SET ENCRYPTION KEY IDENTIFIED BY "oracle";
  3. OS üzerinde kontrol ediyorum.
    [oracle@oel65 wallet]$ pwd
    /u01/wallet
    [oracle@oel65 wallet]$ ls -l
    total 8
    -rw-r--r-- 1 oracle oinstall 3109 Jul 30 17:24 ewallet.p12
    
    
  4. DB üzerinde kontrol ediyorum.
    SQL> select status from V$ENCRYPTION_WALLET;
    STATUS
    ------------------
    OPEN

Database kapanıp açıldıktan sonra wallet’ın tekrar açılması gerekli.

ALTER SYSTEM SET ENCRYPTION WALLET OPEN IDENTIFIED BY "oracle";

ALTER SYSTEM SET ENCRYPTION WALLET CLOSE;

 

12C Grid Installation – “PRVF-0002: could not retrieve local node name”

Selamlar,

12C grid kurulumuna başlarken ./runInstaller’ı çalıştırdıktan sonra aşağıdaki gibi bir hata aldım;

“PRVF-0002: could not retrieve local node name”

grid12c

Çözüm;

/etc/hosts dosyasını kontrol etmek gerekiyor. Hostname yazılmamış ve ya yanlış yazılmış olabilir.

[root@oel65 grid]# cat /etc/hosts
127.0.0.1   localhost localhost.localdomain

192.168.60.103 oel65.12c.asm..gantek.com oel6.5

/etc/hosts’u değiştirdim ve sorun çözüldü.

[root@oel65 grid]# cat /etc/hosts
127.0.0.1   localhost localhost.localdomain

192.168.60.103 oel65.12c.asm.gantek.com oel6.5

Kolay gelsin.