Showing posts with label Oracle. Show all posts
Showing posts with label Oracle. Show all posts

Friday 9 April 2010

Oracle Drop database

To drop a database I did the following :

SQL> shutdown abort;
startup mount exclusive restrict;
ORACLE instance shut down.
SQL> ORACLE instance started.

Total System Global Area 630501376 bytes
Fixed Size 2147032 bytes
Variable Size 469765416 bytes
Database Buffers 150994944 bytes
Redo Buffers 7593984 bytes
Database mounted.
SQL> connect as sysdba
Enter password:
Connected.
SQL> drop database;

Tuesday 22 December 2009

Change Oracle default port

Change the port in
listener.ora
tnsnames.ora

eg.,
LISTENERS_OARCLE1=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = oracle1)(PORT = 5599)(IP = x.x.x.x))
)

Word Press Multisite on AWS instance cannot login with default password

  Word Press Multisite on AWS instance cannot login with default password after setting a static IP ? Try this Login to the shell from AWS i...