Guru Of Geeks

​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

$ 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 ​

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

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@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 ...

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 : 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=...