JD Edwards: Difference between revisions

From Objectif Client Inc
Jump to navigation Jump to search
Line 63: Line 63:
==Cheat Sheet==
==Cheat Sheet==
===Start-Stop===
===Start-Stop===
Start Listner: under oracle profile: <pre>lsnrctl start</pre>
*Start Listner: under oracle profile:  
Start Dabase: under oracle profile:
<pre>lsnrctl start</pre>
*Start Dabase: under oracle profile:
<pre>
<pre>
sqlplus /nolog
sqlplus /nolog
SQL> connect sys/admin as sysdba;
SQL> connect sys/admin as sysdba;
SQL> startup
SQL> startup;
</pre>  
</pre>  
===Ports===
===Ports===

Revision as of 19:36, 16 July 2015


Enterprise Server

Linux Setup

sysctl.conf

/etc/sysclt.conf

net.ipv4.ip_forward=0
###Nr001
fs.file-max=6815744
kernel.sem=1024 32000 100 142
kernel.shmmni=4096
kernel.shmall=1073741824
kernel.shmmax=4398046511104
net.core.rmem_default=262144
net.core.rmem_max=4194304
net.core.wmem_default=262144
net.core.wmem_max=1048586
fs.aio-max-nr=1048576
net.ipv4.ip_local_port_range=9000 65500

/etc/security/limits.conf

oracle soft nproc 2047 
oracle hard nproc 16384 
oracle hard nofile 65536 
oracle soft nofile 1024 

Oracle Setup

  • To enable remote connections for your Oracle database

Edit the init.ora file, and set the remote condition by adding this line:

REMOTE_LOGIN_PASSWORDFILE=SHARED

ELFCLASS64

libclntsh.so.11.1: wrong ELF Class: ELFCLASS64: No such file or directory

  • Create directory lib32 inside ORACLE_HOME (/u1/app/oracle/product/11.2.0/db_home)
  • Download Oracle Client 32bit Linux
  • Copy libclntsh.so.11.1 and libnnz11.so into lib32
  • Validate the path of jde910 (echo $PATH)

Enterprise Install

Name:

 JDE_PPack910_Home_1

Path:

/u01/jdedwardsppack/e910_1

Error

Linux 6 (oracle) ..jre/lib/i386/xawt/libmawt.so: libXext.so.6: cannot open shared object file: No such file or directory -> Install LibXext-1.3.2-2.1.el6.i686 yum install

..jre/lib/i386/xawt/libmawt.so: libXtst.so.6: cannot open shared object file: No such file or directory -­> Install LibXtst-1.2.2-2.1.el6.i686 yum install

Cheat Sheet

Start-Stop

  • Start Listner: under oracle profile:
lsnrctl start
  • Start Dabase: under oracle profile:
sqlplus /nolog
SQL> connect sys/admin as sysdba;
SQL> startup;

Ports