Converting ORACLE_SID to service name and browsing active Oracle database service instances
- From: "Austin Ziegler" <halostatue@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 11 May 2006 13:09:29 -0400
SGkuCgpJIGFtIGN1cnJlbnRseSBmYWNpbmcgdHdvIHByb2JsZW1zIHRoYXQgSSBuZWVkIHRvIHNv
bHZlIGFuZCBoYXZlIG5vdAphcyB5ZXQgYmVlbiBhYmxlIHRvIGZpbmQgYSBzYXRpc2ZhY3Rvcnkg
YW5zd2VyIHRvIHRoZW0uIEZvciB0aGUgZmlyc3QKaXNzdWUsIEkgY2FuIGRvIHNvbWUgaG9tZS1n
cm93biBwYXJzaW5nIGlmIEkgYWJzb2x1dGVseSBtdXN0LCBidXQgaXQKd291bGQgc2VlbSB0byBt
ZSB0aGF0IHRoZXJlIHNob3VsZCBiZSBhIHdheSB0byBkbyB0aGlzLiBUaGUgbGFzdCBpcwptdWNo
IGhhcmRlci4KCkEgYnJpZWYgYmFja2dyb3VuZC4gSSBhbSB3b3JraW5nIG9uIHNvZnR3YXJlIHRo
YXQgYXV0b21hdGVzIHRoZQpvcGVyYXRpbmctc3lzdGVtIGJhY2t1cCBtZWNoYW5pc20gZm9yIE9y
YWNsZSAob25jZSB0aGUgZGF0YWJhc2UgaXMgaW4KQVJDSElWRUxPRyBtb2RlKS4gVGhlIGxhc3Qg
dmVyc2lvbiB3ZSByZWxlYXNlZCB1c2VkIG90bHY0LmggdGFsa2luZwp0aHJvdWdoIHRoZSBPcmFj
bGUgOGkgb2NpOCBsaWJyYXJpZXMuIE91ciBhZ2VudCwgdXNlZCBmb3IgY29uZmlndXJpbmcKYmFj
a3VwIHRhc2tzLCBtdXN0IGJlIGFibGUgdG8gY29ubmVjdCB0byBhbnkgT3JhY2xlIGRhdGFiYXNl
IGluc3RhbmNlCm9uIHRoZSBjdXJyZW50IHN5c3RlbS4gJE9SQUNMRV9IT01FIHdhcyBjYXVzaW5n
IHNpZ25pZmljYW50IHByb2JsZW1zCmFuZCB3ZSBoYWQgdG8gZG8gYSBoYWNrIHRvIGJlIGFibGUg
dG8gY29ubmVjdCB0byBPcmFjbGUgOGkgb3IgOWkKZGF0YWJhc2VzLiBJdCB3b3JrZWQgcmVhc29u
YWJseSB3ZWxsIC4uLiBvbiBTb2xhcmlzLgoKV2UgcmVjZW50bHkgcG9ydGVkIGl0IHRvIHdvcmsg
b24gV2luZG93cyBhcyB3ZWxsIGFzIFNvbGFyaXMsIGFuZCBpbgp0aGUgcHJvY2VzcyB3ZSBjaGFu
Z2VkIGZyb20gcGxhaW4gb2NpOCB0byBPQ0kgb3ZlciB0aGUgT3JhY2xlIDEwZwpJbnN0YW50IENs
aWVudCBzbyB0aGF0IHdlIGNvdWxkIGF2b2lkIHRoZSB3aG9sZSAkT1JBQ0xFX0hPTUUgbWVzcywg
YW5kCml0IGhhcyB3b3JrZWQgYmVhdXRpZnVsbHkgZXhjZXB0IGZvciBhIGZldyBtaW5vciBwcm9i
bGVtcy4KCjEuIEZvciB0aGUgZXhpc3RpbmcgU29sYXJpcyBpbnN0YWxsYXRpb25zLCBpdCB3b3Vs
ZCBiZSB2ZXJ5IHVzZWZ1bCBpZgpJIGNvdWxkICplYXNpbHkqIGNvbnZlcnQgdGhlIE9SQUNMRV9T
SUQgdGhhdCBJIGhhdmUgZm9yIG9sZC1zdHlsZQpjb25uZWN0aW9ucyBpbnRvIGEgc2VydmljZSBu
YW1lIGZvciB1c2Ugd2l0aCBPcmFjbGUgSW5zdGFudCBDbGllbnQuClRoYXQgaXMsIGlmIG15IFNJ
RCBpcyBTT0w4SURFViBhbmQgaXRzIHNlcnZpY2UgbmFtZSBpcwpzb2w4aWRldi5kZXZlbG9wbWVu
dC5leGFtcGxlLmNvbSwgaXMgdGhlcmUgYW55IHdheSB0aGF0IEkgY2FuIGRvIHRoaXMKd2l0aG91
dCBwYXJzaW5nIHRocm91Z2ggdGhlIHRuc25hbWVzLm9yYSBmb3IgdGhlIGFjdGl2ZSBsaXN0ZW5l
cj8gSQpjYW4gYWx3YXlzIGRvIHRoZSBsYXR0ZXIsIGJ1dCB0aGF0J3MgdWdseS4KCjIuIE91ciB1
c2VyIGV4cGVyaWVuY2UgdGVhbSBpcyB2ZXJ5IHVuaGFwcHkgdGhhdCB3ZSBzZWVtIHRvIGJlIHVu
YWJsZQp0byBicm93c2UgYXZhaWxhYmxlIE9yYWNsZSBkYXRhYmFzZSBpbnN0YW5jZXMgb24gYSBt
YWNoaW5lLCByZXF1aXJpbmcKdGhlIERCQSBlbnRlciB0aGUgZnVsbCBzZXJ2aWNlIG5hbWUgb2Yg
dGhlIGRhdGFiYXNlIGJ5IGhhbmQuIERvZXMKYW55b25lIGtub3cgb2YgYSBwcm9ncmFtbWF0aWMg
d2F5IHRvIGRvIHF1ZXJ5IHRoaXMgZnJvbSB0aGUgbG9jYWxob3N0Cmxpc3RlbmVyPyBBZ2Fpbiwg
SSBhbSBwcmV0dHkgc3VyZSB0aGF0IEkgY291bGQgZXhlY3V0ZSAibHNucmN0bApzdGF0dXMiIGFu
ZCBwYXJzZSB0aGUgb3V0cHV0LCBidXQgdGhhdCBzZWVtcyBwcmV0dHkgdWdseSBhbmQgZnJhZ2ls
ZS4KCkkgZm91bmQgcHJvZ3JhbXMgdGhhdCBxdWVyaWVkIHRoZSBUTlMgbGlzdGVuZXIsIGJ1dCB0
aGlzIG9ubHkgc2VlbXMgdG8Kd29yayBvbiBPcmFjbGUgOWkgYW5kIGxvd2VyIGxpc3RlbmVyczsg
aGFzIGFueW9uZSBmb3VuZCBhIHdheSB0byBkbwp0aGlzIHRoYXQgaXMgc3VwcG9ydGVkIGJ5IE9y
YWNsZSBkaXJlY3RseT8KCi1hdXN0aW4KLS0gCkF1c3RpbiBaaWVnbGVyICogaGFsb3N0YXR1ZUBn
bWFpbC5jb20KICAgICAgICAgICAgICAgKiBBbHRlcm5hdGU6IGF1c3RpbkBoYWxvc3RhdHVlLmNh
Cg==
--
//www.freelists.org/webpage/oracle-l
Other related posts:
