How to connect oracle server with emacs?

Question

I want to connect to the server using Emacs. I found this link: EmacsWiki: sqlPlus

I did what is described there and added the following lines to the .emacs file:

(tablature required)
(requires "ide-skel")
(requires "sqlplus")

When I try Mx - "sql-oracle" , it asks me to enter "User: " , "Password: " and "Database: " , but I do not know "database" , all I have is the following data:

IP (hostname): #######
Port: ####
SID: orcl
UserName: ####
Password: ####

How can I get emacs to ask me to fill in only (and all) this data?

Answer 1

You can connect to Oracle using Mx sqlplus . Then you specify the connection string, for example user/ password@SID

If it does not work, try connecting to Oracle using sqlplus from the command line.

And check out the Tnsnames.ora file.