Steps for resolving the oracle database startup error " ORA-03113: end-of-file on communication channel"

When trying to start the oracle database some times we may get the below error

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

Process ID: 18413

Session ID: 247 Serial number: 29985

Please find the steps below for resolving this issue

1. Exit from the sql prompt and again connect as sysdba to an idle instance.

2. Now start the database into nomount as below

3. Now alter the database to mount as below

4. Clear the unarchived log files as below

5. Shutdown the database now

6. Start the database now and it will start without errors

Change IP or Host name for an already installed Cloudera Manager

1. Shutdown all services
2. service cloudera-scm-agent stop on all nodes 
3. service cloudera-scm-server stop on CM server

Login to master node through putty and connect to postgres sql database 

It will ask for the password for scm user.

If we don't know the password , issue the below command to get the password

With the password login to database now with previous command.

Issue the below command to get the list of nodes details

Now issue the below update command to update the ipaddress of the desired node

Check the node for updated ip now

Steps for Deploying RPD manually in OBIEE 11g

We cannot upload the rpd with large size through EM console in OBIEE 11g.

We will get the below error while trying to upload rpd with large size

We can upload the large sized rpd manually.

Note : Copy the large size rpd (Ex: test.rpd ) to rpd file location on obiee server

"/mwhome/instance/instance1/bifoundation/OracleBIServerComponent/coreapplication_obis1/repository/"

Steps for uploading rpd manually:

1. Login to weblogic em console through url (http://localhost:7001/em)

2. On the left pane expand “Weblogic Domain” >bifoundation_domain>bi_cluster. Click on bi_server1 and then in the right pane, click on WebLogic Server drop down list and choose “System MBean Browser”


















3. Expand “Application Defined MBeans” >oracle.biee.admin> Domain: bifoundation_domain>BIDomain> and select the ‘BIDomain’

4. Go to the Operations Tab in the far right pane. Click on “Lock” and then !Invoke” button.

5. Navigate to BIDomain.BIInstance.ServerConfiguration> select BIDomain.BIInstance.ServerConfiguration

6. Navigate to the ‘Operations’ Tab from the far right pane and click on “uploadRepository”

Rpd file path :
/mwhome/instance/instance1/bifoundation/OracleBIServerComponent/coreapplication_obis1/repository/test.rpd

Password : Admin123

7. Click “Invoke"

8. “Lock” on the domain needs to be released. To release the lock, Navigate back to BIDomain> Operations and click on “Commit” and then click on “Invoke”

9. Restart the BI Server (OPMN Services) from EM

Installing HBase

Prerequisites:

1. Java

2. Hadoop

Installing HBase in Standalone Mode

Configuring HBase in Standalone Mode

Modify hbase-env.sh file under /u01/hadoop/hbase-1.2.6/conf as below

save and close the file

Modify hbase-site.xml under /u01/hadoop/hbase-1.2.6/conf as below

Starting HBase

Installing HBase in Pseudo-Distributed Mode

CONFIGURING HBASE

Note: Stop HBase if it is running

Modify hbase-site.xml under /u01/hadoop/hbase-1.2.6/conf as below

Starting HBase

Checking the HBase Directory in HDFS

Starting and Stopping a Master

Using the “local-master-backup.sh” you can start up to 10 servers. Open the home folder of HBase, master and execute the following command to start it.

Stopping Master

Starting and Stopping RegionServers

We can run multiple region servers from a single system using the following command.

Starting RegionServers

Stopping RegionServers

Starting HBase shell

HBase shell general commands

List:

It will give the list of all the tables in HBase

Status:

This command returns the status of the system including the details of the servers running on the system.

Version:

This command returns the version of HBase used in your system

table_help:

This command guides you what and how to use table-referenced commands.

whoami:

This command returns the user details of HBase

Creating a Table using HBase Shell

We can create a table using the create command, here you must specify the table name and the Column Family name.

Syntax : create ‘<table name>’,’<column family>’ 

HBase Web Interface

http://localhost:16010

This interface lists your currently running Region servers, backup masters and HBase tables.

Setting Environment variables

Add HBase home and paths in .bashrc file under /home/hadoop as below

Execute the .bashrc file as below