CODEWITHSUNDEEP
sqloracle-databasesqlplusoracle18c
pasta_enthusiast
pasta_enthusiast

Reputation: 31

Database Creation Issues for Oracle 18c in Windows

I'm trying to create a dummy database with a few example tables as part of a school project. I have no experience with Oracle, so please bear with me (if you have extensive knowledge on the topic, this read may be a good laugh).

Essentially, I have successfully installed Oracle 18c XE for Windows x64, and everything seems to be installed correctly. I just want to create a database and then a few tables inside of said database, but I'm running into a number of errors.

When following Oracle's instructions for creating a database, I get the following error: enter image description here

Somehow, I figured out that I need to make an instance of Oracle, so I did, and it's running according to services.msc. Here's the window of it's settings for reference: enter image description here

Not sure of why I was getting such an error, I found another guide suggesting I open Oracle through the newly installed SQL Plus application. After running / as sysdba, I am prompted to enter a User-Name and Password. Great. After finding this, I managed to find my tnsnames.ora and listener.ora files, which look like this, respectively:

ORACLR_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
    (CONNECT_DATA =
      (SID = CLRExtProc)
      (PRESENTATION = RO)
    )
  )

DEFAULT_SERVICE_LISTENER = XE

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = CLRExtProc)
      (ORACLE_HOME = C:\app\Nolan\product\18.0.0\dbhomeXE)
      (PROGRAM = extproc)
      (ENVS = "EXTPROC_DLLS=ONLY:C:\app\Nolan\product\18.0.0\dbhomeXE\bin\oraclr18.dll")
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = DESKTOP-495S61D)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  )

Trying system@"DESKTOP-495S61D:1521/orcl" or system@"DESKTOP-495S61D:1521/example" as a username and entering anything for the password throws ORA-12514: TNS:listener does not currently know of service requested in connect descriptor.

Nothing I enter into SQL Plus is working for a username. Furthermore, every time I enter a username, it stops taking any input for a password. I cannot paste anything nor can I type. I don't understand what I've done wrong or why Oracle hates me so much. If anyone could shed some light on my situation and help me get back on track, I would be forever indebted.

Upvotes: 0

Views: 700

Answers (1)

Bobby Durrett
Bobby Durrett

Reputation: 1303

It looks like you need to create a database. Your tnsnames.ora and listener.ora seem to be just configured for calls to external procs. You would have something with ORCL as the SID if you created a default database.

Bobby

Upvotes: 1

Related Questions