Tuesday 17 March 2015

Apache error

Network message format error. Unable to parse browser environment or content item. Unable to parse properties. Name-value pair 'GET / HTTP/1.1' is missing an equal sign (=).

This means there are two virtualhost's with the same servername

#bearMan

WLSTException: Error occured while performing nmConnect

Connecting to Node Manager ...
Traceback (innermost last):
  File "<console>", line 1, in ?
  File "<iostream>", line 123, in nmConnect
  File "<iostream>", line 648, in raiseWLSTException
WLSTException: Error occured while performing nmConnect : Cannot connect to Node Manager. : Access to domain 'Domain' for user 'user' denied

The solution I have is:
find this file, under your Domain Directory:

locate nm_password.properties

cd to the correct path

then
mv nm_password.properties nm_password.properties.BAK

vi nm_password.properties

username=myAdminUserName
password=MyPassword

eg:
username=weblogic
password=welcome1

This will get encrypted. To force the encryption

use wlst.sh to connect to the Domain with the new credentials.

#bearMan


Friday 13 March 2015

XATRANS Views are not installed on this Database

Error

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Error:  XATRANS Views are not installed on this Database. This is required by the OIM Schema
Action: Install view XAVIEWS as SYS user on this Database.
Refer to the Oracle Database Release Documentation for installation details.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

at oracle.sysman.assistants.rcu.backend.task.PrereqTask.execute(PrereqTask.java:76)
at oracle.sysman.assistants.rcu.backend.task.ActualTask.run(TaskRunner.java:306)
at java.lang.Thread.run(Thread.java:662)

Solution

If you dont know where the install is:

locate xaview.sql

Then:

ssh to the server
cd dbhome_1/rdbms/admin/
sqlplus / as sysdba
@xaview.sql


#bearMan

Tuesday 10 March 2015

TablespaceFreeMB Prerequisite failure

RCU-6108:DB TablespaceFreeMB Prerequisite failure for: IDMTST_OIM
Current space is 35MB. It should be be greater than 50MB.

There are two solutions:
Set the tablespace to automatically increase in size, or increase the size.

First option:
ALTER DATABASE DATAFILE  AUTOEXTEND ON ;

Second Option:
ALTER TABLESPACE  ADD DATAFILE '' SIZE nG AUTOEXTEND ON MAXSIZE XXG;

#bearMan

Friday 6 March 2015

Oracle Database TableSpace

View where the tablespaces are located:

select file_name from dba_data_files where tablespace_name='USERS';

View the tablespace size of a tablespace:

select sum(bytes/1024/1024/1024),sum(maxbytes/1024/1024/1024) from dba_data_files where tablespace_name='USERS';

View if the tablespace is auto extendable:

select AUTOEXTENSIBLE from dba_data_files where tablespace_name='USERS';

Explain the Database Table for Tablespace:

desc dba_data_files

#bearMan