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!
We have an Oracle Database running v. 18c, with a table containing a column with Datatype RAW(16). The Datatype was chosen by Entity Framework using Code-first implementation of the GUID datatype in .NET We have set up an index on the column The equivalent field in .NET is setup like this When running a query, looking for specific EJERSKIFTE_ID based on the GUID value, the query will not use the index. If instead we surround each representation of the GUID value with "HEXTORAW()" It will correctly use the index.
Original query (Not triggering index): SELECT "e"."OBJECTID" FROM "GSTEJF"."EJERSKABSSKIFTE" "e" WHERE (((((("e"."EJERSKIFTE_ID" IN ('AB6AF396EB644B17B517D698489B16D9', 'B7E9D9A8526541C7BA65DD3E314FB6C0')) AND ("e"."REGISTRERINGFRA" <= :transactionTime_1))) AND ((("e"."REGISTRERINGTIL" > :transactionTime_2) OR ("e"."REGISTRERINGTIL" IS NULL))))) AND ((("e"."VIRKNINGFRA" <= :validTime_3) AND ((("e"."VIRKNINGTIL" > :validTime_4) OR ("e"."VIRKNINGTIL" IS NULL)))))) And corresponding Execution-plan Modified query (Correctly triggering index): SELECT "e"."OBJECTID" FROM "GSTEJF"."EJERSKABSSKIFTE" "e" WHERE (((((("e"."EJERSKIFTE_ID" IN (HEXTORAW('AB6AF396EB644B17B517D698489B16D9'), HEXTORAW('B7E9D9A8526541C7BA65DD3E314FB6C0'))) AND ("e"."REGISTRERINGFRA" <= :transactionTime_1))) AND ((("e"."REGISTRERINGTIL" > :transactionTime_2) OR ("e"."REGISTRERINGTIL" IS NULL))))) AND ((("e"."VIRKNINGFRA" <= :validTime_3) AND ((("e"."VIRKNINGTIL" > :validTime_4) OR ("e"."VIRKNINGTIL" IS NULL)))))) And corresponding Execution-plan EF Core version: 3.1.10 Database provider: Oracle.Manageddataaccess IDE: Visual studio 2019
SELECT "e"."OBJECTID" FROM "GSTEJF"."EJERSKABSSKIFTE" "e" WHERE (((((("e"."EJERSKIFTE_ID" IN (HEXTORAW('AB6AF396EB644B17B517D698489B16D9'), HEXTORAW('B7E9D9A8526541C7BA65DD3E314FB6C0'))) AND ("e"."REGISTRERINGFRA" <= :transactionTime_1))) AND ((("e"."REGISTRERINGTIL" > :transactionTime_2) OR ("e"."REGISTRERINGTIL" IS NULL))))) AND ((("e"."VIRKNINGFRA" <= :validTime_3) AND ((("e"."VIRKNINGTIL" > :validTime_4) OR ("e"."VIRKNINGTIL" IS NULL))))))
How do I ask a question on the forums?
https://forums.oracle.com/message/9362002#9362002
Installation is successful, but https://localhost:5500/em/ doesn't work. What is wrong?
Use google and search for "oracle 12c doesn't work" and see if you get any relevant hits.
If none of the search results seems relevant you might want to use a better term than "doesn't work"; there is NO such Oracle exception.
Installations also create an install log that you can review for issues/problems that occured during the install.
I suggest to issue
emctl status dbconsole
in a terminal/command prompt to get your EM url.
Have you tried that with EM Express 12c?
C:\Oracle\product\12.1.0\dbhome_1>dir /s /b emctl* File Not Found
The following might be better:
How can I find the port on which EM Express is configured?
Regards,
Mark
sqlplus sys as sysdba
SQL> select dbms_xdb_config.gethttpsport() from dual;
Should return something like:
DBMS_XDB_CONFIG.GETHTTPSPORT()
------------------------------
5500