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.

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)
• Install Oracle Trace File Analyzer (TFA)
• Run a Oracle Trace File Analyzer (TFA) Collection
• Upload to My Oracle Support (MOS)

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.

• Oracle Trace File Analyzer (TFA)

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

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

oracle clinet installation and troubleshooting on 12c

client installation
_______________






Troubleshooting.

how to connect from client to oracle db/

1) go to oracle home client and add tns names .ora file will valid tns entries.

2) go to computer, properties add the values as below.

advance setting

environment varible.

under user variable add line as oracle_home= <clinet oracle_home path>

under system variable add %ORACLE_HOME%\bin;


3) sqlplus /as sysdba

protocal error


sqlplus  om/om1@ofd

connected.