Tag Archives: 12c

Oracle BBED：Install

By Adamhuan | 2017年4月7日

BBED的编译需要一些依赖包，如果你没有提供这些依赖包，那么你会遇到错误，像下面这样：

[oracle@ora11gdg1 ~]$ cd $ORACLE_HOME/rdbms/lib
[oracle@ora11gdg1 lib]$ ls -ltr | grep bbed
[oracle@ora11gdg1 lib]$ ls -ltr | grep ins_rdbms
-rw-r--r-- 1 oracle oinstall    40983 Aug 24  2013 ins_rdbms.mk
[oracle@ora11gdg1 lib]$ 
[oracle@ora11gdg1 lib]$ make -f ins_rdbms.mk $ORACLE_HOME/rdbms/lib/bbed

Linking BBED utility (bbed)
rm -f /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/bbed
gcc -o /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/bbed -m64 -z noexecstack -L/u01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/ -L/u01/app/oracle/product/11.2.0/dbhome_1/lib/ -L/u01/app/oracle/product/11.2.0/dbhome_1/lib/stubs/  /u01/app/oracle/product/11.2.0/dbhome_1/lib/s0main.o /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/ssbbded.o /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/sbbdpt.o `cat /u01/app/oracle/product/11.2.0/dbhome_1/lib/ldflags`    -lncrypt11 -lnsgr11 -lnzjs11 -ln11 -lnl11 -ldbtools11 -lclntsh  `cat /u01/app/oracle/product/11.2.0/dbhome_1/lib/ldflags`    -lncrypt11 -lnsgr11 -lnzjs11 -ln11 -lnl11 -lnro11 `cat /u01/app/oracle/product/11.2.0/dbhome_1/lib/ldflags`    -lncrypt11 -lnsgr11 -lnzjs11 -ln11 -lnl11 -lnnz11 -lzt11 -lztkg11 -lclient11 -lnnetd11  -lvsn11 -lcommon11 -lgeneric11 -lmm -lsnls11 -lnls11  -lcore11 -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lxml11 -lcore11 -lunls11 -lsnls11 -lnls11 -lcore11 -lnls11 `cat /u01/app/oracle/product/11.2.0/dbhome_1/lib/ldflags`    -lncrypt11 -lnsgr11 -lnzjs11 -ln11 -lnl11 -lnro11 `cat /u01/app/oracle/product/11.2.0/dbhome_1/lib/ldflags`    -lncrypt11 -lnsgr11 -lnzjs11 -ln11 -lnl11 -lclient11 -lnnetd11  -lvsn11 -lcommon11 -lgeneric11   -lsnls11 -lnls11  -lcore11 -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lxml11 -lcore11 -lunls11 -lsnls11 -lnls11 -lcore11 -lnls11 -lclient11 -lnnetd11  -lvsn11 -lcommon11 -lgeneric11 -lsnls11 -lnls11  -lcore11 -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lxml11 -lcore11 -lunls11 -lsnls11 -lnls11 -lcore11 -lnls11   `cat /u01/app/oracle/product/11.2.0/dbhome_1/lib/sysliblist` -Wl,-rpath,/u01/app/oracle/product/11.2.0/dbhome_1/lib -lm    `cat /u01/app/oracle/product/11.2.0/dbhome_1/lib/sysliblist` -ldl -lm   -L/u01/app/oracle/product/11.2.0/dbhome_1/lib
gcc: /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/ssbbded.o: No such file or directory
gcc: /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/sbbdpt.o: No such file or directory
make: *** [/u01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/bbed] Error 1
[oracle@ora11gdg1 lib]$

[oracle@ora11gdg1 ~]$ cd $ORACLE_HOME/rdbms/lib

[oracle@ora11gdg1 lib]$ ls -ltr | grep bbed

[oracle@ora11gdg1 lib]$ ls -ltr | grep ins_rdbms

-rw-r--r-- 1 oracle oinstall 40983 Aug 24 2013 ins_rdbms.mk

[oracle@ora11gdg1 lib]$

[oracle@ora11gdg1 lib]$ make -f ins_rdbms.mk $ORACLE_HOME/rdbms/lib/bbed

Linking BBED utility (bbed)

rm -f /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/bbed

gcc -o /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/bbed -m64 -z noexecstack -L/u01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/ -L/u01/app/oracle/product/11.2.0/dbhome_1/lib/ -L/u01/app/oracle/product/11.2.0/dbhome_1/lib/stubs/ /u01/app/oracle/product/11.2.0/dbhome_1/lib/s0main.o /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/ssbbded.o /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/sbbdpt.o `cat /u01/app/oracle/product/11.2.0/dbhome_1/lib/ldflags` -lncrypt11 -lnsgr11 -lnzjs11 -ln11 -lnl11 -ldbtools11 -lclntsh `cat /u01/app/oracle/product/11.2.0/dbhome_1/lib/ldflags` -lncrypt11 -lnsgr11 -lnzjs11 -ln11 -lnl11 -lnro11 `cat /u01/app/oracle/product/11.2.0/dbhome_1/lib/ldflags` -lncrypt11 -lnsgr11 -lnzjs11 -ln11 -lnl11 -lnnz11 -lzt11 -lztkg11 -lclient11 -lnnetd11 -lvsn11 -lcommon11 -lgeneric11 -lmm -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lxml11 -lcore11 -lunls11 -lsnls11 -lnls11 -lcore11 -lnls11 `cat /u01/app/oracle/product/11.2.0/dbhome_1/lib/ldflags` -lncrypt11 -lnsgr11 -lnzjs11 -ln11 -lnl11 -lnro11 `cat /u01/app/oracle/product/11.2.0/dbhome_1/lib/ldflags` -lncrypt11 -lnsgr11 -lnzjs11 -ln11 -lnl11 -lclient11 -lnnetd11 -lvsn11 -lcommon11 -lgeneric11 -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lxml11 -lcore11 -lunls11 -lsnls11 -lnls11 -lcore11 -lnls11 -lclient11 -lnnetd11 -lvsn11 -lcommon11 -lgeneric11 -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lxml11 -lcore11 -lunls11 -lsnls11 -lnls11 -lcore11 -lnls11 `cat /u01/app/oracle/product/11.2.0/dbhome_1/lib/sysliblist` -Wl,-rpath,/u01/app/oracle/product/11.2.0/dbhome_1/lib -lm `cat /u01/app/oracle/product/11.2.0/dbhome_1/lib/sysliblist` -ldl -lm -L/u01/app/oracle/product/11.2.0/dbhome_1/lib

gcc: /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/ssbbded.o: No such file or directory

gcc: /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/sbbdpt.o: No such file or directory

make: *** [/u01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/bbed] Error 1

[oracle@ora11gdg1 lib]$

可以很明显的看到上面的报错【No such file or directory】。

