| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| ORA-01017: invalid username/password : Logon denied |
« View previous topic :: View next topic » |
| Author |
Message
|
| SABCAS |
 Posted: Tue Apr 29, 2008 6:13 am Post subject: ORA-01017: invalid username/password : Logon denied |
 |
|
Acolyte
Joined: 09 Mar 2005
Posts: 60
Location: Switzerland
|
Hello, I have a problem to connect to Host ORACLE DB, I have update my odbc.ini:
[SERVER]
Driver=/opt/IBM/mqsi/6.0/merant/lib/UKor820.so
Description=DataDirect 5.0 Oracle
EnableDescribeParam=1
OptimizePrepare=1
ServerName=SERVER
WorkArounds=536870912
ProcedureRetResults=1
ColumnSizeAsCharacter=1
SQLDescribeParam=1
I test with SQLPlus with username = username and is succesfully connected:
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
SQL>
My tnsnames.ora is
SERVER =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = *****(PORT = ****))
)
(CONNECT_DATA =
(SERVICE_NAME = servername)
)
)
But when I try to call the store procedure via MessageFlow I receive the following Failure Message
<ERROR><SOURCE>SifUnityDBSender</SOURCE><TIME>2008-04-29 13:10:32.324460</TIME><PROPERTIES><MessageSet></MessageSet><MessageType></MessageType><MessageFormat></MessageFormat><Encoding>273</Encoding><CodedCharSetId>819</CodedCharSetId><Transactional>TRUE</Transactional><Persistence>FALSE</Persistence><CreationTime>2008-04-29 11:10:31.660</CreationTime>....<Text>[DataDirect][ODBC Oracle driver][Oracle]ORA-01017: invalid username/password; logon denied </Text></Insert></DatabaseException></DatabaseException></RecoverableException></EXEPTLIST></ERROR>
Please could you me Help, where I have to search or what I forgott.
Thanks A Lot
Ciao
Sabato
Last edited by SABCAS on Thu Nov 03, 2011 2:49 am; edited 2 times in total |
|
| Back to top |
|
 |
| sebastianhirt |
| Posted: Tue Apr 29, 2008 6:36 am Post subject: |
|
|
Yatiri
Joined: 07 Jun 2004
Posts: 620
Location: Germany
|
|
| Back to top |
|
|
| SABCAS |
| Posted: Tue Apr 29, 2008 8:51 pm Post subject: |
|
|
Acolyte
Joined: 09 Mar 2005
Posts: 60
Location: Switzerland
|
Hello,
yes I did the following Command
mqsisetdbparms SBE1789 -n NOVISA -u user_esb_spt -p *******
I thing that the problem could be into the special Character in password
The Oracle Admin used a $ charcter, I don't know if it is a Problem with Broker
Thanks
Ciao Sabato |
|
| Back to top |
|
|
| SABCAS |
| Posted: Tue Apr 29, 2008 11:49 pm Post subject: |
|
|
Acolyte
Joined: 09 Mar 2005
Posts: 60
Location: Switzerland
|
Hello,
I solved the problem, it was the $ Character into the password with AIX , UNIX, I have to use before the $ Character an Escape Character \.
Thanks
Ciao
Sabato  |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
