|
|
|
|
|
|
|
|
| Re: Query to find out list of oracle databases... [message #53938 is a reply to message #53932] |
Fri, 18 October 2002 10:16  |
Trifon Anguelov
Messages: 514
Registered: June 2002
|
Senior Member |
|
|
As someone already suggested, tnsnames.ora file will have TNS aliases for the available databases, to which user can connect.
You can go one step further and do tnsping in each TNS service name, to verify user can make a connection to this service name:
Microsoft Windows 2000 [[Version 5.00.2195]]
(C) Copyright 1985-2000 Microsoft Corp.
C:WINNTsystem32>tnsping db1-db33
TNS Ping Utility for 32-bit Windows: Version 8.1.7.0.0 - Production on 18-OCT-2002 11:01:53
(c) Copyright 1997 Oracle Corporation. All rights reserved.
Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=db1.skiffy.com)(PORT=1521))
OK (220 msec)
C:WINNTsystem32>
Hope you know how to call OS commands from VB :-)))
Hope that helps,
clio_usa
OCP - DBA
Visit our Web site
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
