I have two machines, a windows 10 notebook with oracle database installed, and a Raspberry Pi 4 with DBeaver installed. On the Raspberry I have PostgreSQL which I can access locally via dbeaver, but since I'm studying and practicing Oracle DB, I need to access the database with the Raspberry. Is there any way to do it? Both machines are connected on the same wifi.
Yes, remote connections to an Oracle database is the standard way in real deployments.
Assuming there is nothing blocking communication between the two devices on your WiFi.
- Start a listener on your notebook (
lsnrctl start), the default one will start up using the your machine name as the host (this is ideal)
- Make sure your instance is registering with the listener. Check with
lsnrctl statusfor your instance. If it does not exist then check your
local_listenerparameter of your instance and add your machine name to it
- Use the listener host in your connection string from your Raspberry Pi. Use an appropriate service name