Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

oracle 10g ora 12560 and ora 12514 errors

448896Aug 2 2005 — edited Feb 11 2011
i am a new oracle user. and i have some problems

i installed 10g then,
when i was creating a database,
i received an error messagge "ora-12560",
therefore i cancelled creating database.

i run sqlplus, i received error messagge again
but this messagge differ from first one. it is "ora-12514"

and i tested net manager my oranokta in tnsnames,
same problem is continuesly

and last thing i have a toshiba notebook with intel centrino 1.6
and windows xp with sp2.

i attached below my tnsnames, listener and sqlnet.ora files.



--------------------------------
listener.ora

# listener.ora Network Configuration File: D:\oracle\product\10.1.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\product\10.1.0\db_1)
(PROGRAM = extproc)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = muttim)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
)
)


-----------------------------------
sqlnet.ora

# sqlnet.ora Network Configuration File: D:\oracle\product\10.1.0\db_1\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES)


------------------------------------
tnsnames.ora

# tnsnames.ora Network Configuration File: D:\oracle\product\10.1.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

ORA10 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = muttim)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = Ora10)
)
)

ORANOKTA =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = muttim)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = OraNokta)
)
)

thank you for help
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 11 2011
Added on Aug 2 2005
15 comments
12,319 views