| Tnsnames issue [message #220929] |
Thu, 22 February 2007 15:12  |
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 #220937 is a reply to message #220929] |
Thu, 22 February 2007 15:41  |
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 #220951 is a reply to message #220929] |
Thu, 22 February 2007 19:24 |
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 #220956 is a reply to message #220929] |
Thu, 22 February 2007 20:07 |
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 #221085 is a reply to message #220929] |
Fri, 23 February 2007 13:50 |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