BBED的成功编译需要这样的几个依赖包：
[cr[……]

Oracle database 12c：启动PDB

By Adamhuan | 2017年4月3日

0 Comment

没有太多可说的，直接贴代码：

[oracle@ora12c-1 ~]$ export ORACLE_SID=lenka
[oracle@ora12c-1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Mon Apr 3 12:33:15 2017

Copyright (c) 1982, 2016, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL> set linesize 900
SQL> col name for a14
SQL> select con_id,dbid,guid,name,open_mode from v$pdbs;

    CON_ID       DBID GUID                             NAME           OPEN_MODE
---------- ---------- -------------------------------- -------------- --------------------
         2 3336497216 4A32FBF7B8D73D22E055025056845AD4 PDB$SEED       READ ONLY
         3 3747065989 4A331267BC4346C6E055025056845AD4 PDB_LENKA_1    MOUNTED

SQL> select name,cdb,open_mode,con_id from v$database;
 
NAME           CDB    OPEN_MODE                                    CON_ID
-------------- ------ ---------------------------------------- ----------
LENKA          YES    READ WRITE                                        0

SQL> alter pluggable database PDB_LENKA_1 open;

Pluggable database altered.

SQL> select con_id,dbid,guid,name,open_mode from v$pdbs;

    CON_ID       DBID GUID                             NAME           OPEN_MODE
---------- ---------- -------------------------------- -------------- --------------------
         2 3336497216 4A32FBF7B8D73D22E055025056845AD4 PDB$SEED       READ ONLY
         3 3747065989 4A331267BC4346C6E055025056845AD4 PDB_LENKA_1    READ WRITE

SQL>

[oracle@ora12c-1 ~]$ export ORACLE_SID=lenka

[oracle@ora12c-1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Mon Apr 3 12:33:15 2017

Connected to:

Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL> set linesize 900

SQL> col name for a14

SQL> select con_id,dbid,guid,name,open_mode from v$pdbs;

CON_ID DBID GUID NAME OPEN_MODE

---------- ---------- -------------------------------- -------------- --------------------

2 3336497216 4A32FBF7B8D73D22E055025056845AD4 PDB$SEED READ ONLY

3 3747065989 4A331267BC4346C6E055025056845AD4 PDB_LENKA_1 MOUNTED

SQL> select name,cdb,open_mode,con_id from v$database;

NAME CDB OPEN_MODE CON_ID

-------------- ------ ---------------------------------------- ----------

LENKA YES READ WRITE 0

SQL> alter pluggable database PDB_LENKA_1 open;

Pluggable database altered.

SQL> select con_id,dbid,guid,name,open_mode from v$pdbs;

CON_ID DBID GUID NAME OPEN_MODE

---------- ---------- -------------------------------- -------------- --------------------

2 3336497216 4A32FBF7B8D73D22E055025056845AD4 PDB$SEED READ ONLY

3 3747065989 4A331267BC4346C6E055025056845AD4 PDB_LENKA_1 READ WRITE

SQL>

——————————
Done。

Oracle 12c：为数据库实例启用EM Express

By Adamhuan | 2017年3月8日

0 Comment

有时候，通过DBCA创建的数据库实例，有可能没有开启EM Express。
EM Express，是可以后面手动开启的。

下面的篇章，将呈现做到这件事的细节。

在开启之前，先查看下数据库的当前状态：
监听器：

[oracle@ora12c-1 ~]$ lsnrctl status

LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 08-MAR-2017 15:29:09

Copyright (c) 1991, 2016, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ora12c-1)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 12.2.0.1.0 - Production
Start Date                08-MAR-2017 11:36:35
Uptime                    0 days 3 hr. 52 min. 34 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /home/app/oracle/12c/release_2/db_1/network/admin/listener.ora
Listener Log File         /home/app/oracle/diag/tnslsnr/ora12c-1/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ora12c-1)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Services Summary...
Service "4a331267bc4346c6e055025056845ad4" has 1 instance(s).
  Instance "lenka", status READY, has 1 handler(s) for this service...
Service "lenka" has 1 instance(s).
  Instance "lenka", status READY, has 1 handler(s) for this service...
Service "lenkaXDB" has 1 instance(s).
  Instance "lenka", status READY, has 1 handler(s) for this service...
Service "pdb_lenka_1" has 1 instance(s).
  Instance "lenka", status READY, has 1 handler(s) for this service...
The command completed successfully
[oracle@ora12c-1 ~]$

[oracle@ora12c-1 ~]$ lsnrctl status

LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 08-MAR-2017 15:29:09

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ora12c-1)(PORT=1521)))

STATUS of the LISTENER

------------------------

Alias LISTENER

Version TNSLSNR for Linux: Version 12.2.0.1.0 - Production

Start Date 08-MAR-2017 11:36:35

Uptime 0 days 3 hr. 52 min. 34 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /home/app/oracle/12c/release_2/db_1/network/admin/listener.ora

Listener Log File /home/app/oracle/diag/tnslsnr/ora12c-1/listener/alert/log.xml

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ora12c-1)(PORT=1521)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

Services Summary...

Service "4a331267bc4346c6e055025056845ad4" has 1 instance(s).

Instance "lenka", status READY, has 1 handler(s) for this service...

Service "lenka" has 1 instance(s).

Instance "lenka", status READY, has 1 handler(s) for this service...

Service "lenkaXDB" has 1 instance(s).

Instance "lenka", status READY, has 1 handler(s) for this service...

Service "pdb_lenka_1" has 1 instance(s).

Instance "lenka", status READY, has 1 handler(s) for this service...

The command completed successfully

[oracle@ora12c-1 ~]$

[……]

12c：将一个CDB的所有PDB，导入到另一个CDB中

