Installed OracleXE112_Win64 . Then I run sqlplus , try to connect and get an error:

  SQL> connect Enter user-name: system Enter password: ERROR: ORA-01034: ORACLE not availabl ORA-27101: shared memory realm Process ID: 0 Session ID: 0 Serial number: 0

Tried also like this, but without success:

  SQL> conn / as sysdba ERROR: ORA-12705: Cannot access NLS data files or invalid environment specified

How can you just connect out of the box and create a simple test base and user?

  • usually oracle "out of the box" base should be created immediately when you install it, there is an item in the installer. And using sqlplus is very long and difficult. look in the menu there should be some kind of assistants with their help you can create - Mike
  • @Mike, the fact of the matter is that when installing, apart from setting a password for the user System nothing can be done - S.Ivanov
  • Judging by ORA-12705 regional settings are not configured correctly. Find the HKEY_LOCAL_MACHINE / SOFTWARE / Oracle branch in the Windows registry, find OracleHome From your installation and set it with NLS_LANG such as AMERICA_CIS.CL8MSWIN1251. Although, of course, the encoding depends on which client is used. - hinotf
  • Not necessary. Similar sims will be if the environment variable ORACLE_HOME - Mike is not set
  • @hinotf, this did not help, both variables are set - S.Ivanov

1 answer 1

To run must be correctly spelled variables (for example):

 set ORACLE_SID=xe set ORACLE_HOME=c:\oracle\product\11.2.0\dbhome_1 set PATH=%ORACLE_HOME%\bin;%PATH%

If there are problems with NLS, I would also register NLS_LANG.

 set NLS_LANG=american_america.CL8MSWIN1251 sqlplus "/as sysdba"

PS Of course, this is provided that the database is created. If not, then it is easier for you to create it through DBCA. In Windows, you can run it through:

 C:\oracle\product\11.2.0>%ORACLE_HOME%\bin\dbca

Or on the Start menu in the Oracle Home folder - Database Configuration Assistant

  • In the first line - set ORACLE_SID=xe - 0xdb