# Oracle

Integrate, catalog, and govern Oracle assets in Atlan.

## Required permissions

- [Preflight checks for Oracle](https://docs.atlan.com/llms/connectors/oracle/preflight-checks-for-oracle/llms.txt): Before running the Oracle crawler, you can run preflight checks to perform the necessary technical validations.

## Setup options

- [Set up Oracle](https://docs.atlan.com/llms/connectors/oracle/set-up-oracle/llms.txt): Configure Oracle user and permissions to enable Atlan to extract metadata from your Oracle database.

## Crawl and mine

- [Crawl Oracle](https://docs.atlan.com/llms/connectors/oracle/crawl-oracle/llms.txt): Crawl metadata from Oracle Database to catalog schemas, tables, views, and columns. Extract lineage and asset information after configuring user permissions and database connectivity.
- [Generate lineage](https://docs.atlan.com/llms/connectors/oracle/generate-lineage-with-oracle-miner/llms.txt): Create an ingestion workflow in Atlan to extract Oracle query history and generate lineage for existing Oracle assets.

## Reference

- [How Atlan connects to Oracle](https://docs.atlan.com/llms/connectors/oracle/how-atlan-connects-to-oracle/llms.txt): Understand how Atlan securely connects to your Oracle database to extract metadata.
- [What does Atlan crawl from Oracle?](https://docs.atlan.com/llms/connectors/oracle/what-does-atlan-crawl-from-oracle/llms.txt): During an Oracle crawl, Atlan extracts metadata for Databases, Schemas, Tables, Views, and Procedures. Reference tables map each Oracle property to its Atlan asset.
- [Oracle assets package](https://docs.atlan.com/llms/connectors/oracle/package-reference/llms.txt): Programmatically crawl and manage Oracle assets in Atlan using the Python SDK (pyatlan). Reference for the Oracle assets package.
- [Oracle assets app](https://docs.atlan.com/llms/connectors/oracle/oracle-sdk-references-app-reference/llms.txt): Learn how to crawl Oracle assets and publish them to Atlan for discovery.
- [Oracle miner app](https://docs.atlan.com/llms/connectors/oracle/oracle-sdk-references-app-miner-reference/llms.txt): Learn how to mine query history from Oracle to generate lineage and usage metrics.

## Troubleshooting

- [Database asset name doesn't match service name](https://docs.atlan.com/llms/connectors/oracle/troubleshooting-oracle-database-name-mismatch/llms.txt): Understand why the Oracle database asset name in Atlan may differ from the service name you used to connect, and how to diagnose the root cause.