By Adamhuan | 2016年4月23日

0 Comment

本文一样是读书时的练习：
exp_4_6_1

开始前，说明下：
在我的环境中有两个CDB：
源：

[oracle@rhel7 trace]$ env | grep SID
ORACLE_SID=conme
[oracle@rhel7 trace]$ 
[oracle@rhel7 trace]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Sat Apr 23 13:41:52 2016

Copyright (c) 1982, 2014, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> select name,cdb from v$database;

NAME      CDB
--------- ---
CONME     YES

SQL> 
SQL> select con_id,name,open_mode from v$pdbs;

    CON_ID NAME                           OPEN_MODE
---------- ------------------------------ ----------
         2 PDB$SEED                       READ ONLY
         3 PDBME                          MOUNTED
         4 PDBSHE                         MOUNTED
         5 PDBSHE2                        MOUNTED
         6 PDBORCL                        MOUNTED

SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
[oracle@rhel7 trace]$

[oracle@rhel7 trace]$ env | grep SID

ORACLE_SID=conme

[oracle@rhel7 trace]$

[oracle@rhel7 trace]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Sat Apr 23 13:41:52 2016

Connected to:

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> select name,cdb from v$database;

NAME CDB

--------- ---

CONME YES

SQL>

SQL> select con_id,name,open_mode from v$pdbs;

CON_ID NAME OPEN_MODE

---------- ------------------------------ ----------

2 PDB$SEED READ ONLY

3 PDBME MOUNTED

4 PDBSHE MOUNTED

5 PDBSHE2 MOUNTED

6 PDBORCL MOUNTED

SQL> exit

Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

[oracle@rhel7 trace]$

目标：

[oracle@rhel7 controlfile]$ env | grep SID
ORACLE_SID=callah
[oracle@rhel7 controlfile]$ 
[oracle@rhel7 controlfile]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Sat Apr 23 13:42:40 2016

Copyright (c) 1982, 2014, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> 
SQL> select name,cdb from v$database;

NAME      CDB
--------- ---
CALLAH    YES

SQL> 
SQL> select con_id,name,open_mode from v$pdbs;

    CON_ID NAME                           OPEN_MODE
---------- ------------------------------ ----------
         2 PDB$SEED                       READ ONLY

SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
[oracle@rhel7 controlfile]$

[oracle@rhel7 controlfile]$ env | grep SID

ORACLE_SID=callah

[oracle@rhel7 controlfile]$

[oracle@rhel7 controlfile]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Sat Apr 23 13:42:40 2016

Connected to:

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL>

SQL> select name,cdb from v$database;

NAME CDB

--------- ---

CALLAH YES

SQL>

SQL> select con_id,name,open_mode from v$pdbs;

CON_ID NAME OPEN_MODE

---------- ------------------------------ ----------

2 PDB$SEED READ ONLY

SQL> exit

Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

[oracle@rhel7 controlfile]$

在源端操作：
Unplug PDB：
[cray[……]

ORA-00202: control file: ‘/u01/app/oracle/product/12/db_1/dbs/cntrlcallah.dbf’

By Adamhuan | 2016年4月23日

0 Comment

对于如题所示的问题，虽然，前面写的NOMOUNT阶段手动创建控制文件，虽然也能解决如题所示的问题，但是还有更简单的做法：
日志文件中的问题详情：

Sat Apr 23 10:40:11 2016
ALTER DATABASE   MOUNT
Sat Apr 23 10:40:11 2016
ORA-00210: cannot open the specified control file
ORA-00202: control file: '/u01/app/oracle/product/12/db_1/dbs/cntrlcallah.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-205 signalled during: ALTER DATABASE   MOUNT...

Sat Apr 23 10:40:11 2016

ALTER DATABASE MOUNT

Sat Apr 23 10:40:11 2016

ORA-00210: cannot open the specified control file

ORA-00202: control file: '/u01/app/oracle/product/12/db_1/dbs/cntrlcallah.dbf'

ORA-27037: unable to obtain file status

Linux-x86_64 Error: 2: No such file or directory

Additional information: 3

ORA-205 signalled during: ALTER DATABASE MOUNT...

将本地已有的OMF管理的控制文件，复制到dbs/cntrlcallah.db[……]