View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0000299 | Windows and other desktop OS | Server | public | 2019-10-03 13:14 | 2019-10-08 11:59 |
Reporter | DigitalMy | ||||
Priority | normal | Severity | minor | Reproducibility | have not tried |
Status | assigned | Resolution | open | ||
Summary | 0000299: Install Oracle database server to Windows 10 OS and create DB | ||||
Description | Domain user, added to local Administrators group. created one local user account for oracle database "oracle" ERROR on DB creation: [many errors] Unable to obtain current patch information due to error: 4067, ORA-04067 > possible reason : running the command with a different user, who doesn't have permission on $ORACLE_HOME/QOpatch folder | ||||
Tags | No tags attached. | ||||
FinishDate | |||||
StartDate | 2019-10-01 | ||||
WasteTime | 0 | ||||
PriorityIndex | 1 | ||||
LaboriousnessIndex | 1 | ||||
|
> Error on database creation: Unable to obtain current patch information due to error: 4067, ORA-04067: not executed, package body "SYS.DBMS_QOPATCH" does not exist ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_QOPATCH" ORA-06512: at line 1 Dumping current patch information Unable to obtain current patch information due to error: 4067 ORACLE_HOME was not found in system variables... > add it manually with value to installation path "C:\oracle\home\" now %ORACLE_HOME% can be resolved in Windows > add rights for all users to subfolder "QOpatch" after that DB creation went on... up to 86% on step "completing database creation", which never ends... > one more step "completing database creation" had similar problem with %SQLPATCH_ORACLE_HOME% variable : done same fix, same folder value ("sqlpatch" subfolder) > add path to "ORACLE_BASE" folder "C:\oracle\" |
|
|
|
Database Characterset for PDB$SEED is CL8MSWIN1251 change to UTF8 default... PDB$SEED(2):Accessing dba_registry_sqlpatch hit error: 942 This is table name "dba_registry_sqlpatch" in database layout "PDB$SEED" in container database (CDB) . export ORACLE_SID=prmcdb sqlplus / as sysdba select * from dba_registry_sqlpatch |
|
Tested db version 12c_x64 + Windows 10 rus pro + jre 1.7 Used "Virtual oracle home user" option for home "C:\oracle\home". Installation was successful. > installer stuck on 89% "saving inventory" step long time... "Computed ORACLE_HOME_NAME = OraDB12Home1"; "A default value was calculated as per oraparam.ini" Finished installation. > Extract original distributive (oracle universal installer) archive to some folder. > edit ...\database\install\oraparam.ini DEFAULT_HOME_LOCATION=home DEFAULT_HOME_NAME=home > start "setup.exe" User : set new windows user "oracle" with password "oracle123" |
|
> error on DB creation : Accessing dba_registry_sqlpatch hit error: 942 [DBCreationMode.flowWorker] [KfodUtil.kfodOutput:383] Cannot run program "null\rdbms\bin\kfod.exe": CreateProcess error=2, The system cannot find the file specified [pool-1-thread-1] [HAUtils.isWalletExists:4000] Error checking wallet PRCW-1013 : Failed to initialize cluster wallet context due to error code 3 ERROR: Unable to normalize symbol name for the following short stack (at offset 182): dbgexProcessError()+398<-dbgePostErrorKGE()+2191<-dbkePostKGE_kgsf()+90<-kgeadse()+457<-kgerinv_internal()+86<-kgesoftnmierr()+768<-kskvmstatact()+1602<-kskdbrmtoutact()+259<-ksbcti..1()+348<-ksbabs()+15825<-ksbrdp()+1556<-opirip()+1539<-opidrv()+960<-sou2o()+112<-opimai_real()+222<-opimai()+231<-BackgroundThreadStart()+702<-00007FF975D52D92<-00007FF975DF9F64 Errors in file C:\ORACLE\diag\rdbms\rtsx\rtsx\trace\rtsx_dbrm_5948.trc (incident=65) (PDBNAME=CDB$ROOT): ORA-00700: soft internal error, arguments: [kskvmstatact: excessive swapping observed] Pluggable Database PDB$SEED with pdb id - 2 is altered with errors or warnings. Please look into PDB_PLUG_IN_VIOLATIONS view for more details. |
|
Oracle database: Windows download from https://edelivery.oracle.com/osdc/faces/SoftwareDelivery official distributive Set files in "oracle home": ...\network\admin\listener.ora ...\network\admin\tnsnames.ora ...\network\admin\sqlnet.ora Add firewall rules for apps in "oracle home": ...\bin\tnslsnr.exe ...\bin\oracle.exe ...\perl\bin\perl.exe ...\bin\sqlplus.exe ...\jdk\jre\bin\java.exe |