Home » RDBMS Server » Server Administration » Tnsnames issue
Tnsnames issue [message #220929] Thu, 22 February 2007 15:12 Go to next message
plshelp
Messages: 205
Registered: January 2007
Senior Member
Hi all,

I upgraded the database from 8.1.7.4 to 9.2.0.7 on solaris 9.
I created a orapw file and when I try to connect to the database
this way:

Enter user-name: sys/sys_ora@PRD as sysdba
ERROR:
ORA-12154: TNS:could not resolve service name

But when I try to connect this way it works

Enter user-name: sys/sys_ora as sysdba

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.7.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.7.0 - Production

What do you think the problem is???
Thanks for ya help.
Re: Tnsnames issue [message #220935 is a reply to message #220929] Thu, 22 February 2007 15:23 Go to previous messageGo to next message
Littlefoot
Messages: 20896
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Is there a 'prd' alias in your TNSNAMES.ORA?
Re: Tnsnames issue [message #220937 is a reply to message #220929] Thu, 22 February 2007 15:41 Go to previous messageGo to next message
plshelp
Messages: 205
Registered: January 2007
Senior Member
No it doesnt. this is my tnsnames.ora in the new oracle_home:

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
PRD.TELK=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = bkp01)(PORT = 1521))
)
(CONNECT_DATA = ( SID = PRD )
)
)

[Updated on: Thu, 22 February 2007 19:24]

Report message to a moderator

Re: Tnsnames issue [message #220949 is a reply to message #220929] Thu, 22 February 2007 18:30 Go to previous messageGo to next message
plshelp
Messages: 205
Registered: January 2007
Senior Member
Any idea anybody? please help
Re: Tnsnames issue [message #220951 is a reply to message #220929] Thu, 22 February 2007 19:24 Go to previous messageGo to next message
plshelp
Messages: 205
Registered: January 2007
Senior Member
Hi,

I figured out this tnsnames error. I didnt copy the sqlnet.ora from the previous home to the new oraclehome. After copyingthe sqlnet.ora, nomore I am getting this error but I am getting the below error:


Enter user-name: sys/sys_ora@prd as sysdba
ERROR:
ORA-01017: invalid username/password; logon denied

but I am able to connect like this:

Enter user-name: sys/sys_ora as sysdba

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.7.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.7.0 - Production

Suggestions greatly appreciated.
Re: Tnsnames issue [message #220952 is a reply to message #220951] Thu, 22 February 2007 19:35 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
use
sys/sys_ora@prd.telk as sysdba

>>but I am able to connect like this:
Because your are connecting to the database defined by ORACLE_SID (whatever it is)
Re: Tnsnames issue [message #220956 is a reply to message #220929] Thu, 22 February 2007 20:07 Go to previous messageGo to next message
plshelp
Messages: 205
Registered: January 2007
Senior Member
NO...thats not working either..

I ran this query:
select * from v$pwfile_users;
no rows selected

I believe this should return SYS user with SYSDBA option as TRUE.

I created orapwd file in the $ORACLE_HOME/dbs directory
as
orapwd file='orapwPRD' password=sys_ora entries=5

Please correct me if I am wrong here..
I dont know why its not picking it up.
Please give your suggestions
Re: Tnsnames issue [message #220960 is a reply to message #220956] Thu, 22 February 2007 20:33 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>orapwd file='orapwPRD' password=sys_ora entries=5
wrong syntax.
No quotes around filename.
Make sure you have remote_login_passwordfile to be exclusive.
May be you recreated the passwordfile with an open database.
If so just bounce the database (set ORACLE_SID in OS and use sqlplus "sys/password as sysdba")
The only valid tnsentry you have in your tnsnames.ora is PRD.TELK.
It should work, provided you did everything right and holding up to your story.
Re: Tnsnames issue [message #221085 is a reply to message #220929] Fri, 23 February 2007 13:50 Go to previous message
plshelp
Messages: 205
Registered: January 2007
Senior Member
Thanks, Mahesh. The mistake I did was I created spfile from pfile before changing the remote login to exclusive in pfile.
So in the spfile it was still showing none.
I recreated spfile from pfile and it works now.

Previous Topic: CPU Utilization - Find long running SQL query
Next Topic: Creating OLAP for 10g
Goto Forum:
  


Current Time: Tue Dec 06 02:34:09 CST 2016

Total time taken to generate the page: 0.10392 seconds