# Oracle TNS

## **Introduction**

> * Communication protocol that facilitates communication between Oracle databases and applications over networks
> * Solution for managing large, complex databases, typically in the healthcare, finance, and retail industries.
> * It has a built-in encryption mechanism that ensures the security of data transmitted.
> * Runs on TCP Port 1521 by default

***

## **Oracle TNS - Basic Commands**

| Command                                                                                        | Description                                                                                             |
| ---------------------------------------------------------------------------------------------- | ------------------------------------------------------------------------------------------------------- |
| ./odat.py all -s \<FQDN/IP>                                                                    | Perform a variety of scans to gather information about the Oracle database services and its components. |
| sqlplus /@\<FQDN/IP>/                                                                          | Log in to the Oracle database.                                                                          |
| sqlplus username/password\@10.129.204.235/XE as sysdba                                         | Log in to the Oracle database with sysdba privileges                                                    |
| ./odat.py utlfile -s \<FQDN/IP> -d -U -P --sysdba --putFile C:\insert\path file.txt ./file.txt | Upload a file with Oracle RDBMS.                                                                        |
| sudo nmap -p1521 -sV 10.129.204.235 --open --script oracle-sid-brute                           | Nmap SID Bruteforcing                                                                                   |

***

## **Oracle RDBMS Interaction Commands**

| Command                               | Description                                   |
| ------------------------------------- | --------------------------------------------- |
| select table\_name from all\_tables;  | List all available tables in current database |
| select name, password from sys.user$; | Extract password hashes                       |


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://notes.sfoffo.com/protocols-and-services/oracle-tns.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.