Your boot partition is on a disk using the GPT partitioning scheme but this machine cannot boot using GPT

Your boot partition is on a disk using the GPT partitioning scheme but this machine cannot boot using GPT

Following error after telling anaconda to install on pre-existing partitions (with GPT label):

On Partitioning screen, press Ctrl + Alt + F2 to get to a shell prompt.

$ parted /dev/sda -s mklabel msdos

Press Ctrl + Alt + F6 to return to the partitioning screen

SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is enabled

SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is enabled

 

ISSUE: 

SQL> set autotrace traceonly;

SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is enabled

SP2-0611: Error enabling STATISTICS report

SOLUTION:

Users needs to have the PLUSTRACE role, which does not exist by default.

PLUSTRACE role can be created using SYS user by executing

ORACLE_HOME\sqlplus\admin\plustrce.sql 

The plustrace.sql creates the PLUSTRACE role

It also grants SELECT on V_$SESSTAT, V_$STATNME and V_$MYSTAT. 

PLUSTRACE is granted to the DBA role with ADMIN OPTION.

For 9i and earlier databases you may also need to create the plan table

by executing following script:-

$ORACLE_HOME\rdbms\admin\utlxplan.sql 

The PLAN_TABLE already exists on database version 10g and higher.

SQL> connect sys/sys as sysdba

Connected.

SQL> @%oracle_home%\sqlplus\admin\plustrce.sql;

SQL>

SQL> drop role plustrace;

drop role plustrace

          *

ERROR at line 1:

ORA-01919: role 'PLUSTRACE' does not exist

SQL> create role plustrace;

Role created.

SQL> grant select on v_$sesstat to plustrace;

Grant succeeded.

SQL> grant select on v_$statname to plustrace;

Grant succeeded.

SQL> grant select on v_$mystat to plustrace;

Grant succeeded.

SQL> grant plustrace to dba with admin option;

Grant succeeded.

After executing ORACLE_HOME\sqlplus\admin\plustrce.sql,

we need to grant PLUSTRACE role to the user.

SQL> grant plustrace to scott;

Grant succeeded.

SQL> connect scott/tiger

Connected.

SQL> set autotrace trace 

SQL> select user from dual; 

Execution Plan ----------------------------------------------------------

Plan hash value: 1388734953

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

| Id | Operation | Name | Rows | Cost (%CPU)| Time | 

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

 | 0 | SELECT STATEMENT 

| | 1 | 2 (0)| 00:00:01 | | 1 | FAST DUAL | | 1 | 2 (0)| 00:00:01 | 

-- Statistics --------- 1 recursive calls 0 db block gets 

0 consistent gets 0 physical reads 0 redo size 421 bytes 

sent via SQL*Net to client 415 bytes received via 

SQL*Net from client 2 SQL*Net roundtrips to/from 

client 0 sorts (memory) 0 sorts (disk) 1 rows processed

RC-20200: Fatal: Could not find Unzip. At this time only Native UnZip 5.X is supported.

RC-20200: Fatal: Could not find Unzip. At this time only Native UnZip 5.X is supported.

While cloning database Tier

Error :
RC-20200: Fatal: Could not find Unzip. At this time only Native UnZip 5.X is supported.

Please make sure you have UnZip 5.X in your path and try again…

 ERROR while running Apply…

 ERROR: Failed to execute /clone/oracle/product/11.2.0/appsutil/clone/bin/adclone.pl

  Please check logfile.

Solution 1

Which unzip should point to $ORACLE_HOME/bin/unzip

Take the backup of existing unzip from $ORACLE_HOME/bin

cd $ORACLE_HOME/bin

mv unzip unzip_bkp

cp /usr/bin/unzip to $ORACLE_HOME/bin

Make sure the unzip utility under /usr/bin should be of version 5.X and not 6

Solution 2

As root user, rename the default unzip (/usr/bin/unzip) to a temporary filename (e.g. /usr/bin/unzip-ver6), perform the task, and then rename unzip-ver6 to the original name when completed.

# mv /usr/bin/unzip /usr/bin/unzip-ver6

Solution 3

unzip utility
https://oss.oracle.com/el4/unzip/unzip.html


 

While cloning, adcfgclone.pl error:RC-50014: Fatal: Execution of AutoConfig was failed in R12.

While cloning, adcfgclone.pl error:RC-50014: Fatal: Execution of AutoConfig was failed in R12.
When we check the log file we can see the error like below
AutoConfig could not successfully instantiate the following files:


adcrdb.sh INSTE8

AutoConfig is exiting with status 1

RC-50014: Fatal: Execution of AutoConfig was failed


Solution: Copy adcrdb.sh file ($ORACLE_HOME/appsutil/template) from
Source to target ($ORACLE_HOME/appsutil/template) then
we run the adcfgclone.pl dbTier again.

Oracle’s OS Watcher tool (oswbb)

Oracle’s OS Watcher tool (oswbb)

Oracle’s OS Watcher tool (oswbb) runs shell scripts that run the operating system tools (ps, top, ifconfig, mpstat, iostat, netstat, traceroute, vmstat, meminfo (Linux Only), slabinfo (Linux Only)) to collect CPU, Memory, I/O and Network usage and collate the results. OSWatcher Analyzer (oswbba) presents these results graphically.

oswbb and oswbba require installation, however this is relatively simple and there is little overhead.

By default the diagnostics are only retained for 48 hours, but this can be configured.

Note that it is a unix / linux based utility.

OSWatcher (Includes: [Video]) (Document 301137.1)

OS Watcher User's Guide (Document 1531223.1)

OSWatcher Analyzer User Guide (Document 461053.1)