 |
| REBOL with Oracle 19c | |
| Kissonde | 13-Feb-2021/18:29:13 |
| Hello guys, We've upgraded oracle database from 12c to 19c. Rebol scripts that were working now fail to do so. We're using the following script to open a connection: open oracle://APPMON:#appmon#@PRODDB to connect but we're getting the following error: ** Script Error: Oracle error: ORA-01017: invalid username/password; logon denied ** Near: open oracle://APPMON:#appmon#@PRODDB Using the same user and password from sqlplus works like a charm. Can you guys please advise on how to tackle this problem? | |
| none | 18-Feb-2021/21:23:09 |
| I'm not an Oracle specialist, but we had the same kind of problem with mySql several years ago. It's probably due to a new way of making the user/pass encoding in Oracle 19, that is not handled by the old Rebol Oracle protocol. AFAIK, Oracle:// protocol is a Rebol/command features. And Rebol/command has not evolved since many years, like all Rebol2 based interpreter. It's the problem with messaging language: messaging protocol evolved ! I have no solution, but I think you must have a look in the Oracle 19 configuration to enable old user/pass protocol handling. But notice that it could make your DB less protected: if the security protocol has evolved, its probably for security reasons  | |
|
Login required to Post. | |