To find the Memory Details in AIX

To know the complete memory details the following script can be used to find it:

#!/usr/bin/ksh
#memory calculator
um=`svmon -G | head -2|tail -1| awk {'print $3'}`
um=`expr $um / 256`
tm=`lsattr -El sys0 -a realmem | awk {'print $2'}`
tm=`expr $tm / 1000`
fm=`expr $tm - $um`
echo "\n\n-----------------------";
echo "System : (`hostname`)";
echo "-----------------------\n\n";
echo "Memory Information\n\n";
echo "total memory = $tm MB"
echo "free memory = $fm MB"
echo "used memory = $um MB"
echo "\n\n-----------------------\n";

Database IP address change for integrated Discoverer 11g

If the Database integrated with the Oracle Discoverer is changed, then it will be ending with an error as "The Network Adapter could not establish the connection"

Resolution:

1)  Login into Weblogic console as weblogic user
2) Click Lock and Edit
3) Under Data Sources there will be 2 options

   a) Click each and goto the tab configuration. Under configuration click the Connection pool and change the IP address from OLD to NEW under "URL" and "PROPERTIES".

   b) Make the same changes in another data source with the same navigation and Save

    c) Click the Monitoring tab and the data sources and verify the test is Successful

4) Click "Activate Changes"

5) Restart WLS_DISCO and opmn services. Check the discoverer to access the reports.