| 10g database creation - ORA: 12154 TNS - on Linux [message #99176] |
Thu, 16 September 2004 10:09  |
Rob Blick
Messages: 3
Registered: September 2004
|
Junior Member |
|
|
|
Anyone been able to get 10g running on Linux? The installer completes, but then when it tries to run the dbca, it fails with "ORA-12154: TNS: could not resolve service name." I get the same problem if I run dbca after finishing the install. Works fine on Win2k, but I need to move it over to Linux. Any help?
|
|
|
|
|
|
| Re: 10g database creation - ORA: 12154 TNS - on Linux [message #99180 is a reply to message #99177] |
Sun, 19 September 2004 14:25  |
Rob Blick
Messages: 3
Registered: September 2004
|
Junior Member |
|
|
Nothing new here... I click all the way through the dbca and at the end, where it starts copying database files, it dies with "ORA-12154: TNS: Could not resolve connect identifier specified." I click "Abort," since "Ignore" doesn't get me anywhere.
Here's the contents of my tnsnames.ora:
# tnsnames.ora Network Configuration File: /oracle/product/10.1.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
And here's listner.ora:
# listener.ora Network Configuration File: /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 = /oracle/product/10.1.0/db_1)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = caerus)(PORT = 1521))
)
)
)
And here's sqlnet.ora:
# sqlnet.ora Network Configuration File: /oracle/product/10.1.0/db_1/network/admin/sqlnet.ora
# Generated by Oracle configuration tools.
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
Any help is appreciated :-)
Thanks!
|
|
|
|
| Re: 10g database creation - ORA: 12154 TNS - on Linux [message #99183 is a reply to message #99180] |
Tue, 21 September 2004 04:46 |
Rob Blick
Messages: 3
Registered: September 2004
|
Junior Member |
|
|
In response to posts on other boards, I added a line for the new database in tnsnames.ora. Didn't fix the problem (it's not intuitive why tnanames.ora would need an entry for the database before the database is created, but I gave it several tries anyway), but I wanted to post the new tnsnames.ora in case anyone has any other ideas:
# tnsnames.ora Network Configuration File: /oracle/product/10.1.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = caerus)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
When I run dbca, it still barfs at the end when it starts installing the new DB (whose SID is orcl) with that same 12154 error. I'm at a loss! The listener is up (can telnet to port 1521), TNS_ADMIN is set to $ORACLE_HOME/network/admin. Any suggestions? Thanks again!
|
|
|
|
|
|
|
|
| Re: 10g database creation - ORA: 12154 TNS - on Linux [message #221199 is a reply to message #221198] |
Sun, 25 February 2007 03:39 |
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
|
Senior Member |
|
|
Hi,
Error : Ora-12514 it is not becuase of special character with password. it is becuase of misconfig TNSNAMES.ORA file.(most cases)
the issue is probably special characters in the password for SYS and SYSTEM
SQL> conn sys/"sys@oracle"@orcl as sysdba
Connected.
SQL> show parameter db_name
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_name string orcl
SQL>
And mention above URL is not correct.
>>>("The specified thread [0] was not found. ")
regards
Taj
[Updated on: Sun, 25 February 2007 03:39] Report message to a moderator |
|
|
|
| Re: 10g database creation - ORA: 12154 TNS - on Linux [message #221203 is a reply to message #221199] |
Sun, 25 February 2007 05:47 |
andrewnl
Messages: 2
Registered: February 2007
|
Junior Member |
|
|
The link is failing because I ended the sentence with a full stop, and the forum is presenting that as part of the link. Try this instead:
http://forums.oracle.com/forums/thread.jspa?threadID=252799
Please read that thread. My experience was exactly like the poster 'j2hpd00', and there are a number of similar threads on various forums. Also please note that this is a clean install. So it would have to be the OUI which is messing up the listener configuration. Maybe that happens - I don't know. But my experience has been like that of j2hpd00. Passwords with special characters like '@' led to failures of dbca during install. Reverting to a simple password made OUI, and dbca, complete successfully.
|
|
|
|
|
|
| Re: 10g database creation - ORA: 12154 TNS - on Linux [message #222521 is a reply to message #99176] |
Mon, 05 March 2007 05:11 |
praj.basnet
Messages: 1
Registered: March 2007
|
Junior Member |
|
|
Just wanted to add that it is the special characters - in my case that pesky @ character for my not so diffcult to crack oracle password!
Thanks for this info - I was searching for a long time before I stumpled on this simple but frustrating issue.
Basically if you are running DBCA and you get a TNS-12541 no listener error then check your passwords!
If you need help with instructions on the rest of the Oracle 10g install, try the great guide from Dizwell:
http://www.dizwell.com/prod/node/3
- Praj
|
|
|
|
| Re: 10g database creation - ORA: 12154 TNS - on Linux [message #339196 is a reply to message #221203] |
Thu, 07 August 2008 01:16 |
sparamasivan
Messages: 1
Registered: August 2008
|
Junior Member |
|
|
Hi andrewnl,
The logic worked for me.
For a long time I was unable to connect using sys and system user account through sqlplus from a client machine.
But at the same time I can able to connect via em console cum other database tools.
Now the issue was resolved after avoiding the special characters in the passwords.
Thanks.
Saran
|
|
|
|
) 1 Vote
] 
Blog
Search
Help
Members
Register
Login
Home
