CODEWITHSUNDEEP
oracle-databaseweblogicweblogic12coraclereportsoracle-fusion-middleware
Jose Luis Garcia Arcalle
Jose Luis Garcia Arcalle

Reputation: 11

Weblogic 12c REP-501: The specified database cannot be connected

I have a problem when executing it outside the form builder,

from the call

http: // localhost: 9001 / forms / frmservlet? Config = webutil_webstart

  1. the report works well from the formbuilder and runs smoothly
  2. but when executing it from the direct url, I do not run the report,

I do the validation on the server with showjobs the error that I have is

The report ended in error: REP-501: The specified database can not be connected ..

Maybe you can give me a hand where I would be missing some configuration.

thanks a lot.

Upvotes: 0

Views: 8654

Answers (4)

Eyad AL-Lahham
Eyad AL-Lahham

Reputation: 1

Edit The RWBuilder.bat

Add Two Lines

set TNS_ADMIN=C:\Oracle\Middleware\Oracle_Home\network\ADMIN

set ORACLE_HOME=C:\Oracle\Middleware\Oracle_Home

Upvotes: 0

Jayanta
Jayanta

Reputation: 145

"If you're on Linux. The issues is due to special character in your password that could not be interpreted. If you change the password in the database without special character or replace the spacial character with an underscore (_). It should work." previous POST

100% correct

I had # in my password changed to &23 and it worked

https://www.w3schools.com/tags/ref_urlencode.ASP

Upvotes: 0

Ora
Ora

Reputation: 11

If you're on Linux. The issues is due to special character in your password that could not be interpreted. If you change the password in the database without special character or replace the spacial character with an underscore (_). It should work.

Upvotes: 1

Barbaros Özhan
Barbaros Özhan

Reputation: 65408

look at your db alias(assume mydb01) in tnsnames.ora file under these paths:

$ORACLE_INSTANCE/config for Linux or Solaris.

maybe like C:\Oracle\Middleware\asinst_1\config for Windows.

Try to ping that alias like :

tnsping mydb01

if succeeds, use it for your connections.

During call of run_report_object() you have some parameter settings, whilst you may have such alike statement :

hidden_action := hidden_action ||’&userid=’
||get_application_property(username)||’/’||
get_application_property(password)||’@’||
get_application_property(connect_string);

Look at this arguments (connect_string,username&password) whether be set truely.

Upvotes: 1

Related Questions