2015-06-30 21:19:47 [MgmtSrvr] WARNING -- Failed to allocate nodeid for API at 192.168.1.200. Returned error: 'No free node id found for mysqld(API).'

Symptom:

2015-06-30 21:19:47 [MgmtSrvr] WARNING  -- Failed to allocate nodeid for API at 192.168.1.200. Returned error: 'No free node id found for mysqld(API).'
2015-06-30 21:19:47 [MgmtSrvr] WARNING  -- Failed to allocate nodeid for API at 192.168.1.200. Returned error: 'No free node id found for mysqld(API).'
2015-06-30 21:19:47 [MgmtSrvr] INFO     -- Node 11: Communication to Node 21 opened
2015-06-30 21:19:47 [MgmtSrvr] INFO     -- Node 11: Communication to Node 22 opened
2015-06-30 21:19:47 [MgmtSrvr] INFO     -- Node 12: Prepare arbitrator node 1 [ticket=53b7000181e3e3ab]
2015-06-30 21:19:47 [MgmtSrvr] WARNING  -- Failed to allocate nodeid for API at 192.168.1.200. Returned error: 'No free node id found for mysqld(API).'
2015-06-30 21:19:47 [MgmtSrvr] WARNING  -- Failed to allocate nodeid for API at 192.168.1.200. Returned error: 'No free node id found for mysqld(API).'
2015-06-30 21:19:47 [MgmtSrvr] INFO     -- Node 11: Started arbitrator node 1 [ticket=53b7000181e3e3ab]
2015-06-30 21:19:47 [MgmtSrvr] WARNING  -- Failed to allocate nodeid for API at 192.168.1.200. Returned error: 'No free node id found for mysqld(API).'
2015-06-30 21:19:47 [MgmtSrvr] WARNING  -- Failed to allocate nodeid for API at 192.168.1.200. Returned error: 'No free node id found for mysqld(API).' - Repeated 2 times

Root Causes:

Possibility 1) Not able [mysqld] defined in config.ini for mysql API node.

Possibility 2) MySQLD startup too faster before following lines appear in the ndb_mgmd log:

2015-06-30 22:23:57 [MgmtSrvr] INFO     -- Node 11: Started (mysql-5.6.24 ndb-7.4.6)

2015-06-30 22:23:57 [MgmtSrvr] INFO     -- Node 12: Started (mysql-5.6.24 ndb-7.4.6)

2015-06-30 22:23:57 [MgmtSrvr] INFO     -- Node 12: Node 1: API mysql-5.6.24 ndb-7.4.6

2015-06-30 22:23:57 [MgmtSrvr] INFO     -- Node 11: Node 1: API mysql-5.6.24 ndb-7.4.6

2015-06-30 22:23:57 [MgmtSrvr] INFO     -- Node 12: Communication to Node 21 opened

2015-06-30 22:23:57 [MgmtSrvr] INFO     -- Node 12: Communication to Node 22 opened

2015-06-30 22:23:57 [MgmtSrvr] INFO     -- Node 12: Prepare arbitrator node 1 [ticket=55fa0001821ea407]

2015-06-30 22:23:57 [MgmtSrvr] INFO     -- Node 11: Started arbitrator node 1 [ticket=55fa0001821ea407]

2015-06-30 22:23:58 [MgmtSrvr] INFO     -- Node 11: Communication to Node 21 opened

2015-06-30 22:23:58 [MgmtSrvr] INFO     -- Node 11: Communication to Node 22 opened

Distributed MySQL Privileges for MySQL Cluster

MySQL Cluster supports distribution of MySQL users and privileges across all SQL nodes in a MySQL Cluster. This support is not enabled by default; you should follow the procedure outlined in this section in order to do so.

[mysql@myhost1 mysqlc]$ mysql -u root -S ../server1-api/mysql.sock

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 2

Server version: 5.6.24-ndb-7.4.6-cluster-commercial-advanced MySQL Cluster Server - Advanced Edition (Commercial)

Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> SELECT ROUTINE_NAME, ROUTINE_SCHEMA, ROUTINE_TYPE

    ->     FROM INFORMATION_SCHEMA.ROUTINES

    ->     WHERE ROUTINE_NAME LIKE 'mysql_cluster%'

    ->     ORDER BY ROUTINE_TYPE;

Empty set (0.06 sec)

mysql> SELECT TABLE_NAME, ENGINE FROM INFORMATION_SCHEMA.TABLES

    -> WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME LIKE '%backup'

    -> ORDER BY ENGINE;

Empty set (0.01 sec)

mysql> source share/ndb_dist_priv.sql

Query OK, 0 rows affected, 1 warning (0.01 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected (0.02 sec)

Query OK, 0 rows affected (0.02 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

mysql> SELECT ROUTINE_NAME, ROUTINE_SCHEMA, ROUTINE_TYPE

    ->     FROM INFORMATION_SCHEMA.ROUTINES

    ->     WHERE ROUTINE_NAME LIKE 'mysql_cluster%'

    ->     ORDER BY ROUTINE_TYPE;

+---------------------------------------------+----------------+--------------+

| ROUTINE_NAME                                | ROUTINE_SCHEMA | ROUTINE_TYPE |

+---------------------------------------------+----------------+--------------+

| mysql_cluster_privileges_are_distributed    | mysql          | FUNCTION     |

| mysql_cluster_backup_privileges             | mysql          | PROCEDURE    |

| mysql_cluster_move_grant_tables             | mysql          | PROCEDURE    |

| mysql_cluster_move_privileges               | mysql          | PROCEDURE    |

| mysql_cluster_restore_local_privileges      | mysql          | PROCEDURE    |

| mysql_cluster_restore_privileges            | mysql          | PROCEDURE    |

| mysql_cluster_restore_privileges_from_local | mysql          | PROCEDURE    |

+---------------------------------------------+----------------+--------------+

7 rows in set (0.00 sec)

mysql> CALL mysql.mysql_cluster_move_privileges();

2015-06-30 20:49:00 21146 [Note] NDB Binlog: RENAME Event: REPL$mysql/ndb_user_backup

2015-06-30 20:49:02 21146 [Note] NDB Binlog: RENAME Event: REPL$mysql/ndb_db_backup

2015-06-30 20:49:03 21146 [Note] NDB Binlog: RENAME Event: REPL$mysql/ndb_tables_priv_backup

2015-06-30 20:49:04 21146 [Note] NDB Binlog: RENAME Event: REPL$mysql/ndb_columns_priv_backup

2015-06-30 20:49:05 21146 [Note] NDB Binlog: RENAME Event: REPL$mysql/ndb_procs_priv_backup

2015-06-30 20:49:06 21146 [Note] NDB Binlog: RENAME Event: REPL$mysql/ndb_proxies_priv_backup

Query OK, 2 rows affected (15.04 sec)

mysql> SELECT CONCAT(

    ->    'Conversion ',

    ->    IF(mysql.mysql_cluster_privileges_are_distributed(), 'succeeded', 'failed'),

    ->    '.')

    ->    AS Result;

+-----------------------+

| Result                |

+-----------------------+

| Conversion succeeded. |

+-----------------------+

1 row in set (0.01 sec)

mysql> SELECT TABLE_NAME, ENGINE FROM INFORMATION_SCHEMA.TABLES

    -> WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME LIKE '%backup'

    -> ORDER BY ENGINE;

+-------------------------+------------+

| TABLE_NAME              | ENGINE     |

+-------------------------+------------+

| db_backup               | MyISAM     |

| user_backup             | MyISAM     |

| columns_priv_backup     | MyISAM     |

| tables_priv_backup      | MyISAM     |

| proxies_priv_backup     | MyISAM     |

| procs_priv_backup       | MyISAM     |

| ndb_columns_priv_backup | ndbcluster |

| ndb_user_backup         | ndbcluster |

| ndb_tables_priv_backup  | ndbcluster |

| ndb_proxies_priv_backup | ndbcluster |

| ndb_procs_priv_backup   | ndbcluster |

| ndb_db_backup           | ndbcluster |

+-------------------------+------------+

12 rows in set (0.00 sec)

[mysql@myhost1 mysqlc]$ mysql -u root -S ../server2-api/mysql.sock

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 5

Server version: 5.6.24-ndb-7.4.6-cluster-commercial-advanced MySQL Cluster Server - Advanced Edition (Commercial)

Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> select table_name,engine from information_schema.tables where table_schema='mysql' and engine='ndbcluster';

+-------------------------+------------+

| table_name              | engine     |

+-------------------------+------------+

| columns_priv            | ndbcluster |

| db                      | ndbcluster |

| ndb_apply_status        | ndbcluster |

| ndb_columns_priv_backup | ndbcluster |

| ndb_db_backup           | ndbcluster |

| ndb_index_stat_head     | ndbcluster |

| ndb_index_stat_sample   | ndbcluster |

| ndb_procs_priv_backup   | ndbcluster |

| ndb_proxies_priv_backup | ndbcluster |

| ndb_tables_priv_backup  | ndbcluster |

| ndb_user_backup         | ndbcluster |

| procs_priv              | ndbcluster |

| proxies_priv            | ndbcluster |

| tables_priv             | ndbcluster |

| user                    | ndbcluster |

+-------------------------+------------+

15 rows in set (0.00 sec)

mysql> quit

Bye

Create Window Native Authentication MySQL Users

Ensure following plugin has been loaded via my.ini:

# Enable Windows Authentication
plugin-load=authentication_windows.dll

Create MySQL Users
C:\Users\Administrator>mysql -u donghua -p
Enter password: ********
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 25
Server version: 5.6.25-enterprise-commercial-advanced-log MySQL Enterprise Server - Advanced Edition (Commercial)

Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> CREATE USER Administrator
    ->   IDENTIFIED WITH authentication_windows
    ->   AS 'Administrators';
Query OK, 0 rows affected (0.00 sec)

mysql> grant all on *.* to Administrator@'%';
Query OK, 0 rows affected (0.00 sec)

mysql> exit
Bye

Verify MySQL Users

C:\Users\Administrator>mysql --user=Administrator
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 28
Server version: 5.6.25-enterprise-commercial-advanced-log MySQL Enterprise Server - Advanced Edition (Commercial)

Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> select current_user();
+-----------------+
| current_user()  |
+-----------------+
| Administrator@% |
+-----------------+
1 row in set (0.00 sec)


mysql>

Demo to produce identity gap in SQL Server

C:\Users\Administrator>sqlcmd -S  VMMDB01\PROD -W -e -i d:\ident.sql

USE AdventureWorks2012;
IF OBJECT_ID ('dbo.t1', 'U') IS NOT NULL
   DROP TABLE t1;

Changed database context to 'AdventureWorks2012'.
CREATE TABLE t1 (id int IDENTITY(1,1), name char(20))

insert into t1 (name) values ('a')


(1 rows affected)
SELECT @@IDENTITY AS 'Identity'

Identity
--------
1

(1 rows affected)
begin transaction
insert into t1 (name) values ('a');
rollback transaction;


(1 rows affected)
SELECT @@IDENTITY AS 'Identity';

Identity
--------
2

(1 rows affected)
insert into t1 (name) values ('a');


(1 rows affected)
SELECT @@IDENTITY AS 'Identity';

Identity
--------
3

(1 rows affected)
select * from t1;

id name
-- ----
1 a
3 a

(2 rows affected)


/******************************
USE AdventureWorks2012;
IF OBJECT_ID ('dbo.t1', 'U') IS NOT NULL
   DROP TABLE t1;
GO
CREATE TABLE t1 (id int IDENTITY(1,1), name char(20))
GO
insert into t1 (name) values ('a')
GO
SELECT @@IDENTITY AS 'Identity'
GO
begin transaction
insert into t1 (name) values ('a');
rollback transaction;
GO
SELECT @@IDENTITY AS 'Identity';
GO
insert into t1 (name) values ('a');
GO
SELECT @@IDENTITY AS 'Identity';
GO
select * from t1;

GO
******************************/

Install SQL Server 2016 (CTP2) on Windows Server 2016 (CTP)–Step by Step Guide

Using “MySQL Migration Toolkit” to migrate from Oracle to MySQL

Prepare software (these are discontinued/obsoleted software)

http://downloads.mysql.com/archives/migration/

http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-112010-090769.html

http://www.oracle.com/technetwork/java/javasebusiness/downloads/java-archive-downloads-javase5-419410.html

Install the JDK5, extract MT tools into a folder, and copy jdbc drivers into it’s java folder:

Start Migration by Clicking MySQLMigrationTool.exe

 

Select source and target database (Oracle 12c and MySQL 5.6 used in this example)

Select Schema to migrate

Schema Creation

Transfer the data

Verify the data

Few ORA- errors during "alter index ... rebuild"

[oracle@vmxdb01 ~]$ grep ORA- move_index.log |sort|uniq ORA-00604: error occurred at recursive SQL level 1 ORA-01502: index 'SYS.I_WRI$_OPTSTAT_IND_OBJ#_ST' or partition of such index is ORA-02327: cannot create index on expression with datatype ADT ORA-02327: cannot create index on expression with datatype LOB ORA-02327: cannot create index on expression with datatype NAMED ARRAY TYPE ORA-28650: Primary index on an IOT cannot be rebuilt

ORA-00604 & ORA-01502

SQL> alter index SYS.I_SMB$CONFIG_PKEY rebuild; alter index SYS.I_SMB$CONFIG_PKEY rebuild * ERROR at line 1: ORA-00604: error occurred at recursive SQL level 1 ORA-01502: index 'SYS.I_WRI$_OPTSTAT_IND_OBJ#_ST' or partition of such index is in unusable state

To Fix:

SQL> alter index SYS.I_WRI$_OPTSTAT_IND_OBJ#_ST rebuild; Index altered. SQL> alter index SYS.I_SQL$TEXT_PKEY rebuild; Index altered.

ORA-28650: Primary index on an IOT cannot be rebuilt

SQL> alter index SYS.SQLLOG$_PKEY rebuild online; alter index SYS.SQLLOG$_PKEY rebuild online * ERROR at line 1: ORA-28650: Primary index on an IOT cannot be rebuilt

To Fix:

SQL> select table_name from dba_indexes where index_name='SQLLOG$_PKEY'; TABLE_NAME -------------------------------------------------------------------------------- SQLLOG$ SQL> alter table SQLLOG$ move tablespace sysaux online; -- online only work if no iot_overflow Table altered.

Few ORA- error while "alter table ....move"

[oracle@vmxdb01 ~]$ grep ORA- move_table.log |sort|uniq ORA-00997: illegal use of LONG datatype ORA-01735: invalid ALTER TABLE option ORA-14512: cannot perform operation on a clustered object ORA-25191: cannot reference overflow table of an index-organized table

ORA-00997: illegal use of LONG datatype

SQL> alter table SYS.WRI$_SQLSET_WORKSPACE_PLANS move; SQL> alter table SYS.WRI$_SQLSET_PLAN_LINES move; SQL> alter table SYS.WRI$_ADV_SQLT_PLANS move; SQL> alter table SYS.SQLOBJ$PLAN move;

To fix:

In this example, all tables are actually empty. For application tables, suggest to use copy or expdp/impdp.

ORA-01735: invalid ALTER TABLE option

SQL> alter table XDB.SYS_NT/ZrP7FfoSKngQ7ap6Ar7bw== move;

To fix:

SQL> alter table XDB."SYS_NT/ZrP7FfoSKngQ7ap6Ar7bw==" move; Table altered.

ORA-14512: cannot perform operation on a clustered object

SQL> alter table SYS.SMON_SCN_TIME move;

To fix:

SQL> select cluster_owner,cluster_name from dba_tables   2  where owner='SYS' and table_name='SMON_SCN_TIME'; CLUSTER_OWNER                  CLUSTER_NAME ------------------------------ ------------------------------ SYS                            SMON_SCN_TO_TIME_AUX SQL> select owner,table_name from dba_tables   2  where cluster_name='SMON_SCN_TO_TIME_AUX' and cluster_owner='SYS'; OWNER                          TABLE_NAME ------------------------------ ------------------------------ SYS                            SMON_SCN_TIME Expdp/impdp to create the object if not sys internal objects.

ORA-25191: cannot reference overflow table of an index-organized table

SQL> alter table SYS.SYS_IOT_OVER_18291 move; SQL> alter table SYS.SYS_IOT_OVER_17517 move; SQL> alter table SYS.SYS_IOT_OVER_7687 move; …

To fix:

SQL> select owner,table_name,iot_name from dba_tables where owner='SYS' and table_name='SYS_IOT_OVER_7687'; OWNER                          TABLE_NAME ------------------------------ ------------------------------ IOT_NAME -------------------------------------------------------------------------------- SYS                            SYS_IOT_OVER_7687 RECENT_RESOURCE_INCARNATIONS$ SQL> alter table RECENT_RESOURCE_INCARNATIONS$ move tablespace sysaux overflow tablespace sysaux; Table altered. SQL> select owner,table_name,iot_name from dba_tables where owner='SYS' and table_name='SYS_IOT_OVER_18291'; OWNER                          TABLE_NAME ------------------------------ ------------------------------ IOT_NAME -------------------------------------------------------------------------------- SYS                            SYS_IOT_OVER_18291 AQ$_SYS$SERVICE_METRICS_TAB_G SQL> alter table AQ$_SYS$SERVICE_METRICS_TAB_G move tablespace sysaux overflow tablespace sysaux; alter table AQ$_SYS$SERVICE_METRICS_TAB_G move tablespace sysaux overflow tablespace sysaux             * ERROR at line 1: ORA-24005: Inappropriate utilities used to perform DDL on AQ table SYS.AQ$_SYS$SERVICE_METRICS_TAB_G SQL> DECLARE   2    po dbms_aqadm.aq$_purge_options_t;   3  BEGIN   4    po.block := FALSE;   5    DBMS_AQADM.PURGE_QUEUE_TABLE(   6      queue_table => 'AQ$_SYS$SERVICE_METRICS_TAB_G',   7      purge_condition => NULL,     purge_options => po);   8    9  END;  10  / DECLARE * ERROR at line 1: ORA-24019: identifier for QUEUE_TABLE too long, should not be greater than 24 characters ORA-06512: at "SYS.DBMS_AQADM", line 1668 ORA-06512: at line 5 SQL> DECLARE   2    po dbms_aqadm.aq$_purge_options_t;   3  BEGIN   4    po.block := FALSE;   5    DBMS_AQADM.PURGE_QUEUE_TABLE(   6      queue_table => 'SYS$SERVICE_METRICS_TAB',   7      purge_condition => NULL,   8      purge_options => po);   9  END;  10  / PL/SQL procedure successfully completed.

Clone Oracle Home (using 12c as example)

Copy Oracle Home

root@solaris112:/u01/app/oracle/product/12.1.0# cp -rp dbhome_1 dbhome_2

Run the Clone Script:

oracle@solaris112:/u01/app/oracle/product/12.1.0/dbhome_2/bin$ $ORACLE_HOME/perl/bin/perl $ORACLE_HOME/clone/bin/clone.pl ORACLE_BASE="/u01/app/oracle" ORACLE_HOME="/u01/app/oracle/product/12.1.0/dbhome_2" OSDBA_GROUP=dba ORACLE_HOME_NAME=Cloned_Home ./runInstaller -clone -waitForCompletion  "ORACLE_BASE=/u01/app/oracle" "ORACLE_HOME=/u01/app/oracle/product/12.1.0/dbhome_2" "oracle_install_OSDBA=dba" "ORACLE_HOME_NAME=Cloned_Home" -silent -paramFile /u01/app/oracle/product/12.1.0/dbhome_2/clone/clone_oraparam.ini Starting Oracle Universal Installer... Checking Temp space: must be greater than 500 MB.   Actual 3923 MB    Passed Checking swap space: must be greater than 500 MB.   Actual 4101 MB    Passed Preparing to launch Oracle Universal Installer from /tmp/OraInstall2015-06-18_05-05-46AM. Please wait ...You can find the log of this install session at:  /u01/app/oraInventory/logs/cloneActions2015-06-18_05-05-46AM.log ..................................................   5% Done. ..................................................   10% Done. ..................................................   15% Done. ..................................................   20% Done. ..................................................   25% Done. ..................................................   30% Done. ..................................................   35% Done. ..................................................   40% Done. ..................................................   45% Done. ..................................................   50% Done. ..................................................   55% Done. ..................................................   60% Done. ..................................................   65% Done. ..................................................   70% Done. ..................................................   75% Done. ..................................................   80% Done. ..................................................   85% Done. .......... Copy files in progress. Copy files successful. Link binaries in progress. Link binaries successful. Setup files in progress. Setup files successful. Setup Inventory in progress. Setup Inventory successful. Finish Setup successful. The cloning of Cloned_Home was successful. Please check '/u01/app/oraInventory/logs/cloneActions2015-06-18_05-05-46AM.log' for more details. Setup Oracle Base in progress. Setup Oracle Base successful. ..................................................   95% Done. As a root user, execute the following script(s):         1. /u01/app/oracle/product/12.1.0/dbhome_2/root.sh ..................................................   100% Done. oracle@solaris112:/u01/app/oracle/product/12.1.0/dbhome_2/bin$ sudo /u01/app/oracle/product/12.1.0/dbhome_2/root.sh Check /u01/app/oracle/product/12.1.0/dbhome_2/install/root_solaris112_2015-06-18_05-11-44.log for the output of root script

Post Verification:

oracle@solaris112:/u01/app/oracle/product/12.1.0/dbhome_2/bin$ $ORACLE_HOME/OPatch/opatch lsinventory Oracle Interim Patch Installer version 12.1.0.1.3 Copyright (c) 2015, Oracle Corporation.  All rights reserved. Oracle Home       : /u01/app/oracle/product/12.1.0/dbhome_2 Central Inventory : /u01/app/oraInventory    from           : /u01/app/oracle/product/12.1.0/dbhome_2/oraInst.loc OPatch version    : 12.1.0.1.3 OUI version       : 12.1.0.2.0 Log file location : /u01/app/oracle/product/12.1.0/dbhome_2/cfgtoollogs/opatch/opatch2015-06-18_05-22-39AM_1.log Lsinventory Output file location : /u01/app/oracle/product/12.1.0/dbhome_2/cfgtoollogs/opatch/lsinv/lsinventory2015-06-18_05-22-39AM.txt -------------------------------------------------------------------------------- Installed Top-level Products (1): Oracle Database 12c                                                  12.1.0.2.0 There are 1 products installed in this Oracle Home. There are no Interim patches installed in this Oracle Home. -------------------------------------------------------------------------------- OPatch succeeded. oracle@solaris112:/u01/app/oracle/product/12.1.0/dbhome_2/bin$ grep dbhome_1 *|awk -F":" '{print $1}'|uniq aqxmlctl.ouibak aqxmlctl.ouibak.1 bndlchk.ouibak bndlchk.ouibak.1 chopt.ini.ouibak chopt.ini.ouibak.1 chopt.ouibak chopt.ouibak.1 chopt.pl.ouibak chopt.pl.ouibak.1 dbca.ouibak dbca.ouibak.1 dbua.ouibak dbua.ouibak.1 diagsetup.ouibak diagsetup.ouibak.1 dropjava.ouibak dropjava.ouibak.1 emca.ouibak emca.ouibak.1 eusm.ouibak eusm.ouibak.1 extusrupgrade.ouibak extusrupgrade.ouibak.1 kfod.ouibak kfod.ouibak.1 ldifmigrator.ouibak ldifmigrator.ouibak.1 loadjava.ouibak loadjava.ouibak.1 netca_deinst.sh.ouibak netca_deinst.sh.ouibak.1 netca.ouibak netca.ouibak.1 netmgr.ouibak netmgr.ouibak.1 odisrvreg.ouibak odisrvreg.ouibak.1 oidca.ouibak oidca.ouibak.1 oidprovtool.ouibak oidprovtool.ouibak.1 ojvmjava.ouibak ojvmjava.ouibak.1 ojvmtc.ouibak ojvmtc.ouibak.1 olsadmintool.ouibak olsadmintool.ouibak.1 olsoidsync.ouibak olsoidsync.ouibak.1 onsctl.ouibak onsctl.ouibak.1 platform_common.ouibak platform_common.ouibak.1 rconfig.ouibak rconfig.ouibak.1 schemasync.ouibak schemasync.ouibak.1 srvctl.ouibak srvctl.ouibak.1 trcasst.ouibak trcasst.ouibak.1 trcsess.ouibak trcsess.ouibak.1 umu.ouibak umu.ouibak.1 oracle@solaris112:/u01/app/oracle/product/12.1.0/dbhome_2/bin$ grep dbhome_2 *|awk -F":" '{print $1}'|uniq aqxmlctl bndlchk chopt chopt.ini chopt.pl dbca dbua diagsetup dropjava emca eusm extusrupgrade kfod lbuilder ldifmigrator loadjava netca netca_deinst.sh netmgr odisrvreg oidca oidprovtool ojvmjava ojvmtc olsadmintool olsoidsync onsctl platform_common rconfig schemasync srvctl trcasst trcsess umu

Appendix: Clone Parameters

oracle@solaris112:/u01/app/oracle/product/12.1.0/dbhome_2/bin$ $ORACLE_HOME/perl/bin/perl $ORACLE_HOME/clone/bin/clone.pl ./runInstaller -clone -waitForCompletion  -silent -paramFile /u01/app/oracle/product/12.1.0/dbhome_2/clone/bin/../../clone/clone_oraparam.ini Starting Oracle Universal Installer... Checking Temp space: must be greater than 500 MB.   Actual 3934 MB    Passed Checking swap space: must be greater than 500 MB.   Actual 4112 MB    Passed Preparing to launch Oracle Universal Installer from /tmp/OraInstall2015-06-18_05-00-31AM. Please wait ...[INS-21001] ORACLE_HOME was not specified for clone. Usage: runInstaller  [-options] [()*] Where options include:   -clusterware oracle.crs,         Version of Cluster ready services installed.   -crsLocation         Used only for cluster installs, specifies the path to the crs home location. Specifying this overrides CRS information obtained from central inventory.   -invPtrLoc         Unix only. To point to a different inventory location. The orainst.loc file contains: inventory_loc= inst_group=<>   -jreLoc         Path where Java Runtime Environment is installed. OUI cannot be run without it.   -logLevel         To filter log messages that have a lesser priority level than . Valid options are: severe, warning, info, config, fine, finer, finest, basic, general, detailed, trace. The use of basic, general, detailed, trace is deprecated.   -paramFile         Specify location of oraparam.ini file to be used by OUI.   -responseFile         Specifies the response file and path to use.   -attachHome         For attaching homes to the OUI inventory.   -cfs         Indicates that the Oracle home specified is on cluster file system (shared). This is mandatory when '-local' is specified so that Oracle Universal Installer can register the home appropriately into the inventory.   -clone         For making an Oracle Home copy match its current environment.   -debug         For getting the debug information from OUI.   -detachHome         For detaching homes from the OUI inventory without deleting inventory directory inside Oracle home.   -enableRollingUpgrade         Used in cluster environment, to enable upgrade of a product on a subset of nodes (on which the product was installed).   -executeSysPrereqs         Execute system pre-requisite checks and exit.   -force         Allowing silent mode installation into a non-empty directory.   -help         Displays above usage.   -ignoreSysPrereqs         For ignoring the results of the system pre-requisite checks.   -local         Performs the operation on the local node irrespective of the cluster nodes specified.   -printdiskusage         Log debug information for disk usage.   -printmemory         Log debug information for memory usage.   -printtime         Log debug information for time usage.   -relink         For performing relink actions on the oracle home          Usage: -relink -maketargetsxml [-makedepsxml ] [name=value]   -silent         For silent mode operations, the inputs can be a response file or a list of command line variable value pairs.   -waitforcompletion         Installer will wait for completion instead of spawning the java engine and exiting.   -suppressPreCopyScript         Suppress the execution of precopy script.   -acceptUntrustedCertificates         Accept untrusted certificates from a secure site.   -suppressPostCopyScript         Suppress the execution of postcopy script.   -noconfig         Do not execute config tools.   -noconsole         For suppressing display of messages to console. Console is not allocated.   -formCluster         To install the Oracle clusterware in order to form the cluster.   -remotecp         Unix specific option. Used only for cluster installs, specifies the path to the remote copy program on the local cluster node.   -remoteshell         Unix specific option. Used only for cluster installs, specifies the path to the remote shell program on the local cluster node.   -executePrereqs         To execute only the prerequisite checks.   -ignorePrereq         To ignore running the prerequisite checks.   -ignoreInternalDriverError         To ignore any internal driver errors.   -downloadUpdates         To download updates only.   -showProgress         To show the installation progress on the console. This option is supported only in case of silent installation.   -promptForPassword         To provide the passwords on the console during silent installation of Oracle Database.   -deinstall         To Uninstall the specified home         Usage:-home               -help: To see detailed usage Information Command Line Variables Usage   Command line variables are specified using ; for example:     [ session: | compName: | compName:version: ]variableName=" valueOfVariable"]    Session/Installer variables are specified using:           [session:]varName=value     Ex 1: session:ORACLE_HOME_NAME="OraHome"     Ex 2: ORACLE_HOME_NAME="OraHome"     The lookup order is session:varName then just varName. The session prefix is used to avoid ambiguity.    Component variables are specified using:           [compInternalName:[Version:]]varName     Ex 1: oracle.comp1:1.0.1:varName="VarValue"     Ex 2: oracle.comp1:varName="VarValue"     The lookup order is compInternalName:Version:varName, then compInternalName:varName, then just varName.