ORA-12514

[williey]

I had successfully install Oracle 11g under Fedora 7 environment. Connection Enterprise Manager was successful. So was connection to database.

However I encountered ORA-12514 when trying to connect a week later. Note: I had not boot into the machine since the install.

LISTENER.ORA

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /u01/app/oracle/product/11.1.0/db_1)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = TEST.WORLD)
      (ORACLE_HOME = /u01/app/oracle/product/11.1.0/db_1)
      (ORACLE_SID = TEST)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))
    )
  )

TNSNAMES.ORA

LISTENER = 
  (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))

TEST = 
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = TEST.WORLD)
    )
  )

SQLNET.ORA

SQLNET.AUTHENTICATION_SERVICES= (NONE)

NAMES.DIRECTORY_PATH= (TNSNAMES)

When I start up the listener, the following messages are displayed.

Services Summary...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service....
Service "TEST.WORLD" has 1 instance(s).
  Instance "TEST.WORLD", status UNKNOWN, has 1 handler(s) for this service....

Is there some setup missing? ORACLE_HOME and ORACLE_SID are globally defined in /etc/profile.



------------------------------------------
There are 10 kinds of people in this world. One that understands binary and the other one that does not.

 

[yelworcm]

Is the database itself running?

 

[williey]

Thanks I got it to work finally. I went through all the setup and got it to work.

Now I'm trying figure out why dbstart does not start the instance. it error out on ora-01031.

------------------------------------------
There are 10 kinds of people in this world. One that understands binary and the other one that does not.