Installation Guide for P6 Professional Primavera R15.1

Installation Guide for P6 Professional Primavera R15.1 About This Document This document table about how to install and configure P6 Professional Primavera R15.1. Read this section to install P6 Professional. Run the Setup wizard on the...

Check services running on port on linux

[oracle@ptud1 ~]$ netstat -an | grep "1521"tcp        0      0 127.0.0.1:41247             127.0.0.1:1521              ESTABLISHED tcp        0     ...

java.lang.OutOfMemoryError: PermGen space

On 64 bit platforms, the MaxPermSize should be set to 512M. Before launching the Installer, you can set the MaxPermSize in the environment as follows: export _JAVA_OPTIONS=-XX:MaxPermSize=512m If the MaxPermSize is not set to 512M, you will see the following error message: java.lang.OutOfMemoryError: PermGen spa...

Ora-04031 Unable to allocate nn bytes of shared memory

1 ps -ef|grep oracle2 find the smon and kill the pid for it3 SQL> startup mountORACLE instance started.Total System Global Area 4831838208 bytes Fixed Size 2027320 bytes Variable Size 4764729544 bytes Database Buffers 50331648 bytes Redo Buffers 14749696 bytes Database mounted. SQL>4 SQL> alter system set shared_pool_size=100M scope=spfile;System altered.5 SQL>...

ORA-19809: limit exceeded for recovery files ORA-19804: cannot reclaim 35536384 bytes disk space from 4781506560 limit

Cause: When use db_recovery_file_dest for archive log destination and the size given to it is full. Check both parameters using following command. SQL> show parameter db_recovery_file_dest NAME                                ...

ORA-00838: Specified value of MEMORY_TARGET is too small, needs to be at least 3072M – Oracle 12c

Cause: Existing MEMORY_TARGET value not enough to start database. Solution: Increase MEMORY_TARGET value. Consider following workaround: [oracle@12c bin]$ sqlplus “/ as sysdba” SQL*Plus: Release 12.1.0.1.0 Production on Mon Jun 9 11:15:45 2014 Copyright (c) 1982, 2013,...

ORA-00845: MEMORY_TARGET not supported on this system

This error pops up due to we are using Automatic Memory Management (AMM) feature of Oracle 11g R2 on shared memory filesystem (shmfs) which is found less than required. Solutions for the mentioned error: Increase value of oracle parameter: ‘memory_max_target’ & ‘memory_target’...

MySQL - Resetting a lost MySQL root password

Not the Server root user A common issue is confusing the Server root user with the MySQL root user. The Server root user is the server's main user. The MySQL root user has complete control over MySQL only. The two 'root' users are not connected in any way. Stop MySQL The first thing to do is stop MySQL. If you are using Ubuntu or Debian the command is as follows: sudo...

The command line help you fix Oracle error

Dear all! Syntax: oerr ora [Code Err] Example: [oracle@ptud1 ~]$ oerr ora 83800838, 00000, "Specified value of MEMORY_TARGET is too small, needs to be at least %sM"// *Cause: The specified value of MEMORY_TARGET was less than the sum of the // specified values for SGA_TARGET and PGA_AGGREGATE_TARGET.// *Action: Set MEMORY_TARGET to at least the recommended value. We...

How to drop connected users in Oracle database

Solution 1: sql>Shutdown immediate; sql>startup restrict; sql>drop user TEST cascade; If you want to re-activate DB normally either reset the server or : sql>Shutdown immediate; sql>startup; Solution 2: find the sessions for the users/schema , as a DBA use : select sid,serial# from v$session where username = '<user_schema>' Then kill them with :  alter...