Skip to Main Content

PeopleSoft Enterprise

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!

File: SQL Access ManagerSQL error. Stmt #: 2 Error Position: 0 Return: 12154 - ORA-12154: TNS:coul

user10656964May 20 2014 — edited May 20 2014

Hi,

I am trying to login in datamover after tools and applications installation, getting following error

"File: SQL Access ManagerSQL error. Stmt #: 2  Error Position: 0  Return: 12154 - ORA-12154: TNS:could not resolve the connect identifier specified "

Environment details are

DB: 11g 64bit

Tools: 8.53

Finance: 9.1

Weblogic 11g

tns ping

Microsoft Windows [Version 6.1.7601]

Copyright (c) 2009 Microsoft Corporation.  All rights reserved.

C:\Users\Administrator>tnsping finance

TNS Ping Utility for 32-bit Windows: Version 11.2.0.1.0 - Production on 20-MAY-2

014 12:36:40

Copyright (c) 1997, 2010, Oracle.  All rights reserved.

Used parameter files:

C:\app\Administrator\product\11.2.0\client_1\network\admin\sqlnet.ora

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)

(HOST = WIN-3EEAB7CLE9V)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = FINANCE)

))

OK (10 msec)

C:\Users\Administrator>

sql connection details

C:\Users\Administrator>SQLPLUS SYSTEM/SYSTEM@FINANCE

SQL*Plus: Release 11.2.0.1.0 Production on Tue May 20 12:13:51 2014

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

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>

Please help me to fix this

Thank you so much

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 17 2014
Added on May 20 2014
7 comments
3,512 views