ORA-12514

[williey]

Due to lack of traffic and response on 11g forum, I'm reposting my question here.

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.

Also I do have the "@" symbol in my password. Using sqlplus sys/"xxxx@xxx"@TEST to login still returns the same ORA-12514 error.


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

 

[Turkbear]

Hi,
Try using a user/pass combo that does not have the @ in the pass..


Also, try @TEST.WORLD as the connection string





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[williey]

Thanks! I was able to figure out logging in and changing the password.







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