12/14/2023 0 Comments Aqua data studio increase memory![]() ![]() ![]() Use options to INCLUDE or EXCLUDE all Schemas and Folders. Sometimes you would like to view only specific Schemas.Default Folders are Tables, System Tables, Views, Indexes, Triggers, Procedures, Functions. You can Create, Edit or Delete Object Folders.Using the drop-down at the top of the Filter Tab, quickly change your Schema or Folder View. Exclude Objects: A list of objects to exclude after the main filter is applied.Include Objects: A list of objects to include after the main filter is applied.Filter Objects: Allows the user to specify the main schema browser filter for object types, on whether to include or exclude all.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. ![]() Click the Item which displays Server Properties.Right-click the Server - A Popup Menu Appears.Locate the Server in the Server Browser.(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=(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))) Using Filters Options in Registration (Filter Tab)Įdit the Server Properties, to use FILTER options for a Server in Aqua Data Studio: (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 RAC TNS Descriptor Examples: 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. 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.jar file(s) from oracle client installation to ADS_HOME/drivers/lib (for more on how to do this, see our Drivers page). 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. The OCI client library version should match the server version exactly.Changing password will only work under the following conditions: 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. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |