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;

Postgres error: message type 0xxx arrived from server while idle

You get the error "message type 0xxx arrived from server while idle while" trying to write to postgres. It's itermittent so it's kind of difficult to catch.

solution: I had multiple threads using the same connection and trying to write to the database simultaneously.
Give each thread it's own connection, it should work.

Start postgres – error : connections on Unix domain socket "/tmp/.s.PGSQL.5432"

Start as postgres user with options :

/usr/bin/pg_ctl -D ./data -l logfile start

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))
)