Posts

Showing posts from April, 2016

How to enable ssh root access on Ubuntu 14.04

​Set the password for root account and followed by below step.​ You also need to edit   /etc/ssh/sshd_config , and comment out the following line: PermitRootLogin without-password Just below it, add the following line: PermitRootLogin yes Then restart SSH: service ssh restart

Create a swap space using file in RHEL or Centos

$ sudo dd if=/dev/zero of=/swapfile bs=1M count=1024 $ sudo mkswap /swapfile $ sudo chmod 600 /swapfile $ sudo swapon /swapfile $ sudo vim /etc/fstab Add this line to fstab: swap /swapfile swap defaults 0 0 ​

Installing compat-libstdc++-33 on RHEL 7 AWS EC2

You need to enable the RHEL optional and/or extras channels. yum-config-manager --enable rhui-REGION-rhel-server-extras rhui-REGION-rhel-server-optional

log Files location in OBIEE 12c

File Locations: 11g: Upgrade log:  Middleware\Oracle_BI1\upgrade\logs Admin Server log files:  [MW_HOME]\user_projects\domains\bifoundation_domain\servers\AdminServer\logs Managed Server log files:  [MW_HOME]\user_projects\domains\bifoundation_domain\servers\bi_server1\logs BI Server log files: [MW_HOME]\instances\instance1\diagnostics\logs\OracleBIServerComponent\coreapplication_obis1 Presentation Server log file: [MW_HOME]\instances\instance1\diagnostics\logs\OracleBIPresentationServicesComponent\coreapplication_obips1 12c: Upgrade log:  ORACLE_HOME\user_projects\domains\bi\servers\obips1\logs Admin Server log files: ORACLE_HOME\user_projects\domains\bi\servers Managed Server log files:  ORACLE_HOME\user_projects\domains\bi\servers BI Server log files: ORACLE_HOME\user_projects\domains\bi\servers\obis1\logs Presentation Server log file: ORACLE_HOME\user_projects\domains\bi\servers\obips1\logs

Oracle 12c - need to start container AND pluggable databases automatically.

[oracle@rac1 lib]$ sqlplus / as sysdba SQL*Plus: Release 12.1.0.1.0 Production on Thu Jun 27 14:47:35 2013 Copyright (c) 1982, 2013, Oracle.  All rights reserved. Connected to an idle instance. SQL> startup ORACLE instance started. Total System Global Area 1653518336 bytes Fixed Size                  2289016 bytes Variable Size             989856392 bytes Database Buffers          654311424 bytes Redo Buffers                7061504 bytes Database mounted. Database opened. But then we find that the Pluggable Databases (PDBs) are still in "MOUNTED" state, so we will need to open them before we can login. SQL> select name, open_mode from v$pdbs; NAME                           OPEN_MODE ------------------------------ ---------- PDB$SEED                       READ ONLY PDB1                           MOUNTED PDB2                           MOUNTED PDB3                           MOUNTED From CDB$ROOT we can manage ...

How to install MySQL 5.5 on Ubuntu

I have been beating my head against the wall for almost a year now, trying to figure out how to install MySQL 5.5 on Ubuntu since there is still not a .deb package to use. OpenDental software makes use of MySQL as it's database and since my servers have always run Ubuntu, I didn't really want to switch to an RPM based distro and have to learn new tricks for that system just for this reason. MySQL 5.1 was giving off and on errors and the time had come that I to either get it to work or ditch Ubuntu for and RPM based distro (probably OpenSuse/Fedora/Mandriva). Finally, after trying it seems like twenty or thirty tutorials on the net and having problem at one point or another with all of them, I succeeded and got MySQL 5.5.14 running on Ubuntu 11.04 "lucid!" If you follow the steps below from a standard Ubuntu/MySQL LAMP server install, you should be able to have a working v5.5 server in no time! (help from this thread: https://code.launchpad...

To update root user privileges in mysql using workbench :

To update root user privileges in mysql using workbench : 1)connect the database using root user 2) Run the query to off the safe updates in workbench set sql_safe_updates=0; 3) Run the below query to update the user privileges in mysql database update mysql.user set Select_priv='Y', Insert_priv='Y',Update_priv='Y',Delete_priv='Y',         Create_priv='Y',Drop_priv='Y',Reload_priv='Y',Shutdown_priv='Y',         Process_priv='Y',File_priv='Y',Grant_priv='Y',References_priv='Y',         Index_priv='Y',Alter_priv='Y',Show_db_priv='Y',Super_priv='Y',         Create_tmp_table_priv='Y',Lock_tables_priv='Y',Execute_priv='Y',         Repl_slave_priv='Y',Repl_client_priv='Y',Create_view_priv='Y',         Show_view_priv='Y',Create_routine_priv='Y',Alter_routine_priv='Y',         Create_user_priv=...

InfoSphere Information Governance Catalog import failed with message "An error occurred on . "

Problem(Abstract) InfoSphere Information Governance Catalog (IGC) Import failed with message "An error occurred on <timestamp>. Further details may be found in the server logs or browser console", but no error is displayed in the igc.log file Symptom InfoSphere Information Governance Catalog Import displays at the end of the import the message "An error occurred on <timestamp>. Further details may be found in the server logs or browser console" as "Import Summary", but the assets (Categories, Terms , ...) were imported. Cause To prevent cross-frame scripting attacks, the value of the com.ibm.iis.gov.xFrameOptions could be set to 'DENY'. This value cause this error message at the end of the import, in spite of import ended successfully. Unfortunately, this value ('DENY') was previously recommended by the documentation for the configuration of InfoSphere Inf...

IBM InfoSphere Information Server SystemOut.log file is rapidly filled with PooledConnection errors

Problem(Abstract) In Information Server, when the XMETA database goes down, the SystemOut log file is rapidly filled with WebSphere Application Server error messages. In a High Availability environment, this could happen when database fail over takes place. Symptom The SystemOut log file is rapidly filled with WebSphere Application Server ResourceAllocationException error messages similar to the following: PoolManager   E   J2CA0046E: Method executeTestConnectionTask caught an exception during creation of the ManagedConnection for resource jdbc/ASBDataSource, throwing ResourceAllocationException. Original exception: <=================================>Exception Message -> DSRA8100E: Unable to get a PooledConnection from the DataSource jdbc/ASBDataSource. Cause The problem occurs when the database is down because of the settings for two properties in the WebSphere Application server configuration for Da...