Wednesday 22 February 2023

BI Publisher Login Error "Server not initialized. Please make sure the repository is ready"

User received the “Server not initialized. Please make sure the repository is ready” error when they tried to access bi publisher:


9502/xmlpserver/ : Server not initialized. Please make sure the repository is ready.

We had check the logs then it's showing nodemanager not running then we had run below command:

$cd /erp_ords/BI/BI_Publisher/user_projects/domains/bip/bitools/bin
$./status.sh

Status of Domain: /erp_ords/BI/BI_Publisher/user_projects/domains/bip
NodeManager (erpapxrpt.nicsi.in:9508):NOT RUNNING

$./start.sh

Starting domain; Using domainHome: /erp_ords/BI/BI_Publisher/user_projects/domains/bip ...                                                           

Initializing WebLogic Scripting Tool (WLST) ...

Welcome to WebLogic Server Administration Scripting Shell

Type help() for help on available commands


NodeManager already running
Reading domain...
/Servers/AdminServer/ListenPort=9500
Accessing admin server using URL t3://erpapxrpt.nicsi.in:9500

AdminServer already running

Starting all servers ...
Server bi_server1 not started as already in state (RUNNING)
Starting obiccs1 (Original State:SHUTDOWN) ...
Started obiccs1

Starting obis1 (Original State:SHUTDOWN) ...
Started obis1

Starting obips1 (Original State:SHUTDOWN) ...
Started obips1

Starting obijh1 (Original State:SHUTDOWN) ...
Started obijh1

Starting obisch1 (Original State:SHUTDOWN) ...
Started obisch1


Finished starting servers

Then I had checked again the issue resolved.

Tuesday 6 April 2021

ORA-27102: out of memory Linux-x86_64 Error: 28: No space left on device Error

 Yesterday when i am doing RMAN cloning to a different server then i got below error:

ORA-27102: out of memory Error: 

RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
RMAN-04014: startup failed: ORA-27102: out of memory
Linux-x86_64 Error: 28: No space left on device
Additional information: -67108864
Additional information: 1

Solution:
Check the page size:
#getconf PAGE_SIZE
4096
Check the shmall value:
#cat /proc/sys/kernel/shmall
2097152
 
Calculate proper value for shmall:
The value of shmall should be:
Shmall=total size of the SGAs on the system/page size.
Let’s assume the size of the SGA is 16GB in the system then it would be 1024*1024*1024*16 /4096 = 4194304
 
Change shmall in /etc/sysctl.conf
vi /etc/sysctl.conf   
kernel.shmall = 4294967296
Apply the changes:
# sysctl -p  
check shmall value after change
# sysctl -A | grep shmall
4294967296

The solution was to increase kernel.shmall from 2097152(default value) (as it is in the install doc for oracle 10h and oracle 11g) to 4194304. Probably is better to leave the RHEL5 default which is 4294967296.