# Oracle Database: Connection guide

Choose structured fields or a raw connect string. Use the supplied service name or SID. Oracle Thin mode is the default: Oracle Instant Client is not required for ordinary connections. TNS, TCPS, wallets and external authentication have additional requirements.

Source: https://www.nexosqlstudio.com/docs/oracle-connection
Language: en
Type: docs

# Oracle Database: Connection guide

Query, explore and develop with Oracle, PostgreSQL, MySQL, MariaDB, SQLite and Microsoft SQL Server in VS Code. Nexo SQL Studio combines a database client with dedicated Oracle SQL and PL/SQL tooling.

## Before connecting

Use the host, port, database name and credentials supplied by your administrator. Enable the required TLS settings; do not disable certificate validation to work around a connection error.

Choose structured fields or a raw connect string. Use the supplied service name or SID. Oracle Thin mode is the default: Oracle Instant Client is not required for ordinary connections. TNS, TCPS, wallets and external authentication have additional requirements.

## Connect and run SQL

1. Install Nexo SQL Studio and open Connections Explorer.
2. Add a connection, select the database engine and enter a unique name.
3. Enter the engine-specific fields. Test the connection, resolve any inline errors, then save.
4. Open a SQL worksheet from the saved connection and run the example below.
5. Inspect the results. Use a disposable database for write examples and review commit/rollback behavior before changing production data.

```sql
SELECT 'Connected' AS status FROM dual;
```

## Feature availability

Database support does not imply identical features. Connections and SQL worksheets are the starting point; editing, DDL, modeling, transfers, administration and AI operations depend on the engine and workflow. Check the installed version and the relevant guide before relying on an advanced operation.

Free covers core SQL workflows. Pro adds advanced development, delivery and AI/MCP tools. A Pro license does not make an unsupported engine feature available.

Keep the depth your Oracle projects need: service names and SIDs, Easy Connect, TNS, TCPS and wallets, alongside PL/SQL intelligence, debugging, utPLSQL and APEX/ORDS workflows. Advanced features have their own plan and compatibility requirements.

## Troubleshooting

Check the selected engine, host or file path, database name, account permissions and TLS requirements. Keep the connection editor open while correcting failed tests. Include the engine, server version, extension version and a sanitized error when requesting support; never include passwords or wallet secrets.

## Next steps

- [Feature availability](https://www.nexosqlstudio.com/databases)
- [Connections, SQL worksheets and query results](https://www.nexosqlstudio.com/docs/worksheet)
- [Advanced Oracle development](https://www.nexosqlstudio.com/databases/oracle)