Tuesday, 27 August 2019

What is a Cloud Architect?


Cloud computing architecture refers to the components and subcomponents required for cloud computing. These components typically consist of a front end platform, back end platforms, a cloud-based delivery, and a network. Combined, these components make up cloud computing architecture. Cloud solutions design is based on architectural procedures and methods that have been developed over the last 20 or so years.
A Cloud Architect is responsible for converting the technical requirements of a project into the architecture and design that will guide the final product. Often, Cloud Architects are also responsible for bridging the gaps between complex business problems and solutions in the cloud. Other members of a technology team, including DevOps engineers and developers, work with the Cloud Architect to ensure that the right technology or technologies are being built.

Friday, 23 August 2019

devops

devops

AWS DEVOPS DEVELPER


asm lib configuration on mapper design



ORACLEASM_SCANORDER="mpath dm" (OR ORACLEASM_SCANORDER="dm")

I found this on various documents on oracle site , still we will crosscheck with oracle once .



Also the below document

(How to Force ASM to Scan the Multipathed Device First using ASMLIB/oracleasm on RHEL 5/OL 5 and RHEL 6/OL 6 (Doc ID 1679409.1)


ASMLib/oracleasm can only be implemented on Linux OS.  When using multipathing, you want to FORCE oracleasm to scan the multipathed devices first

Below is the process mentioned

On all nodes:
1)  Shutdown all (DB and ASM):
You should stop all before restart ASMLib (eg: DB, ASM and HAS (crsctl stop crs for RAC) if you are in 11.2 - crsctl stop has) 

Then, on each node, one at a time, do the following steps that are dependent on the type of multipathing software:
2)  For backup, make a copy of your current /etc/sysconfig/oracleasm and /etc/sysconfig/oracleasm-_dev_oracleasm files
a) If using DM-Multipathing or Linux OS Native Multipathing:
1. Then, you want to change the following parameters in the  /etc/sysconfig/oracleasm-_dev_oracleasm file to which the /etc/sysconfig/oracleasm file is really linked to:

For example:

lrwxrwxrwx 1 root root 24 Jun 13 09:58 /etc/sysconfig/oracleasm -> oracleasm-_dev_oracleasm

# ORACLEASM_SCANORDER: Matching patterns to order disk scanning
ORACLEASM_SCANORDER="mpath dm" (OR ORACLEASM_SCANORDER="dm")

# ORACLEASM_SCANEXCLUDE: Matching patterns to exclude disks from scan
ORACLEASM_SCANEXCLUDE="sd"



 b) If using  EMC PowerPath Multipathing:
2. Then, you want to change the following parameters in the  /etc/sysconfig/oracleasm-_dev_oracleasm file to which the /etc/sysconfig/oracleasm file is really linked to:

For example:

lrwxrwxrwx 1 root root 24 Jun 13 09:58 /etc/sysconfig/oracleasm -> oracleasm-_dev_oracleasm

# ORACLEASM_SCANORDER: Matching patterns to order disk scanning
ORACLEASM_SCANORDER="emcpower"

# ORACLEASM_SCANEXCLUDE: Matching patterns to exclude disks from scan
ORACLEASM_SCANEXCLUDE="sd"

orachk


Request has been created to run the ./orachk and give us the output.

[oracle@pxdadm]01 orachk]$ . oraenv
ORACLE_SID = [+ASM1] ? +ASM1

[oracle@pxbadm01 ~]$ cd /home/oracle/orachk
[oracle@pxbadm01 orachk]$ pwd
/home/oracle/orachk
[oracle@pxbadm01 orachk]$ ls -lrt
total 324200
-rw-r--r--  1 oracle oinstall 331643669 Mar 15 08:37 orachk.zip
drwxr-xr-x 10 oracle oinstall      4096 Mar 15 09:42 orachk



[oracle@pxdadm01 orachk]$ ./orachk

