SHIFT-WIKI - Sjoerd Hooft's InFormation Technology

This WIKI is my personal documentation blog. Please enjoy it and feel free to reach out through blue sky if you have a question, remark, improvement or observation. See below for the latest additions, or use the search or tags to browse for content.

Oracle Listener Not Listening On Localhost

Summary: How to configure the Oracle Listener to listen on the short hostname.
Date: Around 2013
Refactor: 8 March 2025: Checked links and formatting.

The oracle dba-er told me there was something wrong with the network on a new AIX box. The Oracle listener didn't listen on localhost which caused the oracle enterprise manager installation to fail.

This was shown using the netstat command:

sjoerd@oraclebox:/home/sjoerd>netstat -na | grep 1521
tcp4       0      0  10.10.10.100.1521         *.*                       LISTEN
tcp4       0      0  10.10.10.100.1521         10.10.10.1.1429           ESTABLISHED
tcp4       0      0  10.10.10.100.1521         10.10.10.100.32782        ESTABLISHED
tcp4       0      0  10.10.10.100.32782        10.10.10.100.1521         ESTABLISHED
tcp4       0      0  10.10.10.100.1521         10.10.10.100.32871        ESTABLISHED

And indeed, when trying to do a 'telnet localhost 1521' we got an connection refused error.

→ Read more...

2025/06/01 11:59

oracle

Oracle Dump

Summary: How to create a dump of a Oracle database.
Date: Around 2013
Refactor: 8 March 2025: Checked links and formatting.

Normally when creating backups you should prefer a RMAN backup. However, this is not the way to go when you want to transfer a database across an operating system. So say you have an Oracle database on AIX and you want to transfer it to Windows, you should use another method, simply being a dump. I have gathered here the required commands and variables you need just for the dump. If you need a script that creates this, use RMAN backup as an example and work from there.

→ Read more...

2025/06/01 11:59

oracle