Forwarding Network

Describe: End User cannot access Server B via port 8000. End User can access Server A via port 8000. How to End User can access application on Server B which running port 8000? Before Forwarding, end user cannot access via 8000. Details: 1. Check Port Forwarding: ...

Enable Framework folders for WCCC (Oracle Content Repository)

Step 1: Access Oracle Content Repository via Web Browser Step 2: Click Login, enter username and password Step 3: On Administration, click + plus button on Admin Server, select Component Manager Step 4: On Component Manager click advanded component manager. Step...

create an user OS which has privilege like root user

I will create user "bigdata" which has privilege like root user [root@PTUD-VM02-4 ~]# chmod 640 /etc/sudoers [root@PTUD-VM02-4 ~]# vi /etc/sudoers ## Allow root to run any commands anywhere root    ALL=(ALL)       ALL bigdata    ALL=(ALL)       ALL [root@PTUD-VM02-4 ~]# chmod 440 /etc/sudoers ...

Adding User on linux

[root@PTUD-VM01-2 ~]# df -h Filesystem            Size  Used Avail Use% Mounted on /dev/mapper/vg_ptudvm011-LogVol00                        20G  8.5G   11G  46% / tmpfs                 7.8G   72K  7.8G   1% /dev/shm /dev/sda1...

How to dump file ( export and import) on pluggable database

1. Check listener [oracle@PTUD-SingleSignOn ~]$ lsnrctl status LSNRCTL for Linux: Version 12.1.0.1.0 - Production on 09-SEP-2015 17:57:36 Copyright (c) 1991, 2013, Oracle.  All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521))) STATUS...

ORA-00059: maximum number of DB_FILES exceeded

Problem [oracle@PTUD-SingleSignOn oradata]$ oerr ora 59 00059, 00000, "maximum number of DB_FILES exceeded" // *Cause:  The value of the DB_FILES initialization parameter was exceeded. // *Action: Increase the value of the DB_FILES parameter and warm start. Solution: [oracle@PTUD-SingleSignOn oradata]$ sqlplus / as sysdba SQL*Plus: Release 12.1.0.1.0 Production on Wed Sep...

ORA-00847: MEMORY_TARGET/MEMORY_MAX_TARGET and LOCK_SGA cannot be set together

Problem: [oracle@PTUDServer3 ~]$ sqlplus / as sysdba SQL*Plus: Release 12.1.0.1.0 Production on Tue Sep 8 17:48:32 2015 Copyright (c) 1982, 2013, Oracle.  All rights reserved. Connected to an idle instance. SQL> startup ORA-00847: MEMORY_TARGET/MEMORY_MAX_TARGET and LOCK_SGA cannot be set together SQL> exit Disconnected Solution: [oracle@PTUDServer3 dbs]$ pwd /u01/app/oracle/product/12.1.0/db_1/dbs [oracle@PTUDServer3...

Disable TDE in Oracle Privileged Account Manager Data Store

export ORACLE_HOME=/home/omss/fmw/Oracle_IDM1 export ANT_HOME=/home/omss/fmw/modules/org.apache.ant_1.7.1 export JAVA_HOME=/home/omss/setup/jdk export ANT_OPTS="-Xmx512M -XX:MaxPermSize=512m" $ORACLE_HOME/opam/bin/opam.sh -url https://192.168.2.149:18102/opam -x modifyglobalconfig -propertyname tdemode -propertyvalue false -u weblogic -p your_passwo...

Columns are encrypted but TDE wallet is not open

Problem: Columns are encrypted but TDE wallet is not open Solution: create and open the wallet. oracle@PTUDServer3 bin]$ sqlplus / as sysdba SQL*Plus: Release 12.1.0.1.0 Production on Fri Sep 4 16:43:24 2015 Copyright (c) 1982, 2013, Oracle.  All rights reserved. Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production With the Partitioning,...

Connecting to an Oracle Database from a Client Computer

Syntax:"host[:port][/service_name][:server][/instance_name]"• host — the name or IP address of the Oracle database host computer.Both IPv4 and IPv6 addresses are supported. IPv6 addresses must be enclosedin square brackets. See Oracle Database Net Services Administrator's Guide forinformation about IPv6 addressing.• port (optional) — the TCP port number on which the Oracle Net...