- #KEY SOFTWARE ORACLE OLR CANNOT BE OPENED.ERROR 2 HOW TO#
- #KEY SOFTWARE ORACLE OLR CANNOT BE OPENED.ERROR 2 INSTALL#
- #KEY SOFTWARE ORACLE OLR CANNOT BE OPENED.ERROR 2 WINDOWS 7#
- #KEY SOFTWARE ORACLE OLR CANNOT BE OPENED.ERROR 2 WINDOWS#
Try to restart the listener and register your sid dynamically with listener.Ĭonnecting to Oracle 11g DB from Visual Studio 12 I'm trying to connect to my school's database for my final so that I can build a GUI for it. So I checked lsnrctl.exe status and my testdb isn't there. Sqlplus /nolog -> connect sys/system as sysdba -since local and ORACLE_SID are setĪnd I always get an "unkown service or sid" error. (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) In services.msc there's everything ok - service showed up and run. New service - oradim.exe -new -sid %ORACLE_SID% -intpwd system -startmode M sqlplus or oradim for security I run from /BIN directory with ".exe" on the end. Important thing - I have also 11g installation in same folder (product) so to run f.e. I did this many times and in my opinion, there's nothing I did wrong. Oracle 12c, creating new instance and database, LSNRCTL does not see service I'am trying to setup a new database on oracle 12c.
Run createdXE.cmd from command line with admin privileges. #%ORACLE_HOME%\rdbms\admin\catqm.sql change_on_install SYSAUX TEMP NO #%ORACLE_HOME%\sqlplus\admin\help\hlpbld.sql helpus.sql SMALLFILE UNDO TABLESPACE UNDOTBS1 DATAFILE 'c:\oraclexe\app\oracle\oradata\XE\undotbs1.dbf' SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED ĬREATE SMALLFILE TABLESPACE USERS DATAFILE 'c:\oraclexe\app\oracle\oradata\XE\users.dbf' SIZE 300M REUSE AUTOEXTEND ON NEXT 1280K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO SMALLFILE DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE 'c:\oraclexe\app\oracle\oradata\XE\temp.dbf' SIZE 20M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED SYSAUX DATAFILE 'c:\oraclexe\app\oracle\oradata\XE\sysaux.dbf' SIZE 120M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED Spool %ORACLE_BASE%\admin\XE\CreateXE.log ĭATAFILE 'c:\oraclexe\app\oracle\oradata\XE\system.dbf' SIZE 300M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED Set NLS_LANG=AMERICAN_AMERICA.CL8MSWIN1251
#KEY SOFTWARE ORACLE OLR CANNOT BE OPENED.ERROR 2 WINDOWS#
Run commands below to stop Windows Oracle XE services, delete them and additional XE files:ĭel %ORACLE_BASE%\fast_recovery_area\XE\ONLINELOG\*.LOG Oradim -new -sid %ORACLE_SID% -intpwd admin -startmode auto -srvcstart system Set ORACLE_HOME=c:\oraclexe\app\oracle\product\11.2.0\serverĬopy init.ora from %ORACLE_HOME%\config\scripts to %ORACLE_HOME%\database, instead of existing, rename it to initXE.ora and add the configuration below:Ĭontrol_files=("C:\oraclexe\app\oracle\oradata\XE\control.dbf")Īudit_file_dest=C:\oraclexe\app\oracle\admin\XE\adumpĭispatchers="(PROTOCOL=TCP) (SERVICE=XEXDB)"ĭB_RECOVERY_FILE_DEST=C:\oraclexe\app\oracle\fast_recovery_areaįrom the previous cmd line with admin previleges run the command to create Oracle services and file %ORACLE_HOME%\database\PWDXE.ORA: First of all, set environment variables for your DB: Run cmd command line under administrator privileges and use it until the end of reconfiguration. If not default, then you should edit scripts below (paths and pwd) before use them.
#KEY SOFTWARE ORACLE OLR CANNOT BE OPENED.ERROR 2 INSTALL#
Install the last version of Oracle XE 11gR2 from the Oracle site to the default location c:\oraclexe with default password admin. It is in Russian, I provide the solution right here in English.
#KEY SOFTWARE ORACLE OLR CANNOT BE OPENED.ERROR 2 HOW TO#
How can I find what goes wrong and fix the problem?Īfter struggling with this problem for almost a week I found a solution, how to make XE database available from this source. error 2 clse_get_crs_home: Error retrieving OLR configuration Oracle Database 11g Clusterware Release 11.2.0.2.0 - ProductionĬopyright 1996, 2010 Oracle. The log file from '%ORACLE_HOME%\server\log\myhost\client' contains this error: SQLNET.AUTHENTICATION_SERVICES = (NONE NTS)
I fixed tnsnames.ora by setting localhost IP address:
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) (ORACLE_HOME = C:\oraclexe\app\oracle\product\11.2.0\server) The content of my listener.ora with localhost: However, when I try to get the list of available databases I receive an errorįor some reason the XE database was not created into %ORACLE_BASE%\oradata\XE.
#KEY SOFTWARE ORACLE OLR CANNOT BE OPENED.ERROR 2 WINDOWS 7#
Oracle XE 11g the XE database was not found - database I am a new one who started to use Oracle Database and faced the problem during installation the last verstion of Oracle XE 11g 圆4 to the Microsoft Windows 7 圆4 Enterprise.ĭuring installation were not any errors and Windows Services (OracleXETNSListener and OracleServiceXE) were successfully created and started.
0 kommentar(er)
