![]() Exclude Databases/Schemas: A list of databases/schemas to exclude after the main filter is applied. ![]() ![]() Include Databases/Schemas: A list of databases/schemas to include after the main filter is applied.Filter Databases/Schemas: Allows the user to specify the main schema browser filter for databases or schemas, on whether to include or exclude all.Go to the Filter Tab and make changes in the Options. Using Filters Options in Registration (Filter Tab)Įdit the Server Properties, to use FILTER options for a Server in Aqua Data Studio: (DESCRIPTION=(FAILOVER=ON)(ADDRESS_LIST=(LOAD_BALANCE=ON)(ADDRESS=(PROTOCOL=TCP)(HOST=xxxxx) (PORT=1526))(ADDRESS=(PROTOCOL=TCP)(HOST=xxxx)(PORT=1526))) (CONNECT_DATA=(SERVICE_NAME=somesid))) (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=PRIMARY_NODE_HOSTNAME)(PORT=1521)) (ADDRESS=(PROTOCOL=TCP)(HOST=SECONDARY_NODE_HOSTNAME)(PORT=1521))) (CONNECT_DATA=(SERVICE_NAME=DATABASE_SERVICENAME))) (description=(address_list=(address=(protocol=tcp)(port=1610)(host=webHost)) (address=(protocol=tcp)(port=1521)(host=oraHost))) (connect_data=(INSTANCE_NAME=orcl))(source_route=yes)) Oracle Connection Manager TNS Descriptor Examples: TNS - Network Alias uses the Environment Variable TNS_ADMIN is used and if it is not found, the Environment Variable ORACLE_HOME is used to find the tnsnames.ora file.Īqua Data Studio also allows you to connect to Oracle RAC and Oracle Connection Manager by entering into the Descriptor field. jar file(s) from oracle client installation to ADS_HOME/drivers/lib (for more on how to do this, see our Drivers page).Ģ) The environment variable TNS_ADMIN should be configured to the directory containing tnsnames.ora file.īrowse to select a network alias from the tnsnames.ora file. The user should copy the matched, version-specific jdbc drivers. If the server is v11.0.2.3 then the OCI driver must be for v11.0.2.3. Changing password will only work under the following conditions:ġ) The OCI client library version should match the server version exactly. You can change the password of the server connection while you are connected as a Normal user. Using the Keyboard combination "CTRL + SHIFT + P", you may quickly access Server Properties and edit Tab Coloring options. Right-click on the Server - A Popup Menu Appears.Ĭlick on the Item which displays Server Properties.īased on the Server Type, you can edit the Tab Coloring option to identify your environments. To Identify Server Environments, whether it is a Production, Development or Test, use Tab Coloring feature: Server Connections (Connection Monitor Tab).Using Advanced Properties (Advanced Tab).Improve the Schema Tree and Query Analyzer connection performance.Using Filters Options in Registration (Filter Tab).Oracle Connection Manager Examples & Oracle RAC Examples.Connection Type - TNS Connect Descriptor.Make sure you have the correct JDBC driver if you are connecting through OCI libraries. If you have any issues connecting to your Oracle instance, make sure that you can ping your server with ’tnsping’.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |