Author Archives: Nuno Santos

EM12C – Metrics, history and graphics of SQL Server Instance

I recently came across the following problem, the metrics were not saving history and graphs of instances of SQL Server were not being populated.

After opening an SR in ORACLE there could figure out the problem and the same was at OMS repository.

Steps performed:

  1. Connect as SYSDBA to the repository and check the parameter value job_queue_processes.
  2. If the value is 0 we have to change for 1000.
  3. Stop cloud control (OMS) with the command emctl stop oms.
  4. Change the parameter in the database – alter system set job_queue_processes = 1000 scope = both;
  5. Restart data base and start OMS

Done it a few minutes past the metrics are already saving historic and graphics of SQL instances are populated.

It was also resolved the pending status of several data bases.

Em12C_SQL

 

I hope it was useful!!!
Cheers

AIX: Nim Server Commands

To list all the mksysb resources

# lsnim -t mksysb

# lsnim -t spot

To list all the machines

# lsnim -t standalone

OR

# lsnim -c machines

To reset the NIM status of system host-10

# nim -o reset -a force=yes host-10

or

# nim -Fo reset host10

To Force Deallocate all the resources from system host-01

# nim -Fo deallocate -a subclass=all host-01

To rebuild the /etc/niminfo file in the master

# nimconfig -r

To rebuild the /etc/niminof file in the NIM client

# niminit -a master= -a name=

To remove a machine from the NIM environment

# nim -o remove

To define a mksysb resource

# nim -o define -t mksysb -a server=master -a location=file>

To enable Base OS install in a client using mksysb resource

# nim -o bos_inst -a source=mksysb -a spot=spot_53ML4 -a accept_licenses=yes

-a mksysb=file>

 

To add additional software to lppsource1

# nim -o update -a packages=all source=/dev/cd0 lppsource1

To update the spot and lppsource to the latest level

# nim_update_all -l -s -d -u -B

Some useful NIM SMIT Fast paths

smit nim_mkmac # Adding new machines

smit nim_bosinst # For doing BOS install operation on a machine

 

Common NIM Error codes

608 – tftp retrieve of client info file failure

Action If a 608 hang is encountered, verify that the ClientName.info file exists in the /tftpboot directory. If it does not exist, retry the NIM operation to create it. If it does exist, verify that tftp access to the /tftpboot directory is not restricted in the /etc/tftpaccess.ctl file. is also possible that the network adapter was not configured properly in the boot environment

611 – Remote mount of NFS file system failure

Action 611 hangs occur when the client machine is unable to mount a resource from a server. Ensure that NFS is running on the resource server. Verify that the resources specified for the operation are exported properly by checking the /etc/exports and /etc/xtab files on the server. Also, confirm that the resources have permissions set correctly for reading.

613 – Failure setting up route tables

Action 613 hangs usually occur because a route is incorrectly defined for a network in the NIM database. Verify that the correct gateways are specified between networks, and all gateways are functional. Use debug-enabled network boot images to determine which routes could not be defined.

Cheers, 🙂

HMC Command to get LPAR configuration

This displays what resources are assgined in the profile for a given LPAR.

# lssyscfg -r prof -m managed_system_name | grep name=LPAR_NAME

Cheers, 🙂

VIO: Virtual Media Library

Steps:

$ mkrep -sp rootvg -size 8G
Virtual Media Repository Created
Repository created within "VMLibrary" logical volume

We’ve now created an empty VML repository which backs onto the /var/vio/VMLibrary filesystem. You can view the VML repository by running the lsrep command.

Check the VML repository to see the new image available for use.

$ lsrep
Size(mb) Free(mb) Parent Pool         Parent Size      Parent Free
   8158     4865 rootvg                   279552           182272

Name                                    File Size Optical         Access
AIX71base.7100-01-00.1of2.iso                 4040 None            ro

Increase repository:

$ chrep -size 5G +5GB

Command Description:

mkrep Creates a virtual media repository
chrep Changes the characteristics of a virtual media repository
rmrep Removes the virtual media repository
lsrep Displays information about the virtual media repository

mkvopt Creates file-backed virtual optical media
lsvopt Displays information about file-backed virtual optical devices
chvopt Changes the characteristics of a virtual optical media
rmvopt Removes file-backed virtual optical media

mkvdev Creates file-backed virtual optical devices
unloadopt Unloads file-backed virtual optical media from a file-backed virtual optical device
loadopt Loads file-backed virtual optical media from a file-backed virtual optical device

Example to mount an ISO:

$ mkvdev -fbo -vadapter vhost1
vtopt0 Available

Now let’s load the image from the VML into vtopt0.

$ loadopt -vtd vtopt0 -disk AIX71base.7100-01-00.1of2.iso
$ lsmap -vadapter vhost1
SVSA            Physloc                                      Client Partition ID
--------------- -------------------------------------------- ------------------
vhost1          U9133.55A.066EB4H-V1-C34                     0x00000000

VTD                   vtopt0
Status                Available
LUN                   0x8200000000000000
Backing device        /var/vio/VMLibrary/AIX71base.7100-01-00.1of2.iso
Physloc
Mirrored              N/A

To unload the image.

$ unloadopt -vtd vtopt0

If you’re prompted for another disk (for example, disc 2 during the AIX install).

$ loadopt -f -vtd vtopt0 -disk AIX7100-01-00.2of2.iso
 Cheers 🙂
Optimization WordPress Plugins & Solutions by W3 EDGE