Uncategorized, Virtualization

AWS: Installing RDS Instance

Create Instance Amazon Relational Database Service (RDS) makes it easy to set up, operate, and scale a relational database in the cloud. You can click the button below to launch a Database (DB) Instance in minutes with automated backups, turnkey Multi-AZ replication and free monitoring metrics. Amazon RDS gives you access to a familiar MySQL, PostgreSQL, Oracle, or SQL Server database to facilitate compatibility with existing code, applications, and tools. Launch a DB Instance Engine Selection To get started, choose the DB Instance details below and click Select mysql MySQL Community Edition Select postgres PostgreSQL Select <table cellspacing=”0″ cellpadding=”0″ border=”0″><tbody> […]

Read more
DataBase

How to list all Database names in Oracle

List all DB names along with basic details: SQL> select DBID, NAME, OPEN_MODE from v$database;       DBID NAME      OPEN_MODE ———- ——— ———- 2337018765 PRODDB01      READ WRITE SQL>   List all DB names along with all details: SQL> select * from v$database;       DBID NAME      CREATED   RESETLOGS_CHANGE# RESETLOGS ———- ——— ——— —————– ——— PRIOR_RESETLOGS_CHANGE# PRIOR_RES LOG_MODE     CHECKPOINT_CHANGE# ———————– ——— ———— —————— ARCHIVE_CHANGE# CONTROL CONTROLFI CONTROLFILE_SEQUENCE# CONTROLFILE_CHANGE# ————— ——- ——— ——————— ——————- CONTROLFI OPEN_RESETL VERSION_T OPEN_MODE ——— ———– ——— ———- 2337018765 PRODDB01      11-AUG-06                 1 11-AUG-06                       0           NOARCHIVELOG            5362658         5321718 CURRENT 11-AUG-06                 33359             5362658 11-APR-14 NOT ALLOWED 11-AUG-06 READ WRITE SQL> […]

Read more
Web Technologies

Import WordPress: Importing exported XML file that is more than 2 MB in size

Import WordPress Howdy! Upload your WordPress eXtended RSS (WXR) file and we’ll import the posts, pages, comments, custom fields, categories, and tags into this site. Choose a WXR (.xml) file to upload, then click Upload file and import. Choose a file from your computer: (Maximum size: 2 MB)   Import WordPress Sorry, there has been an error. File is empty. Please upload something more substantial. This error could also be caused by uploads being disabled in your php.ini or by post_max_size being defined as smaller than upload_max_filesize in php.ini.   PHP INI would be at: c:/wamp/bin/apache/apache2.4.4/bin/php.ini   In Php.INI: You […]

Read more