Dealing with Locales Ubuntu.

Installed brand new Ubuntu 14.04 64 bit on Hetzner server. Right after install tried to execute apt-get update and apt-get dist-upgrade. Getting following error nearly on all apt-get operation

export LANGUAGE=en_US.UTF-8
export LANG=en_US.UTF-8
export LC_ALL=en_US.UTF-8
locale-gen en_US.UTF-8 
dpkg-reconfigure locales

depending on your countries locales.

Securing the server using private and public keys

There is a way to generate private and public certificates.

The process is as follows: click here

It might be worthwhile to use the challenge password that you will remember

All important, but non-free updates and drivers

There are important updates that must be installed. to do this,

1. apt-get update

Ensure that locale is correctly set

export LC_ALL="en_ZA.UTF-8" export LC_CTYPE="en_ZA.UTF-8"    o make clipboard copy and paste - CTRL+V work normally use this one command:   echo -n "*VT100.translations: #override Meta <KeyPress> V: insert-selection(PRIMARY, CUT_BUFFER0)" >> ~/.Xdefaults

WARNING: REMOTE HOST IDENTIFICATION HAS CHANGED!

ssh-keygen -R hostname

Installing Ubuntu-server GUI

While the command line for ubuntu is intuitive, it requires that you practise using it. If you need to get the job done and do not have the time to practise, it will be worth your while to install a gui, while learning some of the key commands

Here are lists of the commands.

1. SSH cheat list
2. Easy to use  cheat list

the command to install the desktop is

apt-get install ubuntu-desktop

This is the simplest commonly used desktop.

The desktop is 2GB big, so make sure you have enough disk space.

Implementing a firewall on Ubuntu

This process involves securing the server against hacking.

A firewall called ufw is used for that purpose

The instructions are as follows:

This site gives a very clear guidance on how to configure the firewall. Click here

Changing ubuntu root password

From command line,

passwd root

The system will ask for your new password, 

type the new password, and confirm by typing it again.

A journey to open source

Today I am taking a bold 7-day journey to open source which will aid the decision to stay or move from the propriety operating system's platform

Key to the journey is the ability to acquire the following

1. Building on strong foundation

• Ubuntu 14.04 LTS (Done)
• Robust firewall
• Ability to publish (Done)
• Use of node.js for real-time applications

2. Getting Achieve-24 to run immediately

• get Oracle or MySQL to run in the same environment
• Migrate users
• Confirm URL to be used 

3.  Connecting humbub social-networking

• Start social blogging based on achieve-24
• Create links between achieve-24 and the social network
•  Drive up utilization

4. Bringing on board other tools such as Red-is (and Imfundo-SA)

• Ensure that other applications are migrated to the new platform
• Integrate other applications

5. Finally tick off what is important.

The experiences and tips will be recorded for future reference including reference sites. 

This promises to be an exciting journey and am looking forward to the experience.

While creating games, you may encounter : Re: ORA-03113: end-of-file on communication channel, this is how you deal with it... (make sure you have a backup)

Notes from ... Mandju

FIX- ORA-03113: end-of-file on communication channel

Process ID: 12400
Session ID: 96 Serial number: 3

Solution:

1.Check your alert log file

One of the suggested action is to look in the alert.log file.  To find the location of alert.log, you do:

1. Find the location of diagnostic destination from the initialization parameter file (i.e., dbs/init<sid>.ora ).  For example, we have this entry:
• diagnostic_dest=/slot/fiz7865/log
• 
  
2. From there, you can find alert.log file in the following sub directory:
• <diagnostic_dest>/diag/rdbms/<dbname>/<instname>/trace

In the alert_<sid>.log, we have found the following messages:

-rw-r----- 1 oracle oinstall 178164407 Jul 22 15:51 alert_app.log

[oracle@exilant trace]$ tail -200 alert_app.log

Output of alert log file:

Errors in file /opt/app/oracle/diag/rdbms/apple/apple/trace/apple_arc3_3238.trc:

ORA-19809: limit exceeded for recovery files

ORA-19804: cannot reclaim 18179072 bytes disk space from 4070572032 limit

ARC3: Error 19809 Creating archive log file to '/opt/app/oracle/flash_recovery_area/APPLE/archivelog/2013_03_10/o1_mf_1_615_%u_.arc'

Sun Mar 10 16:05:32 2013

Errors in file /opt/app/oracle/diag/rdbms/apple/apple/trace/apple_arc0_3201.trc:

ORA-19815: WARNING: db_recovery_file_dest_size of 4070572032 bytes is 100.00% used, and has 0 remaining bytes available.

************************************************************************

You have following choices to free up space from recovery area:

1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard,

   then consider changing RMAN ARCHIVELOG DELETION POLICY.

2. Back up files to tertiary device such as tape using RMAN

   BACKUP RECOVERY AREA command.

3. Add disk space and increase db_recovery_file_dest_size parameter to

   reflect the new space.

4. Delete unnecessary files using RMAN DELETE command. If an operating

   system command was used to delete files, then use RMAN CROSSCHECK and

   DELETE EXPIRED commands.

************************************************************************

Errors in file /opt/app/oracle/diag/rdbms/apple/apple/trace/apple_arc0_3201.trc:

ORA-19809: limit exceeded for recovery files

ORA-19804: cannot reclaim 18179072 bytes disk space from 4070572032 limit

ARC0: Error 19809 Creating archive log file to '/opt/app/oracle/flash_recovery_area/APPLE/archivelog

2. Go to SQLPLUS

         SQL> startup                                         — Failed to startup, the same ORA-03113 Error

 SQL> startup nomount                          — ORACLE Instance Started

 SQL> alter database mount                   — Database altered

 SQL> exit

 $ rman target /

 RMAN> crosscheck archivelog all      — Here you will see all the names of archivelogs still exist

 RMAN> delete expired archivelog all

 RMAN> exit

 $ sqlplus / as sysdba

 SQL> alter database open                    — Database altered

$ ps -ef | grep pmon

oracle   12734     1  0 16:10 ?        00:00:00 ora_pmon_app

oracle   12880 12257  0 16:12 pts/5    00:00:00 grep pmon