SQL> SELECT distinct segment_type from dba_Segments;
SEGMENT_TYPE
------------------
INDEX
CLUSTER
TABLE PARTITION
LOBINDEX
TABLE SUBPARTITION
SYSTEM STATISTICS
LOBSEGMENT
INDEX PARTITION
ROLLBACK
TABLE
LOB PARTITION
SEGMENT_TYPE
------------------
NESTED TABLE
TYPE2 UNDO
13 rows selected.
Create a sample non partitioned table
kIsH@zxd00<^>create table tp as
select
rownum as rid,
case
when mod(trunc(dbms_random.value(1,100000)),2) = 0 then 'Male'
when mod(trunc(dbms_random.value(1,100000)),2) = 1 then 'Female'
else 'Others'
end as Gender,
add_months(sysdate, - trunc(dbms_random.value(1,10))) as cdate
from dual
connect by rownum <= 100000
/ 2 3 4 5 6 7 8 9 10 11 12
Table created.
Enable constraints and index on the table
kIsH@zxd00<^>ALTER table tp add constraint t_pk primary key(rid);
Table altered.
kIsH@zxd00<^>CREATE index tidx on tp(cdate);
Index created.
Check the segments created.
kIsH@zxd00<^>col SEGMENT_NAME for a29
kIsH@zxd00<^>col SEGMENT_NAME for a20
kIsH@zxd00<^>col segment_type for a20
kIsH@zxd00<^> SELECT segment_name,segment_type FROM dba_segments WHERE segment_name in ('TP','TIDX','T_PK') order by segment_type;
SEGMENT_NAME SEGMENT_TYPE
-------------------- --------------------
T_PK INDEX
TIDX INDEX
TP TABLE
A single command is sufficient to convert a non partitioned table to partitioned table.
kIsH@zxd00<^>ALTER table tp modify partition by range(cdate) interval(numtoyminterval(1, 'MONTH'))(partition p_default values less than (to_date('2023-01-01', 'YYYY-MM-DD')));
Table altered.
Check the converted partitions after the process.
kIsH@zxd00<^>SELECT segment_name,segment_type FROM dba_segments WHERE segment_name in ('TP','TIDX','T_PK');
SEGMENT_NAME SEGMENT_TYPE
-------------------- --------------------
T_PK INDEX
TIDX INDEX PARTITION
TIDX INDEX PARTITION
TIDX INDEX PARTITION
TIDX INDEX PARTITION
TIDX INDEX PARTITION
TIDX INDEX PARTITION
TIDX INDEX PARTITION
TIDX INDEX PARTITION
TIDX INDEX PARTITION
TP TABLE PARTITION
TP TABLE PARTITION
TP TABLE PARTITION
TP TABLE PARTITION
TP TABLE PARTITION
TP TABLE PARTITION
TP TABLE PARTITION
TP TABLE PARTITION
TP TABLE PARTITION
19 rows selected.
SQL> SELECT * from v$log;
GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM NEXT_CHANGE# NEXT_TIME CON_ID
---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- --------- ------------ --------- ----------
1 1 19 209715200 512 1 YES INACTIVE 2801844 26-MAY-23 2914294 13-JUN-23 0
2 1 20 209715200 512 1 YES INACTIVE 2914294 13-JUN-23 3021428 22-SEP-23 0
3 1 21 209715200 512 1 NO CURRENT 3021428 22-SEP-23 1.8447E+19 0
SQL> col MEMBER for a20
SQL> SELECT * from v$logfile;
GROUP# STATUS TYPE MEMBER IS_ CON_ID
---------- ------- ------- -------------------- --- ----------
3 ONLINE /apps01/oradata/HYDR NO 0
A1/redo03.log
2 ONLINE /apps01/oradata/HYDR NO 0
A1/redo02.log
1 ONLINE /apps01/oradata/HYDR NO 0
A1/redo01.log
SQL> SELECT MEMBER from v$logfile lf,v$log l WHERE lf.group# = l.group# and l.status='CURRENT';
MEMBER
--------------------------------------------------------------------------------
/apps01/oradata/HYDRA1/redo02.log
RMAN> run
2> {
3> backup as backupset database plus archivelog delete input;
4> backup current controlfile;
5> }
Starting backup at 22-SEP-23
current log archived
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=102 device type=DISK
SQL> !rm -rf /apps01/oradata/HYDRA1/redo02.log
SQL> CREATE table t as select * from dba_source;
Table created.
SQL> INSERT into t SELECT * from dba_source;
291055 rows created.
SQL> commit;
Commit complete.
SQL> SELECT MEMBER from v$logfile lf,v$log l WHERE lf.group# = l.group# and l.status='CURRENT';
MEMBER
--------------------------------------------------------------------------------
/apps01/oradata/HYDRA1/redo02.log
SQL> INSERT into t SELECT * from dba_source;
291055 rows created.
SQL> INSERT into t SELECT * from dba_source;
291055 rows created.
SQL> commit;
Commit complete.
SQL> SELECT MEMBER from v$logfile lf,v$log l WHERE lf.group# = l.group# and l.status='CURRENT';
MEMBER
--------------------------------------------------------------------------------
/apps01/oradata/HYDRA1/redo03.log
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: '/apps01/oradata/HYDRA1/redo02.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
2023-09-22T20:44:00.554450+05:30
Errors in file /u01/app/oracle/diag/rdbms/hydra1/hydra1/trace/hydra1_mz00_30790.trc:
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: '/apps01/oradata/HYDRA1/redo02.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
Checker run found 2 new persistent data failures
SQL> ALTER database clear unarchived logfile GROUP 2;
Database altered.
SQL> ALTER database drop logfile group 2;
Database altered.
SQL> ALTER database add logfile group 2;
Database altered.
SQL> ALTER system switch logfile;
System altered.
SQL> /
System altered.
SQL> /
/
System altered.
SQL>
System altered.
As per Oracle documentation, any user who create a user defined stored procedure and embed any SYS related stored procedure like DBMS_STATS inside it, any role which is granted to the user is skipped inside PL/SQL or procedure or trigger etc.. and throws an error ORA-20000. But individual grants work correctly.
Grant the basic privileges to new user with gather_system_statistics role to gather system statistics.
kIsH@zxd00<^>alter session set "_ORACLE_SCRIPT"=true;
Session altered.
kIsH@zxd00<^>create user test identified by password;
User created.
kIsH@zxd00<^>grant create session,connect,resource,gather_system_statistics to test;
Grant succeeded.
The new user is able to gather system stats without issues with the normal method.
kIsH@zxd00<^>conn test/password
Connected.
kIsH@zxd00<^>EXEC dbms_stats.gather_system_stats();
PL/SQL procedure successfully completed.
Now, create a stored procedure and embed DBMS_STATS command in it.
CREATE OR REPLACE procedure sysstat
AS
BEGIN
dbms_stats.gather_system_stats();
dbms_output.put_line('Executed!');
END;
/
kIsH@zxd00<^>CREATE OR REPLACE procedure sysstat
AS
BEGIN
dbms_stats.gather_system_stats();
dbms_output.put_line('Executed!');
END;
/ 2 3 4 5 6 7
Procedure created.
This does not allow the new user to gather system statistics with ORA-20000
kIsH@zxd00<^>EXEC sysstat
BEGIN sysstat; END;
*
ERROR at line 1:
ORA-20000: Unable to gather system statistics : insufficient privileges
ORA-06512: at "SYS.DBMS_STATS", line 46421
ORA-06512: at "SYS.DBMS_STATS", line 46314
ORA-06512: at "TEST.SYSSTAT", line 4
ORA-06512: at line 1
Grant individual privilege to the user on aux_stats$ and wri$_optstat_aux_history internal tables.
kIsH@zxd00<^>col TABLE_NAME for a20
kIsH@zxd00<^>col PRIVILEGE for a20
kIsH@zxd00<^>SELECT role,privilege,table_name FROM role_tab_privs WHERE role='GATHER_SYSTEM_STATISTICS';
ROLE PRIVILEGE TABLE_NAME
-------------------- -------------------- --------------------
GATHER_SYSTEM_STATIS DELETE AUX_STATS$
TICS
GATHER_SYSTEM_STATIS INSERT AUX_STATS$
TICS
GATHER_SYSTEM_STATIS SELECT AUX_STATS$
TICS
GATHER_SYSTEM_STATIS UPDATE AUX_STATS$
TICS
GATHER_SYSTEM_STATIS DELETE WRI$_OPTSTAT_AUX_HIS
TICS TORY
GATHER_SYSTEM_STATIS INSERT WRI$_OPTSTAT_AUX_HIS
TICS TORY
GATHER_SYSTEM_STATIS SELECT WRI$_OPTSTAT_AUX_HIS
TICS TORY
GATHER_SYSTEM_STATIS UPDATE WRI$_OPTSTAT_AUX_HIS
TICS TORY
8 rows selected.
kIsH@zxd00<^>grant select,insert,update,delete on aux_stats$ to test;
Grant succeeded.
kIsH@zxd00<^>grant select,insert,update,delete on wri$_optstat_aux_history to test;
Grant succeeded.
Once the individual privilege is granted, the user defined procedure executed successfully.
kIsH@zxd00<^>conn test/password
Connected.
kIsH@zxd00<^>set serveroutput on
kIsH@zxd00<^>EXEC sysstat
Executed!
PL/SQL procedure successfully completed.
PS C:\Windows\system32> choco install virtualbox --version=7.0.8 -y
Chocolatey v1.2.1
Installing the following packages:
virtualbox
By installing, you accept licenses for the packages.
virtualbox v7.0.8 [Approved]
virtualbox package files install completed. Performing other installation steps.
#< CLIXML
<Objs Version="1.1.0.1" xmlns="http://schemas.microsoft.com/powershell/2004/04"><Obj S="progress" RefId="0"><TN RefId="0"><T>System.Management.Automation.PSCustomObject</T><T>System.Object</T></TN><MS><I64 N="SourceId">1</I64><PR N="Record"><AV>Preparing modules for first use.</AV><AI>0</AI><Nil /><PI>-1</PI><PC>-1</PC><T>Completed</T><SR>-1</SR><SD> </SD></PR></MS></Obj><Obj S="progress" RefId="1"><TNRef RefId="0" /><MS><I64 N="SourceId">1</I64><PR N="Record"><AV>Preparing modules for first use.</AV><AI>0</AI><Nil /><PI>-1</PI><PC>-1</PC><T>Completed</T><SR>-1</SR><SD> </SD></PR></MS></Obj><S S="debug">Host version is 5.1.19041.3031, PowerShell Version is '5.1.19041.3031' and CLR Version is '4.0.30319.42000'.</S><S S="verbose">Exporting function 'Format-FileSize'.</S><S S="verbose">Exporting function 'Get-ChecksumValid'.</S><S S="verbose">Exporting function 'Get-ChocolateyPath'.</S><S S="verbose">Exporting function 'Get-ChocolateyUnzip'.</S><S S="verbose">Exporting function 'Get-ChocolateyWebFile'.</S><S S="verbose">Exporting function 'Get-EnvironmentVariable'.</S><S S="verbose">Exporting function 'Get-EnvironmentVariableNames'.</S><S S="verbose">Exporting function 'Get-FtpFile'.</S><S S="verbose">Exporting function 'Get-OSArchitectureWidth'.</S><S S="verbose">Exporting function 'Get-PackageParameters'.</S><S S="verbose">Exporting function 'Get-PackageParametersBuiltIn'.</S><S S="verbose">Exporting function 'Get-ToolsLocation'.</S><S S="verbose">Exporting function 'Get-UACEnabled'.</S><S S="verbose">Exporting function 'Get-UninstallRegistryKey'.</S><S S="verbose">Exporting function 'Get-VirusCheckValid'.</S><S S="verbose">Exporting function 'Get-WebFile'.</S><S S="verbose">Exporting function 'Get-WebFileName'.</S><S S="verbose">Exporting function 'Get-WebHeaders'.</S><S S="verbose">Exporting function 'Install-BinFile'.</S><S S="verbose">Exporting function 'Install-ChocolateyEnvironmentVariable'.</S><S S="verbose">Exporting function 'Install-ChocolateyExplorerMenuItem'.</S><S S="verbose">Exporting function 'Install-ChocolateyFileAssociation'.</S><S S="verbose">Exporting function 'Install-ChocolateyInstallPackage'.</S><S S="verbose">Exporting function 'Install-ChocolateyPackage'.</S><S S="verbose">Exporting function 'Install-ChocolateyPath'.</S><S S="verbose">Exporting function 'Install-ChocolateyPinnedTaskBarItem'.</S><S S="verbose">Exporting function 'Install-ChocolateyPowershellCommand'.</S><S S="verbose">Exporting function 'Install-ChocolateyShortcut'.</S><S S="verbose">Exporting function 'Install-ChocolateyVsixPackage'.</S><S S="verbose">Exporting function 'Install-ChocolateyZipPackage'.</S><S S="verbose">Exporting function 'Install-Vsix'.</S><S S="verbose">Exporting function 'Set-EnvironmentVariable'.</S><S S="verbose">Exporting function 'Set-PowerShellExitCode'.</S><S S="verbose">Exporting function 'Start-ChocolateyProcessAsAdmin'.</S><S S="verbose">Exporting function 'Test-ProcessAdminRights'.</S><S S="verbose">Exporting function 'Uninstall-BinFile'.</S><S S="verbose">Exporting function 'Uninstall-ChocolateyEnvironmentVariable'.</S><S S="verbose">Exporting function 'Uninstall-ChocolateyPackage'.</S><S S="verbose">Exporting function 'Uninstall-ChocolateyZipPackage'.</S><S S="verbose">Exporting function 'Update-SessionEnvironment'.</S><S S="verbose">Exporting function 'Write-FunctionCallLogMessage'.</S><S S="verbose">Exporting alias 'Get-ProcessorBits'.</S><S S="verbose">Exporting alias 'Get-OSBitness'.</S><S S="verbose">Exporting alias 'Get-InstallRegistryKey'.</S><S S="verbose">Exporting alias 'Generate-BinFile'.</S><S S="verbose">Exporting alias 'Add-BinFile'.</S><S S="verbose">Exporting alias 'Start-ChocolateyProcess'.</S><S S="verbose">Exporting alias 'Invoke-ChocolateyProcess'.</S><S S="verbose">Exporting alias 'Remove-BinFile'.</S><S S="verbose">Exporting alias 'refreshenv'.</S><S S="debug">Loading community extensions</S><S S="debug">Importing 'C:\ProgramData\chocolatey\extensions\chocolatey-compatibility\chocolatey-compatibility.psm1'</S><S S="verbose">Loading module from path 'C:\ProgramData\chocolatey\extensions\chocolatey-compatibility\chocolatey-compatibility.psm1'.</S><S S="debug">Function 'Get-PackageParameters' exists, ignoring export.</S><S S="debug">Function 'Get-UninstallRegistryKey' exists, ignoring export.</S><S S="debug">Exporting function 'Install-ChocolateyDesktopLink' for backwards compatibility</S><S S="verbose">Exporting function 'Install-ChocolateyDesktopLink'.</S><S S="debug">Exporting function 'Write-ChocolateyFailure' for backwards compatibility</S><S S="verbose">Exporting function 'Write-ChocolateyFailure'.</S><S S="debug">Exporting function 'Write-ChocolateySuccess' for backwards compatibility</S><S S="verbose">Exporting function 'Write-ChocolateySuccess'.</S><S S="debug">Exporting function 'Write-FileUpdateLog' for backwards compatibility</S><S S="verbose">Exporting function 'Write-FileUpdateLog'.</S><S S="verbose">Importing function 'Install-ChocolateyDesktopLink'.</S><S S="verbose">Importing function 'Write-ChocolateyFailure'.</S><S S="verbose">Importing function 'Write-ChocolateySuccess'.</S><S S="verbose">Importing function 'Write-FileUpdateLog'.</S><S S="debug">Importing 'C:\ProgramData\chocolatey\extensions\chocolatey-core\chocolatey-core.psm1'</S><S S="verbose">Loading module from path 'C:\ProgramData\chocolatey\extensions\chocolatey-core\chocolatey-core.psm1'.</S><S S="verbose">Exporting function 'Get-AppInstallLocation'.</S><S S="verbose">Exporting function 'Get-AvailableDriveLetter'.</S><S S="verbose">Exporting function 'Get-EffectiveProxy'.</S><S S="verbose">Exporting function 'Get-PackageCacheLocation'.</S><S S="verbose">Exporting function 'Get-WebContent'.</S><S S="verbose">Exporting function 'Register-Application'.</S><S S="verbose">Exporting function 'Remove-Process'.</S><S S="verbose">Importing function 'Get-AppInstallLocation'.</S><S S="verbose">Importing function 'Get-AvailableDriveLetter'.</S><S S="verbose">Importing function 'Get-EffectiveProxy'.</S><S S="verbose">Importing function 'Get-PackageCacheLocation'.</S><S S="verbose">Importing function 'Get-WebContent'.</S><S S="verbose">Importing function 'Register-Application'.</S><S S="verbose">Importing function 'Remove-Process'.</S><S S="debug">Importing 'C:\ProgramData\chocolatey\extensions\chocolatey-dotnetfx\chocolatey-dotnetfx.psm1'</S><S S="verbose">Loading module from path 'C:\ProgramData\chocolatey\extensions\chocolatey-dotnetfx\chocolatey-dotnetfx.psm1'.</S><S S="verbose">Exporting function 'Install-DotNetFramework'.</S><S S="verbose">Exporting function 'Install-DotNetDevPack'.</S><S S="verbose">Importing function 'Install-DotNetDevPack'.</S><S S="verbose">Importing function 'Install-DotNetFramework'.</S><S S="debug">Importing 'C:\ProgramData\chocolatey\extensions\chocolatey-visualstudio\chocolatey-visualstudio.extension.psm1'</S><S S="verbose">Loading module from path 'C:\ProgramData\chocolatey\extensions\chocolatey-visualstudio\chocolatey-visualstudio.extension.psm1'.</S><S S="verbose">Exporting function 'Add-VisualStudioComponent'.</S><S S="verbose">Exporting function 'Add-VisualStudioWorkload'.</S><S S="verbose">Exporting function 'Get-VisualStudioInstaller'.</S><S S="verbose">Exporting function 'Get-VisualStudioInstallerHealth'.</S><S S="verbose">Exporting function 'Get-VisualStudioInstance'.</S><S S="verbose">Exporting function 'Get-VisualStudioVsixInstaller'.</S><S S="verbose">Exporting function 'Install-VisualStudio'.</S><S S="verbose">Exporting function 'Install-VisualStudioInstaller'.</S><S S="verbose">Exporting function 'Install-VisualStudioVsixExtension'.</S><S S="verbose">Exporting function 'Remove-VisualStudioComponent'.</S><S S="verbose">Exporting function 'Remove-VisualStudioProduct'.</S><S S="verbose">Exporting function 'Remove-VisualStudioWorkload'.</S><S S="verbose">Exporting function 'Uninstall-VisualStudio'.</S><S S="verbose">Exporting function 'Uninstall-VisualStudioVsixExtension'.</S><S S="verbose">Importing function 'Add-VisualStudioComponent'.</S><S S="verbose">Importing function 'Add-VisualStudioWorkload'.</S><S S="verbose">Importing function 'Get-VisualStudioInstaller'.</S><S S="verbose">Importing function 'Get-VisualStudioInstallerHealth'.</S><S S="verbose">Importing function 'Get-VisualStudioInstance'.</S><S S="verbose">Importing function 'Get-VisualStudioVsixInstaller'.</S><S S="verbose">Importing function 'Install-VisualStudio'.</S><S S="verbose">Importing function 'Install-VisualStudioInstaller'.</S><S S="verbose">Importing function 'Install-VisualStudioVsixExtension'.</S><S S="verbose">Importing function 'Remove-VisualStudioComponent'.</S><S S="verbose">Importing function 'Remove-VisualStudioProduct'.</S><S S="verbose">Importing function 'Remove-VisualStudioWorkload'.</S><S S="verbose">Importing function 'Uninstall-VisualStudio'.</S><S S="verbose">Importing function 'Uninstall-VisualStudioVsixExtension'.</S><S S="debug">Importing 'C:\ProgramData\chocolatey\extensions\chocolatey-windowsupdate\chocolatey-windowsupdate.psm1'</S><S S="verbose">Loading module from path 'C:\ProgramData\chocolatey\extensions\chocolatey-windowsupdate\chocolatey-windowsupdate.psm1'.</S><S S="verbose">Exporting function 'Install-WindowsUpdate'.</S><S S="verbose">Exporting function 'Test-WindowsUpdate'.</S><S S="verbose">Importing function 'Install-WindowsUpdate'.</S><S S="verbose">Importing function 'Test-WindowsUpdate'.</S><S S="verbose">Exporting function 'Format-FileSize'.</S><S S="verbose">Exporting function 'Get-ChecksumValid'.</S><S S="verbose">Exporting function 'Get-ChocolateyPath'.</S><S S="verbose">Exporting function 'Get-ChocolateyUnzip'.</S><S S="verbose">Exporting function 'Get-ChocolateyWebFile'.</S><S S="verbose">Exporting function 'Get-EnvironmentVariable'.</S><S S="verbose">Exporting function 'Get-EnvironmentVariableNames'.</S><S S="verbose">Exporting function 'Get-FtpFile'.</S><S S="verbose">Exporting function 'Get-OSArchitectureWidth'.</S><S S="verbose">Exporting function 'Get-PackageParameters'.</S><S S="verbose">Exporting function 'Get-PackageParametersBuiltIn'.</S><S S="verbose">Exporting function 'Get-ToolsLocation'.</S><S S="verbose">Exporting function 'Get-UACEnabled'.</S><S S="verbose">Exporting function 'Get-UninstallRegistryKey'.</S><S S="verbose">Exporting function 'Get-VirusCheckValid'.</S><S S="verbose">Exporting function 'Get-WebFile'.</S><S S="verbose">Exporting function 'Get-WebFileName'.</S><S S="verbose">Exporting function 'Get-WebHeaders'.</S><S S="verbose">Exporting function 'Install-BinFile'.</S><S S="verbose">Exporting function 'Install-ChocolateyEnvironmentVariable'.</S><S S="verbose">Exporting function 'Install-ChocolateyExplorerMenuItem'.</S><S S="verbose">Exporting function 'Install-ChocolateyFileAssociation'.</S><S S="verbose">Exporting function 'Install-ChocolateyInstallPackage'.</S><S S="verbose">Exporting function 'Install-ChocolateyPackage'.</S><S S="verbose">Exporting function 'Install-ChocolateyPath'.</S><S S="verbose">Exporting function 'Install-ChocolateyPinnedTaskBarItem'.</S><S S="verbose">Exporting function 'Install-ChocolateyPowershellCommand'.</S><S S="verbose">Exporting function 'Install-ChocolateyShortcut'.</S><S S="verbose">Exporting function 'Install-ChocolateyVsixPackage'.</S><S S="verbose">Exporting function 'Install-ChocolateyZipPackage'.</S><S S="verbose">Exporting function 'Install-Vsix'.</S><S S="verbose">Exporting function 'Set-EnvironmentVariable'.</S><S S="verbose">Exporting function 'Set-PowerShellExitCode'.</S><S S="verbose">Exporting function 'Start-ChocolateyProcessAsAdmin'.</S><S S="verbose">Exporting function 'Test-ProcessAdminRights'.</S><S S="verbose">Exporting function 'Uninstall-BinFile'.</S><S S="verbose">Exporting function 'Uninstall-ChocolateyEnvironmentVariable'.</S><S S="verbose">Exporting function 'Uninstall-ChocolateyPackage'.</S><S S="verbose">Exporting function 'Uninstall-ChocolateyZipPackage'.</S><S S="verbose">Exporting function 'Update-SessionEnvironment'.</S><S S="verbose">Exporting function 'Write-FunctionCallLogMessage'.</S><S S="verbose">Exporting function 'Install-ChocolateyDesktopLink'.</S><S S="verbose">Exporting function 'Write-ChocolateyFailure'.</S><S S="verbose">Exporting function 'Write-ChocolateySuccess'.</S><S S="verbose">Exporting function 'Write-FileUpdateLog'.</S><S S="verbose">Exporting function 'Get-AppInstallLocation'.</S><S S="verbose">Exporting function 'Get-AvailableDriveLetter'.</S><S S="verbose">Exporting function 'Get-EffectiveProxy'.</S><S S="verbose">Exporting function 'Get-PackageCacheLocation'.</S><S S="verbose">Exporting function 'Get-WebContent'.</S><S S="verbose">Exporting function 'Register-Application'.</S><S S="verbose">Exporting function 'Remove-Process'.</S><S S="verbose">Exporting function 'Install-DotNetDevPack'.</S><S S="verbose">Exporting function 'Install-DotNetFramework'.</S><S S="verbose">Exporting function 'Add-VisualStudioComponent'.</S><S S="verbose">Exporting function 'Add-VisualStudioWorkload'.</S><S S="verbose">Exporting function 'Get-VisualStudioInstaller'.</S><S S="verbose">Exporting function 'Get-VisualStudioInstallerHealth'.</S><S S="verbose">Exporting function 'Get-VisualStudioInstance'.</S><S S="verbose">Exporting function 'Get-VisualStudioVsixInstaller'.</S><S S="verbose">Exporting function 'Install-VisualStudio'.</S><S S="verbose">Exporting function 'Install-VisualStudioInstaller'.</S><S S="verbose">Exporting function 'Install-VisualStudioVsixExtension'.</S><S S="verbose">Exporting function 'Remove-VisualStudioComponent'.</S><S S="verbose">Exporting function 'Remove-VisualStudioProduct'.</S><S S="verbose">Exporting function 'Remove-VisualStudioWorkload'.</S><S S="verbose">Exporting function 'Uninstall-VisualStudio'.</S><S S="verbose">Exporting function 'Uninstall-VisualStudioVsixExtension'.</S><S S="verbose">Exporting function 'Install-WindowsUpdate'.</S><S S="verbose">Exporting function 'Test-WindowsUpdate'.</S><S S="verbose">Exporting alias 'Get-ProcessorBits'.</S><S S="verbose">Exporting alias 'Get-OSBitness'.</S><S S="verbose">Exporting alias 'Get-InstallRegistryKey'.</S><S S="verbose">Exporting alias 'Generate-BinFile'.</S><S S="verbose">Exporting alias 'Add-BinFile'.</S><S S="verbose">Exporting alias 'Start-ChocolateyProcess'.</S><S S="verbose">Exporting alias 'Invoke-ChocolateyProcess'.</S><S S="verbose">Exporting alias 'Remove-BinFile'.</S><S S="verbose">Exporting alias 'refreshenv'.</S></Objs>
0
Downloading virtualbox 64 bit
from 'https://download.virtualbox.org/virtualbox/7.0.8/VirtualBox-7.0.8-156879-Win.exe'
Progress: 100% - Completed download of C:\Users\kisha\AppData\Local\Temp\chocolatey\virtualbox\7.0.8\VirtualBox-7.0.8-156879-Win.exe (105.5 MB).
Download of VirtualBox-7.0.8-156879-Win.exe (105.5 MB) completed.
Hashes match.
Installing virtualbox...
virtualbox has been installed.
Adding to PATH if needed
PATH environment variable does not have C:\Program Files\Oracle\VirtualBox in it. Adding...
virtualbox installed to 'C:\Program Files\Oracle\VirtualBox'
virtualbox registered as vbox
Only an exit code of non-zero will fail the package by default. Set
`--failonstderr` if you want error messages to also fail a script. See
`choco -h` for details.
virtualbox may be able to be automatically uninstalled.
Environment Vars (like PATH) have changed. Close/reopen your shell to
see the changes (or in powershell/cmd.exe just type `refreshenv`).
The install of virtualbox was successful.
Software installed as 'EXE', install location is likely default.
Chocolatey installed 1/1 packages.
See the log for details (C:\ProgramData\chocolatey\logs\chocolatey.log).
PS C:\Windows\system32> choco install vagrant --version=2.3.4 -y
Chocolatey v1.2.1
Installing the following packages:
vagrant
By installing, you accept licenses for the packages.
Progress: Downloading vagrant 2.3.4... 100%
vagrant v2.3.4 [Approved]
vagrant package files install completed. Performing other installation steps.
Downloading vagrant 64 bit
from 'https://releases.hashicorp.com/vagrant/2.3.4/vagrant_2.3.4_windows_amd64.msi'
Progress: 100% - Completed download of C:\Users\kisha\AppData\Local\Temp\chocolatey\vagrant\2.3.4\vagrant_2.3.4_windows_amd64.msi (249.57 MB).
Download of vagrant_2.3.4_windows_amd64.msi (249.57 MB) completed.
Hashes match.
Installing vagrant...
vagrant has been installed.
==> vagrant: A new version of Vagrant is available: 2.3.7 (installed version: 2.3.4)!
==> vagrant: To upgrade visit: https://www.vagrantup.com/downloads.html
System.Management.Automation.RemoteException
Updating installed plugins...
All plugins are up to date.
Repairing currently installed global plugins. This may take a few minutes...
Installed plugins successfully repaired!
vagrant may be able to be automatically uninstalled.
Environment Vars (like PATH) have changed. Close/reopen your shell to
see the changes (or in powershell/cmd.exe just type `refreshenv`).
The install of vagrant was successful.
Software installed as 'msi', install location is likely default.
Chocolatey installed 1/1 packages.
See the log for details (C:\ProgramData\chocolatey\logs\chocolatey.log).
Packages requiring reboot:
- vagrant (exit code 3010)
The recent package changes indicate a reboot is necessary.
Please reboot at your earliest convenience.
PS C:\Windows\system32> choco install git -y
Chocolatey v1.2.1
Installing the following packages:
git
By installing, you accept licenses for the packages.
Progress: Downloading git.install 2.42.0... 100%
Progress: Downloading git 2.42.0... 100%
git.install v2.42.0 [Approved]
git.install package files install completed. Performing other installation steps.
Using Git LFS
Installing 64-bit git.install...
git.install has been installed.
git.install installed to 'C:\Program Files\Git'
git.install can be automatically uninstalled.
Environment Vars (like PATH) have changed. Close/reopen your shell to
see the changes (or in powershell/cmd.exe just type `refreshenv`).
The install of git.install was successful.
Software installed to 'C:\Program Files\Git\'
git v2.42.0 [Approved]
git package files install completed. Performing other installation steps.
The install of git was successful.
Software installed to 'C:\ProgramData\chocolatey\lib\git'
Chocolatey installed 2/2 packages.
See the log for details (C:\ProgramData\chocolatey\logs\chocolatey.log).
PS C:\Windows\system32> choco install corretto11jdk -y
Chocolatey v1.2.1
Installing the following packages:
corretto11jdk
By installing, you accept licenses for the packages.
Progress: Downloading corretto11jdk 11.0.20... 100%
corretto11jdk v11.0.20 [Approved]
corretto11jdk package files install completed. Performing other installation steps.
Downloading corretto11jdk 64 bit
from 'https://corretto.aws/downloads/resources/11.0.20.8.1/amazon-corretto-11.0.20.8.1-windows-x64.msi'
Progress: 100% - Completed download of C:\Users\kisha\AppData\Local\Temp\chocolatey\corretto11jdk\11.0.20\amazon-corretto-11.0.20.8.1-windows-x64.msi (161.17 MB).
Download of amazon-corretto-11.0.20.8.1-windows-x64.msi (161.17 MB) completed.
Hashes match.
Installing corretto11jdk...
corretto11jdk has been installed.
corretto11jdk may be able to be automatically uninstalled.
Environment Vars (like PATH) have changed. Close/reopen your shell to
see the changes (or in powershell/cmd.exe just type `refreshenv`).
The install of corretto11jdk was successful.
Software installed as 'msi', install location is likely default.
Chocolatey installed 1/1 packages.
See the log for details (C:\ProgramData\chocolatey\logs\chocolatey.log).
PS C:\Windows\system32> choco install maven -y
Chocolatey v1.2.1
Installing the following packages:
maven
By installing, you accept licenses for the packages.
Progress: Downloading maven 3.9.4... 100%
maven v3.9.4 [Approved]
maven package files install completed. Performing other installation steps.
C:\Users\kisha\.m2
PATH environment variable does not have C:\ProgramData\chocolatey\lib\maven\apache-maven-3.9.4\bin in it. Adding...
Environment Vars (like PATH) have changed. Close/reopen your shell to
see the changes (or in powershell/cmd.exe just type `refreshenv`).
The install of maven was successful.
Software installed to 'C:\ProgramData\chocolatey\lib\maven\apache-maven-3.9.4'
Chocolatey installed 1/1 packages.
See the log for details (C:\ProgramData\chocolatey\logs\chocolatey.log).
PS C:\Windows\system32> choco install awscli -y
Chocolatey v1.2.1
Installing the following packages:
awscli
By installing, you accept licenses for the packages.
Progress: Downloading awscli 2.13.16... 100%
awscli v2.13.16 [Approved]
awscli package files install completed. Performing other installation steps.
Downloading awscli 64 bit
from 'https://awscli.amazonaws.com/AWSCLIV2-2.13.16.msi'
Progress: 100% - Completed download of C:\Users\kisha\AppData\Local\Temp\chocolatey\awscli\2.13.16\AWSCLIV2-2.13.16.msi (37.44 MB).
Download of AWSCLIV2-2.13.16.msi (37.44 MB) completed.
Hashes match.
Installing awscli...
awscli has been installed.
awscli may be able to be automatically uninstalled.
Environment Vars (like PATH) have changed. Close/reopen your shell to
see the changes (or in powershell/cmd.exe just type `refreshenv`).
The install of awscli was successful.
Software installed as 'MSI', install location is likely default.
Chocolatey installed 1/1 packages.
See the log for details (C:\ProgramData\chocolatey\logs\chocolatey.log).
PS C:\Windows\system32> choco install intellijidea-community -y
Chocolatey v1.2.1
Installing the following packages:
intellijidea-community
By installing, you accept licenses for the packages.
Progress: Downloading intellijidea-community 2023.2.1... 100%
intellijidea-community v2023.2.1 [Approved]
intellijidea-community package files install completed. Performing other installation steps.
WARNING: No registry key found based on 'IntelliJ IDEA Community Edition*'
C:\Program Files\JetBrains\IntelliJ IDEA Community Edition 2023.2.1
Downloading intellijidea-community 64 bit
from 'https://download.jetbrains.com/idea/ideaIC-2023.2.1.exe'
Progress: 100% - Completed download of C:\Users\kisha\AppData\Local\Temp\chocolatey\intellijidea-community\2023.2.1\ideaIC-2023.2.1.exe (663.63 MB).
Download of ideaIC-2023.2.1.exe (663.63 MB) completed.
Hashes match.
Installing intellijidea-community...
Chocolatey timed out waiting for the command to finish. The timeout
specified (or the default value) was '2700' seconds. Perhaps try a
higher `--execution-timeout`? See `choco -h` for details.
The install of intellijidea-community was NOT successful.
Error while running 'C:\ProgramData\chocolatey\lib\intellijidea-community\tools\chocolateyInstall.ps1'.
See log for details.
Chocolatey installed 0/1 packages. 1 packages failed.
See the log for details (C:\ProgramData\chocolatey\logs\chocolatey.log).
Failures
- intellijidea-community (exited -1) - Error while running 'C:\ProgramData\chocolatey\lib\intellijidea-community\tools\chocolateyInstall.ps1'.
See log for details.
PS C:\Windows\system32> choco install vscode -y
Chocolatey v1.2.1
Installing the following packages:
vscode
By installing, you accept licenses for the packages.
Progress: Downloading vscode.install 1.82.0... 100%
Progress: Downloading vscode 1.82.0... 100%
vscode.install v1.82.0 [Approved]
vscode.install package files install completed. Performing other installation steps.
WARNING: No registry key found based on 'Microsoft Visual Studio Code'
Merge Tasks: !runCode, desktopicon, quicklaunchicon, addcontextmenufiles, addcontextmenufolders, associatewithfiles, addtopath
Downloading vscode.install 64 bit
from 'https://update.code.visualstudio.com/1.82.0/win32-x64/stable'
Progress: 100% - Completed download of C:\Users\kisha\AppData\Local\Temp\chocolatey\vscode.install\1.82.0\VSCodeSetup-x64-1.82.0.exe (89.97 MB).
Download of VSCodeSetup-x64-1.82.0.exe (89.97 MB) completed.
Hashes match.
Installing vscode.install...
vscode.install has been installed.
vscode.install can be automatically uninstalled.
Environment Vars (like PATH) have changed. Close/reopen your shell to
see the changes (or in powershell/cmd.exe just type `refreshenv`).
The install of vscode.install was successful.
Software installed to 'C:\Program Files\Microsoft VS Code\'
vscode v1.82.0 [Approved]
vscode package files install completed. Performing other installation steps.
The install of vscode was successful.
Software installed to 'C:\ProgramData\chocolatey\lib\vscode'
Chocolatey installed 2/2 packages.
See the log for details (C:\ProgramData\chocolatey\logs\chocolatey.log).
PS C:\Windows\system32> choco install sublimetext3.app -y
Chocolatey v1.2.1
Installing the following packages:
sublimetext3.app
By installing, you accept licenses for the packages.
Progress: Downloading SublimeText3 3.2.2... 100%
Progress: Downloading SublimeText3.app 3.0.0.3065... 100%
Progress: Downloading SublimeText3.PowershellAlias 0.1.0... 100%
Progress: Downloading SublimeText3.PackageControl 2.0.0.20140915... 100%
SublimeText3 v3.2.2 [Approved]
sublimetext3 package files install completed. Performing other installation steps.
Downloading SublimeText3 64 bit
from 'https://download.sublimetext.com/Sublime%20Text%20Build%203211%20x64%20Setup.exe'
Progress: 100% - Completed download of C:\Users\kisha\AppData\Local\Temp\chocolatey\SublimeText3\3.2.2\Sublime Text Build 3211 x64 Setup.exe (10.42 MB).
Download of Sublime Text Build 3211 x64 Setup.exe (10.42 MB) completed.
Hashes match.
Installing SublimeText3...
SublimeText3 has been installed.
sublimetext3 can be automatically uninstalled.
The install of sublimetext3 was successful.
Software installed to 'C:\Program Files\Sublime Text 3\'
SublimeText3.PowershellAlias v0.1.0
sublimetext3.powershellalias package files install completed. Performing other installation steps.
Added subl alias to Powershell profile to launch Sublime Text 3!
WARNING: Write-ChocolateySuccess was removed in Chocolatey CLI v1, and have no functionality any more. If you are the maintainer, please remove it from from your package file.
WARNING: If you are not the maintainer, please contact the maintainer to update the SublimeText3.PowershellAlias package.
The install of sublimetext3.powershellalias was successful.
Software install location not explicitly set, it could be in package or
default install location of installer.
SublimeText3.PackageControl v2.0.0.20140915 [Approved] - Possibly broken
sublimetext3.packagecontrol package files install completed. Performing other installation steps.
C:\Users\kisha\AppData\Roaming\Sublime Text 3\Installed Packages
cmdlet Get-ChocolateyWebFile at command pipeline position 1
packageName
Confirmation (`-y`) is set.
Respond within 30 seconds or the default selection will be chosen.
WARNING: Write-ChocolateyFailure was removed in Chocolatey CLI v1. If you are the package maintainer, please use 'throw $_.Exception' instead.
WARNING: If you are not the maintainer, please contact the maintainer to update the SublimeText3.PackageControl package.
ERROR: Cannot process command because of one or more missing mandatory parameters: packageName.
The install of sublimetext3.packagecontrol was NOT successful.
Error while running 'C:\ProgramData\chocolatey\lib\SublimeText3.PackageControl\tools\chocolateyInstall.ps1'.
See log for details.
SublimeText3.app v3.0.0.3065 [Approved] - Possibly broken
sublimetext3.app package files install completed. Performing other installation steps.
The install of sublimetext3.app was successful.
Software installed to 'C:\ProgramData\chocolatey\lib\SublimeText3.app'
Chocolatey installed 3/4 packages. 1 packages failed.
See the log for details (C:\ProgramData\chocolatey\logs\chocolatey.log).
Failures
- sublimetext3.packagecontrol (exited -1) - Error while running 'C:\ProgramData\chocolatey\lib\SublimeText3.PackageControl\tools\chocolateyInstall.ps1'.
See log for details.
PS C:\Windows\system32>This flow chart can be used for presentation to explain for easy understanding of performance diagnosis.
