Begin by reviewing OpenWeather's API documentation to understand how to access the data you need. Identify the specific endpoints and the parameters required to fetch the weather data, such as city names or geographic coordinates. Make a note of your API key, which will be necessary for authentication.

Develop a Python script that uses the `requests` library to make HTTP GET requests to OpenWeather's API. Parse the JSON response to extract the weather information you need. Here's a simple example:
```python
import requests

def fetch_weather_data(api_key, city):
url = f"http://api.openweathermap.org/data/2.5/weather?q={city}&appid={api_key}"
response = requests.get(url)
weather_data = response.json()
return weather_data
```

Ensure you have access to your Oracle database. This includes knowing the database host, port, service name, user credentials, and having the Oracle Client or Oracle Instant Client installed on your machine. Verify connectivity by using the `sqlplus` command-line tool or any SQL client.

Design and create a table in your Oracle database that matches the structure of the data you are retrieving from OpenWeather. Use SQL commands to define the table schema with appropriate data types. For example:
```sql
CREATE TABLE weather_data (
id NUMBER GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY,
city_name VARCHAR2(50),
temperature NUMBER,
weather_description VARCHAR2(100),
timestamp DATE DEFAULT SYSDATE
);
```

Install the `cx_Oracle` library, which allows Python scripts to interface with Oracle databases. This can be done using pip:
```bash
pip install cx_Oracle
```

Extend your Python script to connect to the Oracle database and insert the fetched weather data. Use the `cx_Oracle` module to establish a connection and execute an INSERT statement:
```python
import cx_Oracle

def insert_weather_data(connection, data):
cursor = connection.cursor()
insert_query = """
INSERT INTO weather_data (city_name, temperature, weather_description)
VALUES (:city, :temp, :desc)
"""
cursor.execute(insert_query, city=data['name'], temp=data['main']['temp'], desc=data['weather'][0]['description'])
connection.commit()

def main():
api_key = 'your_openweather_api_key'
city = 'London'
weather_data = fetch_weather_data(api_key, city)

dsn_tns = cx_Oracle.makedsn('hostname', port, service_name='service_name')
connection = cx_Oracle.connect(user='username', password='password', dsn=dsn_tns)

insert_weather_data(connection, weather_data)
connection.close()

if __name__ == "__main__":
main()
```

Use a scheduling tool like cron (on Unix/Linux) or Task Scheduler (on Windows) to automate the execution of your script at desired intervals. This will ensure continuous data flow from OpenWeather to your Oracle database. Create a cron job by editing the crontab file:
```bash
crontab -e
```
Add a line to schedule the script:
```bash
0 * * * * /usr/bin/python3 /path/to/your/script.py
```
This example schedules the script to run hourly.

By following these steps, you can effectively transfer data from OpenWeather to an Oracle database without using third-party connectors or integrations.