Home » RDBMS Server » Server Administration » Connectivity Problem (Oracle 10g, RHEL 5.9 64bit)
Connectivity Problem [message #587905] Wed, 19 June 2013 05:21 Go to next message
morad_dba
Messages: 72
Registered: June 2008
Member


Dear All,

I have install Oracle 10g Database software in Red Hat 5.9 64bit. When I want to create a database manually (not using DBCA) I am getting errors like follow:

[oracle@t24app2 ~]$ export ORACLE_SID=dbend08
[oracle@t24app2 ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Wed Jun 19 16:19:37 2013

Copyright (c) 1982, 2005, Oracle. All rights reserved.

ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified


Enter user-name:



Please help what can I do?

I am trying to connect as host not using Tns file info.

Regards,

Morad.
Re: Connectivity Problem [message #587907 is a reply to message #587905] Wed, 19 June 2013 05:33 Go to previous messageGo to next message
Michel Cadot
Messages: 58938
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
env | egrep '(ORA|TNS|NLS|PATH|LOCAL|TASK)' | sort


Regards
Michel

[Updated on: Wed, 19 June 2013 05:37]

Report message to a moderator

Re: Connectivity Problem [message #587909 is a reply to message #587905] Wed, 19 June 2013 05:34 Go to previous messageGo to next message
ThomasG
Messages: 3099
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Could it be that the TWO_TASK variable is set?

Check with "echo $TWO_TASK" and if yes, unset it with "unset TWO_TASK" and try again.
Re: Connectivity Problem [message #587916 is a reply to message #587909] Wed, 19 June 2013 05:49 Go to previous messageGo to next message
morad_dba
Messages: 72
Registered: June 2008
Member

Thanks... Mr ThomasG ,

There is TWO_TASK parameter in oracle user bash_profile...

When I unset the parameter

then it works...

Thanks...

(How can i mark my question as solved? Pls inform me) Shocked
Re: Connectivity Problem [message #587917 is a reply to message #587916] Wed, 19 June 2013 05:52 Go to previous message
Littlefoot
Messages: 19525
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
(You can not)
Previous Topic: How to apply grid infrastructure patch set PSU 16083653 in linux 6.4
Next Topic: Changing hostname
Goto Forum:
  


Current Time: Fri Aug 29 15:22:20 CDT 2014

Total time taken to generate the page: 0.17402 seconds