ORACLE好用script

看照片，感覺是怪咖一個。
不過，他寫了不少好用的oracle script哦！


My name is Vitaliy Mogilevskiy -- I started working with ORACLE Products in 1996 (Oracle v7, 7.3.4 was pretty good). What you will find here is what works for me day in day out - 24×7x365 - simple ORACLE DBA Tools written using components that are available on every Unix platform with an ORACLE database — sqlplus and KSH.

DBAToolZ

Lightweight Oracle DBA Tools

Id.	Category	Cnt.
1	APPS General	2
2	APPS Installation	3
3	APPS Concurrent Programs	6
4	APPS Concurrent Managers	9
5	APPS Administration	9
6	Data Files	13
7	Tablespace	26
8	Utility	19
9	Index	8
10	Redo Log	8
11	Rollback	5
12	Maintenance	16
13	Reverse Engineering	8
14	SGA Maintenance	16
15	Table	20
16	User Management	28
17	Statistics	13
18	Storage Management	9
19	Database Init Parameters	2
21	Locks	5
22	Segment Management	19
23	Backup Management	2
24	Parallel Query	1
25	SQL Tracing Tuning	20
26	Partitioning	3
27	Favorite Scripts	34

安裝telnet小小心得

我在ubuntu9.04中安裝telnet服務！
較關鍵的地方，我用紅字標記起來。

其實在ubuntu中安裝軟體不難，APT的設計真的很不錯。
目前的UNIX演化，大家都不用telnet了，因為它的安全性很可議。
遠端登入的功能被SSH取而代之～
不過，透過一些安全性的設計，像是設限可登入IP，改變port，運用超級服務...
telnet有時還是很好用的～
安裝過程中，我注意到，它居然是寫到 inetd.conf，而不是xinetd.conf？
真的有點蹊蹺？原來就Debian系而言，inetd還依然是超級服務的原型，可不是說換就換。
還是需要動動手腳，才能移到xinetd上運作。

過程中的說明，指出若是要改成用xinetd，要用itox指令，進行移轉作業。

root@ubuntu94:/etc/xinetd.d# apt-get install telnetd
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following NEW packages will be installed:
telnetd
0 upgraded, 1 newly installed, 0 to remove and 0 not upgraded.
Need to get 42.7kB of archives.
After this operation, 156kB of additional disk space will be used.
Get:1 http://tw.archive.ubuntu.com jaunty/universe telnetd 0.17-36 [42.7kB]
Fetched 42.7kB in 5s (8294B/s)
Selecting previously deselected package telnetd.
(Reading database ... 52983 files and directories currently installed.)
Unpacking telnetd (from .../telnetd_0.17-36_i386.deb) ...
Processing triggers for man-db ...
Setting up telnetd (0.17-36) ...
Adding user telnetd to group utmp
--------- IMPORTANT INFORMATION FOR XINETD USERS ----------
The following line will be added to your /etc/inetd.conf file:

telnet stream tcp nowait telnetd /usr/sbin/tcpd /usr/sbin/in.telnetd

If you are indeed using xinetd, you will have to convert the
above into /etc/xinetd.conf format, and add it manually. See
/usr/share/doc/xinetd/README.Debian for more information.
Suggested entry (automatically converted using itox):

service telnet
{
socket_type = stream
protocol = tcp
wait = no
user = telnetd
You must use option -daemon_dir if you use tcpd
-----------------------------------------------------------


root@ubuntu94:/etc/xinetd.d#





可是我找到建議參考的文件README.Debian，卻看到同目錄下的另一個文件 README.update-inetd。
文件裡頭建議可以使用 xconv.pl 來轉換，而且似乎更友善，更強大！
看副檔名是pl，可以猜出是perl指令稿！
用法也簡單：
# xconv.pl < /etc/inetd.conf > /etc/xinetd.conf

無意間獲得的小小心得，筆記起來囉。