How to resolve ORA-00214: control file inconsistent with file

Tried to startup or mount a database, we got ORA-00214.

SQL> startup
ORACLE instance started.
...
ORA-00214: control file
'/u01/app/oracle/fast_recovery_area/ORCLCDB/control02.ctl' version 2286
inconsistent with file '/u01/app/oracle/oradata/ORCLCDB/control01.ctl' version
2248

Let's see its status.

SQL> select status from v$instance;

STATUS
------------
STARTED

What does STARTED means? We can tell what state of database currently is by some means. It's at NOMOUNT now.

Read more....

Schema Assignment to Workspace in Oracle Apex

Run oracle apex by entering the link in your browser. In my case I am using chrome and entered the link http://127.0.0.1:8080/apex/apex_admin

Select "manage workspace".

Select "manage workspace to schema assignment".

Select the name of space to which you want to assign schema.

select database schema and apply changes.

How to fix ORA-00604: error occurred at recursive SQL level 1 and ORA-12705: Cannot access NLS data files or invalid environment specified

Open SQL Developer package content. Go to Applications, right click on SQL Developer and select "Show Package Contents".

• Go to Contents/Resources/sqldeveloper/sqldeveloper/bin/
• Open sqldeveloper.conf using a text editor.

Add the following lines:

# Options to avoid "ORA-12705: Cannot access NLS data files or invalid environment specified." AddVMOption -Duser.language=en 

AddVMOption -Duser.region=US 

AddVMOption -Duser.country=en

Restart SQL Developer

If you are facing this issue in oracle apex and ords installation by executing C:\apex_20.2\ords>java -jar ords.war command.

First execute query:

select userenv('LANGUAGE') from dual;`

This will give oracle regional and language. Change the regional and language in OS, both should match.

--------------------------------------------------------------------------------

[SOLVED]

For those who encountered same problem and is checking on this.

I finally found the solution by setting my default language to English(United States). Any region would suffice as long as my language is set to this.

Go to Control Panel > Clock and Region > Region

Select English(United States)

Step by step Oracle Apex 20.2 installation on Windows

 

Here a step by step installations activity for APEX 20.2 with ORDS 20.4.1, full installation on Windows Oracle Axpress 11g with database version 11g.

I have downloaded the binaries/medias from below links.

Failed to Start the X server (your graphical interface)

Problems with the X Server Crashing and Non-Root Users

If you are having trouble with the X server crashing when anyone logs in, you may have a full file system (or, a lack of available hard drive space).

To verify that this is the problem you are experiencing, run the following command:

[oracle@localhost ~]$ df -h

The df command should help you diagnose which partition is full. For additional information about df and an explanation of the options available (such as the -h option used in this example), refer to the df man page by typing man df at a shell prompt.

A key indicator is 100% full or a percentage above 90% or 95% on a partition. The /home/ and /tmp/ partitions can sometimes fill up quickly with user files. You can make some room on that partition by removing old files. After you free up some disk space, try running X as the user that was unsuccessful before.

OR

This problem may be resolved in this way:

1. When the message about viewing the X server output came, I pressed Ctrl Alt F2
2. Now on the new shell I ran command sudo Xorg -configure
3. Then I copied /home/oobe/xorg.conf.new to /etc/X11/xorg.conf
sudo cp /home/oobe/xorg.conf.new /etc/X11/xorg.conf
4. At last I started X using command startx.

Access Django app from other computers

This is very very simple

change in setting.py

ALLOWED_HOSTS = ['*']

python manage.py runserver 0.0.0.0:8000 

open linux terminal

sudo ifconfig

Get inet ipv4 address Run on other same local network PC

If you find following error

Using the URLconf defined in mysite.urls, Django tried these URL patterns, in this order: 

1. polls/ [name='index'] 

2. admin/ 

The current path, polls/, didn’t match any of these. Then

replace path(' ', views.index, name='index') with path('', views.index, name='index') in your polls/urls.py and check the result.

Installation and setup of SAMBA and TkSmb in RedHat Linux 5

SAMBA is an open source software suite that provides seamless file and print services to SMB/CIFS clients. It is available for Linux, Solaris, SunOS, HP-UX, ULTRIX, DEC OSF/1, Digital UNIX, Dynix (Sequent), IRIX (SGI), SCO Open Server, DG-UX, UNIXWARE, AIX, BSDI, NetBSD, NEXTSTEP, A/UX, etc. For a detailed introduction see this article. Linux machines using SAMBA are seen by NT as part of a NT Domain and can share printers and directories with Windows (95/98/NT) machines. This tutorial will cover the basics of installing and setting up SAMBA, and also TkSmb, a graphical tool to manage shares between Linux and NT.

Read more...