Saturday, November 23, 2024

How to install brew on Apple Mac ?

Steps to install brew on Mac


Go to below website : 
    https://brew.sh/

anurag@Anurags-MacBook-Air /opt % 

anurag@Anurags-MacBook-Air /opt % 

anurag@Anurags-MacBook-Air /opt % /bin/bash -c "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/HEAD/install.sh)"

==> Checking for `sudo` access (which may request your password)...

Password:

==> This script will install:

/opt/homebrew/bin/brew

/opt/homebrew/share/doc/homebrew

/opt/homebrew/share/man/man1/brew.1

/opt/homebrew/share/zsh/site-functions/_brew

/opt/homebrew/etc/bash_completion.d/brew

/opt/homebrew

==> The following new directories will be created:

/opt/homebrew/bin

/opt/homebrew/etc

/opt/homebrew/include

/opt/homebrew/lib

/opt/homebrew/sbin

/opt/homebrew/share

/opt/homebrew/var

/opt/homebrew/opt

/opt/homebrew/share/zsh

/opt/homebrew/share/zsh/site-functions

/opt/homebrew/var/homebrew

/opt/homebrew/var/homebrew/linked

/opt/homebrew/Cellar

/opt/homebrew/Caskroom

/opt/homebrew/Frameworks

==> The Xcode Command Line Tools will be installed.


Press RETURN/ENTER to continue or any other key to abort:

==> /usr/bin/sudo /usr/bin/install -d -o root -g wheel -m 0755 /opt/homebrew

==> /usr/bin/sudo /bin/mkdir -p /opt/homebrew/bin /opt/homebrew/etc /opt/homebrew/include /opt/homebrew/lib /opt/homebrew/sbin /opt/homebrew/share /opt/homebrew/var /opt/homebrew/opt /opt/homebrew/share/zsh /opt/homebrew/share/zsh/site-functions /opt/homebrew/var/homebrew /opt/homebrew/var/homebrew/linked /opt/homebrew/Cellar /opt/homebrew/Caskroom /opt/homebrew/Frameworks

==> /usr/bin/sudo /bin/chmod ug=rwx /opt/homebrew/bin /opt/homebrew/etc /opt/homebrew/include /opt/homebrew/lib /opt/homebrew/sbin /opt/homebrew/share /opt/homebrew/var /opt/homebrew/opt /opt/homebrew/share/zsh /opt/homebrew/share/zsh/site-functions /opt/homebrew/var/homebrew /opt/homebrew/var/homebrew/linked /opt/homebrew/Cellar /opt/homebrew/Caskroom /opt/homebrew/Frameworks

==> /usr/bin/sudo /bin/chmod go-w /opt/homebrew/share/zsh /opt/homebrew/share/zsh/site-functions

==> /usr/bin/sudo /usr/sbin/chown anurag /opt/homebrew/bin /opt/homebrew/etc /opt/homebrew/include /opt/homebrew/lib /opt/homebrew/sbin /opt/homebrew/share /opt/homebrew/var /opt/homebrew/opt /opt/homebrew/share/zsh /opt/homebrew/share/zsh/site-functions /opt/homebrew/var/homebrew /opt/homebrew/var/homebrew/linked /opt/homebrew/Cellar /opt/homebrew/Caskroom /opt/homebrew/Frameworks

==> /usr/bin/sudo /usr/bin/chgrp admin /opt/homebrew/bin /opt/homebrew/etc /opt/homebrew/include /opt/homebrew/lib /opt/homebrew/sbin /opt/homebrew/share /opt/homebrew/var /opt/homebrew/opt /opt/homebrew/share/zsh /opt/homebrew/share/zsh/site-functions /opt/homebrew/var/homebrew /opt/homebrew/var/homebrew/linked /opt/homebrew/Cellar /opt/homebrew/Caskroom /opt/homebrew/Frameworks

==> /usr/bin/sudo /usr/sbin/chown -R anurag:admin /opt/homebrew

==> /usr/bin/sudo /bin/mkdir -p /Users/anurag/Library/Caches/Homebrew

==> /usr/bin/sudo /bin/chmod g+rwx /Users/anurag/Library/Caches/Homebrew

==> /usr/bin/sudo /usr/sbin/chown -R anurag /Users/anurag/Library/Caches/Homebrew

==> Searching online for the Command Line Tools

==> /usr/bin/sudo /usr/bin/touch /tmp/.com.apple.dt.CommandLineTools.installondemand.in-progress


==> Installing Command Line Tools for Xcode-16.1

==> /usr/bin/sudo /usr/sbin/softwareupdate -i Command\ Line\ Tools\ for\ Xcode-16.1

Software Update Tool


Finding available software


Downloading Command Line Tools for Xcode

Downloaded Command Line Tools for Xcode

Installing Command Line Tools for Xcode

Done with Command Line Tools for Xcode

Done.

==> /usr/bin/sudo /usr/bin/xcode-select --switch /Library/Developer/CommandLineTools

==> /usr/bin/sudo /bin/rm -f /tmp/.com.apple.dt.CommandLineTools.installondemand.in-progress

==> Downloading and installing Homebrew...

remote: Enumerating objects: 286212, done.

remote: Counting objects: 100% (17267/17267), done.

remote: Compressing objects: 100% (891/891), done.

remote: Total 286212 (delta 16542), reused 16714 (delta 16346), pack-reused 268945 (from 1)

remote: Enumerating objects: 55, done.

remote: Counting objects: 100% (34/34), done.

remote: Total 55 (delta 33), reused 33 (delta 33), pack-reused 21 (from 1)

==> Updating Homebrew...

==> Downloading https://ghcr.io/v2/homebrew/portable-ruby/portable-ruby/blobs/sha256:303bed4c7fc431a685db3c3c151d873740114adbdccd23762ea2d1e39ea78f47

######################################################################################################################################################################################################### 100.0%

==> Pouring portable-ruby-3.3.6.arm64_big_sur.bottle.tar.gz

Warning: /opt/homebrew/bin is not in your PATH.

  Instructions on how to configure your shell for Homebrew

  can be found in the 'Next steps' section below.

==> Installation successful!


==> Homebrew has enabled anonymous aggregate formulae and cask analytics.

Read the analytics documentation (and how to opt-out) here:

  https://docs.brew.sh/Analytics

No analytics data has been sent yet (nor will any be during this install run).


==> Homebrew is run entirely by unpaid volunteers. Please consider donating:

  https://github.com/Homebrew/brew#donations


==> Next steps:

- Run these commands in your terminal to add Homebrew to your PATH:

    echo >> /Users/anurag/.zprofile

    echo 'eval "$(/opt/homebrew/bin/brew shellenv)"' >> /Users/anurag/.zprofile

    eval "$(/opt/homebrew/bin/brew shellenv)"

- Run brew help to get started

- Further documentation:

    https://docs.brew.sh


anurag@Anurags-MacBook-Air /opt % 

anurag@Anurags-MacBook-Air /opt % echo >> /Users/anurag/.zprofile

anurag@Anurags-MacBook-Air /opt % echo 'eval "$(/opt/homebrew/bin/brew shellenv)"' >> /Users/anurag/.zprofile

anurag@Anurags-MacBook-Air /opt % eval "$(/opt/homebrew/bin/brew shellenv)"

anurag@Anurags-MacBook-Air /opt %  




anurag@Anurags-MacBook-Air /opt % 

anurag@Anurags-MacBook-Air /opt % 

anurag@Anurags-MacBook-Air /opt % which brew

/opt/homebrew/bin/brew

anurag@Anurags-MacBook-Air /opt % brew help

Example usage:

  brew search TEXT|/REGEX/

  brew info [FORMULA|CASK...]

  brew install FORMULA|CASK...

  brew update

  brew upgrade [FORMULA|CASK...]

  brew uninstall FORMULA|CASK...

  brew list [FORMULA|CASK...]


Troubleshooting:

  brew config

  brew doctor

  brew install --verbose --debug FORMULA|CASK


Contributing:

  brew create URL [--no-fetch]

  brew edit [FORMULA|CASK...]


Further help:

  brew commands

  brew help [COMMAND]

  man brew

  https://docs.brew.sh

anurag@Anurags-MacBook-Air /opt % 

Friday, October 11, 2024

How to create oracle 19c database using dbca silent mode ?

 create oracle 19c database using dbca silent mode


dbca : DBCA stands for Database Configuration Assistant, a tool used to create and configure Oracle databases


Login as oracle user or user used to install the oracle binary 

command :


dbca -silent -createDatabase \

-templateName General_Purpose.dbc \

-gdbName HRDB \

-sid HRDB   \

-sysPassword Hrdb123# \

-systemPassword Hrdb123# \

-emConfiguration NONE \

-datafileDestination /u02/oradata \

-storageType FS \

-characterSet AL32UTF8 \

-sampleSchema true \

-enableArchive true -archiveLogMode auto \

-recoveryAreaDestination /u02/fast_recovery_area \

-databaseType MULTIPURPOSE \

-useOMF true \

-initParams db_unique_name=HRDB, db_recovery_file_dest_size=10G, db_create_file_dest='/u02/oradata/', db_create_online_log_dest_1='/u02/oradata/', db_create_online_log_dest_2='/u02/fast_recovery_area/', dg_broker_start=false \

-ignorePreReqs



[oracle@test ~]$ dbca -silent -createDatabase \

> -templateName General_Purpose.dbc \

> -gdbName HRDB \

> -sid HRDB   \

> -sysPassword Hrdb123# \

> -systemPassword Hrdb123# \

> -emConfiguration NONE \

> -datafileDestination /u02/oradata \

> -storageType FS \

> -characterSet AL32UTF8 \

> -sampleSchema true \

> -enableArchive true -archiveLogMode auto \

> -recoveryAreaDestination /u02/fast_recovery_area \

> -initParams db_unique_name=HRDB, db_recovery_file_dest_size=10G, db_create_file_dest='/u02/oradata/', db_create_online_log_dest_1='/u02/oradata/', db_create_online_log_dest_2='/u02/fast_recovery_area/', dg_broker_start=false \

> -databaseType MULTIPURPOSE \

> -useOMF true \

> -ignorePreReqs

Prepare for db operation

10% complete

Copying database files

40% complete

Creating and starting Oracle instance

42% complete

46% complete

50% complete

54% complete

58% complete

60% complete

Completing Database Creation

66% complete

69% complete

70% complete

Executing Post Configuration Actions

100% complete

Database creation complete. For details check the logfiles at:

 /u01/app/oracle/cfgtoollogs/dbca/HRDB.

Database Information:

Global Database Name:HRDB

System Identifier(SID):HRDB

Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/HRDB/HRDB.log" for further details.

[oracle@test ~]$

Gather stats in Oracle - most commonly used DBMS_STATS.GATHER_TABLE_STATS parameters

Below is a comprehensive explanation of the most commonly used DBMS_STATS.GATHER_TABLE_STATS parameters and when you should use them. Synta...