TECHNOLOGY BLOGS


JOIN OUR COMMUNITY NOW! AND STAY CONNECTED!

reports for RAC

TECHNOLOGY

Oracle – AWR, ASH and ADDM reports for RAC

Following are the scripts that can be executed as sysdba in order to get the AWR, ASH and ADDM reports on Oracle RAC: SQL script for getting AWR Report on RAC database: SQL>@$ORACLE_HOME/rdbms/admin/awrgrpt.sql SQL script for getting AWR Report for  single instance: SQL>@$ORACLE_HOME/rdbms/admin/awrrpt.sql SQL script for getting ASH Report on...

Read More
Openstack learning resources

TECHNOLOGY

Openstack learning resources

Interested in learning more about openstack? following are some useful learning resources on openstack. Thank you, Tyler Britten for sharing this information. DevStack: http://docs.openstack.org/developer/devstack/ Fuel with Virtualbox: https://docs.mirantis.com/openstack/fuel/fuel-6.1/virtualbox.html TryStack http://trystack.org/ Join the Foundation: https://www.openstack.org/join/register/?membership-type=foundation Build your first OpenStack App: https://www.openstack.org/summit/vancouver-2015/summit-videos/presentation/build-and-operate-your-first-openstack-application

Read More
Oracle Database

ORACLE DATABASE

Oracle Database consistent backup using expdp

Use the following procedure to take the consistent backup using expdp (oracle’s datapump export utility) Stop application activity(transactions) against database.  This will ensure you that you don’t loose any transactions . 1. Make sure there are no pending transactions by running the following SQL: SQL> select count(*) from v$transaction;...

Read More
New Website Launched

COMPANY NEWS

New Website Launched

We are excited to launch our new website of Princeton IT Services on June 18, 2015. In this third major release, we have made fundamental changes in all pages and the entire layout. It is a totally redesigned website with interactive function, clear navigation and up-to-date information. You can...

Read More
Princeton IT Services

CLOUD SOLUTIONS

Princeton IT Services is now an Amazon Web Services Partner

Princeton IT Services is now a member of the Amazon Web Services (AWS) Partner Network. In 2006, Amazon Web Services (AWS) began offering IT infrastructure services to businesses in the form of web services — now commonly known as cloud computing. Today, Amazon Web Services provides a highly reliable,...

Read More