Retrieve the Port to which TOAD for Oracle is connecting to a particular Database
I am using toad for Oracle, neither toad or oracle are my regular tools but inherit a system to give maintenance. The point is this, Toad connects to all the DB's that I need, but I need to get the information of each connection for documentation purpose. I saw the tnsnames.ora but not all the connections are there. I need, giving a connection made, to know to which port is connected. I already have the Host name and service, but I am unable to pull the database port number from sys_context for example.
I need this, because I cannot rely on a single machine properly configured. So, does anyone knows how to see the configuration of the current connection in Toad for Oracle??
@JustinCave I just check twice again, and it's weird. The connection is being made as a TNS name (without specifying the port) but I just checked at the TNSNames editor and the database that I'm referring to is not there.
There are any other, network resource from it is taking the TNSName configuration besides the client's TNSNames.ora??
Go to a command line and type
tnsping <<TNS alias from Toad>>
Assuming that resolves correctly, the output will contain the sqlnet.ora file that was used. The sqlnet.ora file, in turn, will specify which TNS resolution method(s) are being used and might contain a pointer to some other tnsnames.ora file. I don't know how sophisticated Toad is at figuring out all the tnsnames.ora files that might be involved but I'd expect it is unaware of all the options in configuring TNS name resolution. It may also be that your client is configured to use an Oracle Names server or an LDAP server to resolve aliases instead of or in addition to one or more tnsnames.ora files.
- Table Naming: Underscore vs Camelcase? namespaces? Singular vs Plural?
- Oracle to PostgreSQL query converter Possible?
- reasoning that creating a primary key satisfies the first normal form
- API returns blob variable as null
- List of standard lengths for database fields
- TypeError: client.query is not a function
- Cannot open database ''. It may not be a database that your application recognizes, or the file may be corrupt
- Does SQLite support character range with [ ]?
- How to get english language word database?
- Spring Batch Framework - Auto create Batch Table
- Subqueries cannot be used in the expression SELECT VBA in MS Access
- Using SQL `IN` operator with DatabaseSync in Node (sqlite)
- Cannot start MongoDB: System error 1067 in Windows
- Is there a way that i store timestamp with time zone in Postgres and not converting it to UTC
- How can I filter a data set according to earliest time point for each participant?
- What is the advantage of salting a password hash?
- Emacs modes to deal with .prisma files
- Oracle Partition by ID and subpartition by DATE with interval
- How does MongoDB cursor behave when the collection is being changed?
- AWS: can't connect to RDS database from my machine
- How to restrict the maximum duration of Postgres transactions?
- What are the disadvantages to Indexes in database tables?
- PostgreSQL: Export database to .sql file
- How do databases maintain results if another query edits those results
- postgresql: Invalid data directory | Can't open PID file /var/run/postgresql/10-main.pid (yet?) after start: No such file or directory
- Many to Many Self referencing relationship
- Insert statement asked me to insert for autoincrement column
- Is a sort passed through in a sub-select
- How to drop multiple databases in SQL Server
- How to get the content of a cell on a DBGrid in Delphi by using the OnCellClick event