Run the above and give us output to give the result for oracle support.

If there any issue with run please change the orachk owner with root user.

Thursday, 22 August 2019

TFA

https://oracle-base.com/articles/misc/trace-file-analyzer-tfa

Oracle Trace File Analyzer (TFA)

Oracle Trace File Analyzer (TFA) provides a number of diagnostic tools in a single bundle, making it easy to gather diagnostic information about the Oracle database and clusterware, which in turn helps with problem resolution when dealing with Oracle Support.


/oraclebase/app/gridbase/tfa/repository/suptools/mprlexd002/oswbb/oracle/archive

Download Oracle Trace File Analyzer (TFA)

Trace File Analyzer (TFA) has been shipped with the Oracle database since 11.2.0.4, so you may already have it, but Oracle recommend downloading the latest version on a regular basis to get the best results. The following location gives an overview of the TFA product, as well as download links and basic instructions.
This article assumes you've downloaded the latest version of TFA and it is placed in the "/u01/software" directory.

Install Oracle Trace File Analyzer (TFA)

Trace File Analyzer (TFA) can be installed as the "root" user on the server, which provides the most functionality and allows it to run in a proactive manner as a daemon, or locally as the Oracle software owner. In this example we will perform a local installation, making it a reactive tool.
Unzip the software, create a destination location and install the software using the "-local" flag.
cd /u01/software
unzip TFA-LINUX_v18.2.1.zip

mkdir -p $ORACLE_HOME/tfa
./installTFA-LINUX -local -tfabase $ORACLE_HOME/tfa

Run a Oracle Trace File Analyzer (TFA) Collection

With the installation complete we can use the tfactl command to perform a number of collections, including TFA Service Request Data Collections (SRDC). There are a large number of SRDC collection types, with each gathering different information, as described here.
Here are a few examples.
cd $ORACLE_HOME/tfa/bin/

# Gather diagnostic information about TFA itself.
./tfactl diagnosetfa -local

# Gather information about errors. You are prompted to select a specific incident.
./tfactl diagcollect -srdc ORA-00600
./tfactl diagcollect -srdc ORA-07445

# Collect data for all components for a specific time period.
./tfactl diagcollect -from "2018-06-16 13:00:00" -to "2018-06-16 13:00:00"

# Collect data for all components for the last 12 hours.
./tfactl diagcollect
Each TFA collection produces a single zip file that can be uploaded to My Oracle Support (MOS), as described below.

Upload to My Oracle Support (MOS)

You can manually upload a zip file produced by TFA by attaching it to you SR through the MOS website in the normal way. An alternative is to get TFA to upload it and attach it to your Service Request (SR). To do this you must provide your MOS credentials. This can be done as part of the command line, or they can be stored in a secure wallet by running the following command as the "root" user.
# ./tfactl setupmos
Enter User Id: me@example.com
Enter Password:          
Wallet does not exist ... creating
Wallet created successfully
USER details added/updated in the wallet
PASSWORD details added/updated in the wallet
SUCCESS - CERTIMPORT - Successfully imported certificate
#
The result of a TFA collection can be uploaded directly to MOS by including the "-sr" option in the command to specify the target SR number.
# MOS credentials supplied by wallet.
./tfactl diagcollect -srdc ORA-00600 -sr 1-12345678901

# MOS credentials supplied on command line. You are prompted for the password.
./tfactl diagcollect -srdc ORA-00600 -sr 1-12345678901 -user me@example.com
You can upload one or more files (both TFA generated and other files) as a separate action using the following commands.

# MOS credentials supplied by wallet.
./tfactl upload -sr 1-12345678901 -wallet file1.zip file2.zip file3.zip

# MOS credentials supplied on command line. You are prompted for the password.
./tfactl upload -sr 1-12345678901 -user me@example.com file1.zip file2.zip file3.zip

Monday, 19 August 2019

changing scan and VIP in Rac


I have provided the below steps ,scan and vip address change, IP address for scan should be configured in DNS is round robin fashion and should be added in /etc/hosts.
VIP address should be added in /etc/hosts , needs to be assigned in DNS entry.



Changing Virtual IP / Virtual Host Name

-- CHANGING NODE VIP FROM 192.168.2.220 TO 192.168.2.330 ON ravs1
-- SINCE NODE VIP IS PART OF NODE APPS ONE NEEDS TO MODIFY THE IP ADDRESS ON OS LEVEL AND THEN USE SRVCTL TO MODIFY NODEAPPS

[oracle@ravs1 automation]$ srvctl  config vip -node ravs1
VIP exists: network number 1, hosting node ravs1
VIP Name: ravs1-vip.localdomain
VIP IPv4 Address: 192.168.2.220
VIP IPv6 Address:
VIP is enabled.
VIP is individually enabled on nodes:
VIP is individually disabled on nodes:

[oracle@ravs1 automation]$ srvctl  stop vip -node ravs1
PRCR-1065 : Failed to stop resource ora.ravs1.vip
CRS-2529: Unable to act on 'ora.ravs1.vip' because that would require stopping or relocating 'ora.LISTENER.lsnr', but the force option was not specified

[oracle@ravs1 automation]$ srvctl  stop vip -node ravs1 -force
[oracle@ravs1 automation]$ srvctl  status  vip -node ravs1
VIP ravs1-vip.localdomain is enabled
VIP ravs1-vip.localdomain is not running

-- NOW MODIFY THE ADDRESS OF NODE VIP ON OS LEVEL USING EITHER /etc/hosts OR DNS.
-- Once done, use SRVCTL to modify OCR resource.
-- Here I am not changing the name, but only IP

[oracle@ravs1 automation]$ srvctl modify nodeapps -node ravs1 -address ravs1-vip.localdomain/255.255.255.0/eth1
[oracle@ravs1 automation]$ srvctl config   vip -node ravs1
VIP exists: network number 1, hosting node ravs1
VIP Name: ravs1-vip.localdomain
VIP IPv4 Address: 192.168.2.330
VIP IPv6 Address:
VIP is enabled.
VIP is individually enabled on nodes:
VIP is individually disabled on nodes:

[root@ravs2 ~]# srvctl  config nodeapps
Network 1 exists
Subnet IPv4: 192.168.2.0/255.255.255.0/eth1, static
Subnet IPv6:
Ping Targets:
Network is enabled
Network is individually enabled on nodes:
Network is individually disabled on nodes:
VIP exists: network number 1, hosting node ravs1
VIP Name: ravs1-vip.localdomain
VIP IPv4 Address: 192.168.2.330
VIP IPv6 Address:
VIP is enabled.
VIP is individually enabled on nodes:
VIP is individually disabled on nodes:
VIP exists: network number 1, hosting node ravs2
VIP Name: ravs2-vip.localdomain
VIP IPv4 Address: 192.168.2.104
VIP IPv6 Address:
VIP is enabled.
VIP is individually enabled on nodes:
VIP is individually disabled on nodes:
ONS exists: Local port 6100, remote port 6200, EM port 2016, Uses SSL false
ONS is enabled
ONS is individually enabled on nodes:
ONS is individually disabled on nodes:

[oracle@ravs1 automation]$ srvctl  start vip -node ravs1
[root@ravs2 ~]# srvctl  status  nodeapps
VIP ravs1-vip.localdomain is enabled
VIP ravs1-vip.localdomain is running on node: ravs1
VIP ravs2-vip.localdomain is enabled
VIP ravs2-vip.localdomain is running on node: ravs2
Network is enabled
Network is running on node: ravs1
Network is running on node: ravs2
ONS is enabled
ONS daemon is running on node: ravs1
ONS daemon is running on node: ravs2

-- ON NODE2

[oracle@ravs2 ~]$ srvctl  stop vip -node ravs2 -force
[oracle@ravs2 ~]$ srvctl  status  vip -node ravs2
VIP ravs2-vip.localdomain is enabled
VIP ravs2-vip.localdomain is not running

[oracle@ravs2 ~]$ srvctl modify nodeapps -node ravs2 -address ravs2-vip.localdomain/255.255.255.0/eth1

[oracle@ravs2 ~]$ srvctl  config vip  -n ravs2
VIP exists: network number 1, hosting node ravs2
VIP Name: ravs2-vip.localdomain
VIP IPv4 Address: 192.168.2.204
VIP IPv6 Address:
VIP is enabled.
VIP is individually enabled on nodes:
VIP is individually disabled on nodes:

[oracle@ravs2 ~]$ srvctl  start vip -node ravs2

[oracle@ravs2]$ srvctl status  nodeapps
VIP ravs1-vip.localdomain is enabled
VIP ravs1-vip.localdomain is running on node: ravs1
VIP ravs2-vip.localdomain is enabled
VIP ravs2-vip.localdomain is running on node: ravs2
Network is enabled
Network is running on node: ravs1
Network is running on node: ravs2
ONS is enabled
ONS daemon is running on node: ravs1
ONS daemon is running on node: ravs2

[oracle@ravs1 automation]$ crs_stat -t  | grep vip

ora.ravs1.vip ora....t1.type ONLINE    ONLINE    ravs1     
ora.ravs2.vip ora....t1.type ONLINE    ONLINE    ravs2     
ora.scan1.vip  ora....ip.type ONLINE    ONLINE    ravs1


changing of scanip
______________________
**************************************************************************************

So to change to SCAN IP / Name one has to first populate the changes on DNS to take it into effect. Once the changes are in effect, one can modify the SCAN resource in OCR as follows. Remember SCAN acts as cluster entry point and load balancing process , the restart to SCAN will require a brief outage


[oracle@ravs2 ~]$ srvctl  status scan_listener
SCAN Listener LISTENER_SCAN1 is enabled
SCAN listener LISTENER_SCAN1 is running on node ravs1
[oracle@ravs2 ~]$ srvctl  status scan
SCAN VIP scan1 is enabled
SCAN VIP scan1 is running on node ravs1

[oracle@ravs2 ~]$ srvctl config  scan
SCAN name: ravs-scan.localdomain, Network: 1
Subnet IPv4: 192.168.2.0/255.255.255.0/eth1, static
Subnet IPv6:
SCAN 0 IPv4 VIP: 192.168.2.110
SCAN VIP is enabled.
SCAN VIP is individually enabled on nodes:
SCAN VIP is individually disabled on nodes:

[oracle@ravs2 ~]$ srvctl stop scan_listener
[oracle@ravs2 ~]$ srvctl stop scan
[oracle@ravs2 ~]$ srvctl  status scan_listener
SCAN Listener LISTENER_SCAN1 is enabled
SCAN listener LISTENER_SCAN1 is not running
[oracle@ravs2 ~]$ srvctl  status scan
SCAN VIP scan1 is enabled
SCAN VIP scan1 is not running

-- MODIFY THE SCAN IP AT OS LEVEL

[root@ravs2 ~]$ srvctl  modify scan -scanname ravs-scan.localdomain

[oracle@ravs2 ~]$ srvctl  config scan
SCAN name: ravs-scan.localdomain, Network: 1
Subnet IPv4: 192.168.2.0/255.255.255.0/eth1, static
Subnet IPv6:
SCAN 0 IPv4 VIP: 192.168.2.120
SCAN VIP is enabled.

[oracle@ravs2 ~]$ srvctl start scan_listener
[oracle@ravs2 ~]$ srvctl start scan

Featured post

Restircted session due to sync filed with ora-65177

Application is unable to connect the database due to restricted session. sql> show pdbs; SQL> show con_name CON_NAME -----------------...