- 17.9K All Categories
- 3.4K Industry Applications
- 3.4K Intelligent Advisor
- 73 Insurance
- 537.3K On-Premises Infrastructure
- 138.6K Analytics Software
- 38.6K Application Development Software
- 6K Cloud Platform
- 109.6K Database Software
- 17.6K Enterprise Manager
- 8.8K Hardware
- 71.2K Infrastructure Software
- 105.3K Integration
- 41.6K Security Software
Can't oracle19c use the ORACLE_SID environment variable to connect to the database?
I have a Pro*C file upgraded from Oracle10 to 19c.
In Oracle10 I use "
proc USERID=aaa/bbb SQLCHECK=SEMANTICS ..." to compile the .pc file, the proc will connect to the ORACLE_SID database, but when compiling the file in 19c, it reports "
PCC-02104Unable to connect to Oracle" error, meaning The username or password is invalid. I changed the compile command to "
proc USERID=aaa/[email protected] SQLCHECK=SEMANTICS ... " and tried again, and it was successful, because I used @ccc to specify the database to connect to.
Does 19c not support using ORACLE_SID to connect to the database? If yes, is there any documentation about it? I really need this, because this problem is just my test, no official instructions