How to Install ORDS 3.0.9.348.07.16

Things to check first.

1. check you init.ora file has an entry remote_login_passwordfie.
2. loin into sql and check your param at sql prompt show param remote_login.
3. create orapwSID file, It should locate ORACLE_HOME/dbs
4. select * from v$pwfile_users. you will get one row selected.
5 . Refer ORACLE TEST Data Services Install and config Guide E56293-11

/uo1/scratch/ords

webserver$/u01/product/jdk80121/bin/java -jar test_ebs.war install advanced

This Oracle REST Data Services instance has not yet been configured.

Please complete the following prompts

Enter the location to store configuration data:/u01/scratch/ords/config

Enter the name of the database server [localhost]:servername

Enter the database listen port [1521]:0000

Enter 1 to specify the database service name, or 2 to specify the database SID [1]:2

Enter the database SID [xe]:SID

Enter 1 if you want to verify/install Oracle REST Data Services schema or 2 to skip this step [1]:

Enter the database password for ORDS_PUBLIC_USER:

Confirm password:

Please login with SYSDBA privileges to verify Oracle REST Data Services schema.

Enter the username with SYSDBA privileges to verify the installation [SYS]:

Enter the database password for SYS:

Confirm password:

Enter the default tablespace for ORDS_METADATA [SYSAUX]:    

Enter the temporary tablespace for ORDS_METADATA [TEMP]:

Enter the default tablespace for ORDS_PUBLIC_USER [SYSAUX]:

Enter the temporary tablespace for ORDS_PUBLIC_USER [TEMP]:

Enter 1 if you want to use PL/SQL Gateway or 2 to skip this step.

If using Oracle Application Express or migrating from mod_plsql then you must enter 1 [1]:

Enter the PL/SQL Gateway database user name [APEX_PUBLIC_USER]:XXX_ORDS

Enter the database password for XXX_ORDS:

Confirm password:

Enter 1 to specify passwords for Application Express RESTful Services database users (APEX_LISTENER, APEX_REST_PUBLIC_USER) or 2 to skip this step [1]:2

May 26, 2017 12:51:26 PM 

INFO: Updated configurations: defaults, apex, apex_pu

Installing Oracle REST Data Services version 3.0.9.348.07.16

... Log file written to /apps2/scratch/ords/logs/ords_install_core_2017-05-26_125126_00397.log

... Verified database prerequisites

... Created Oracle REST Data Services schema

... Created Oracle REST Data Services proxy user

... Granted privileges to Oracle REST Data Services

... Created Oracle REST Data Services database objects

... Log file written to /u01/scratch/ords/logs/ords_install_datamodel_2017-05-26_125148_00039.log

Completed installation for Oracle REST Data Services version 3.0.9.348.07.16. Elapsed time: 00:00:23.509

Enter 1 if you wish to start in standalone mode or 2 to exit [1]:2

$

Verify your configuration directory

$/u01/product/jdk80121/bin/java -jar test_ebs.war configdir      

May 26, 2017 12:55:07 PM 

INFO: The config.dir value is /u01/scratch/ords/config

Depoly war file in weblogic

ORA-28040

In sqlnet.ora 

SQLNET.allowed_logon_version=10

It cause an error ORA-28040

Enter user-name:

ERROR:

ORA-28040: No matching authentication protocol

How to extract Private key from wallet

openssl pkcs12 -in /home/oracle/wallet/ewallet.p12 -nocerts -out private_key.pem




Enter Import Password:

MAC verified OK

Enter PEM pass phrase:

Verifying - Enter PEM pass phrase:

The first password that openssl asks (Enter Import Password) is the wallet password.

The other password (Enter PEM pass phrase) is used to protect the exported key.

ERROR: ORA-28009:

I was try to connect sys to dba. It gives an error

set your profile.
 update your initSID.ora file 
as O7_DICTIONARY_ACCESSIBILITY=TRUE 

shutdown db
startup pfile= 'pfile location'

sqlplus sys/xxxx
connected.

Remote password file

Source your db profile . .SID

enter orapwd

Usage: orapwd file= entries= force= ignorecase= nosysdba=

  where

    file - name of password file (required),

    password - password for SYS will be prompted if not specified at command line,

    entries - maximum number of distinct DBA (optional),

    force - whether to overwrite existing file (optional),

    ignorecase - passwords are case-insensitive (optional),

    nosysdba - whether to shut out the SYSDBA logon (optional Database Vault only).

   

  There must be no spaces around the equal-to (=) character.

orapwd file=$ORACLE_HOME/dbs/orapw$ORACLE_SID entries=5 force=y ignorecase=y nosysdba=n

Enter password for SYS:xxxxxxx

after completed.

you can see the orapwSID file find in ORACLE_HOME/dbs/orapwSID

shutdown your database   and add the entry in your initSID.ora

remote_login_passwordfile='EXCLUSIVE'

to check 
select * from v$pwfile_users;

Reconfigurating wLS domain 12.2.1 - decreases the time

2. Caution: Once the domain reconfiguration process starts, it is irreversible. Prior to using the Reconfiguration Wizard or WLST to upgrade the domain, ensure that you have backed up the domain. If an error or other interruption occurs during the reconfiguration process, you must restore the domain by copying the files and directories from the backup location to the original domain directory. This is the only way to ensure that the domain has been returned to its original state prior to reconfiguration.
3. Set the CONFIG_JVM_ARGS environment variable to the following value to use the operating system's random number generator:
   -Djava.security.egd=file:/dev/./urandom
   This decreases the amount of time it takes for the Reconfiguration Wizard to reconfigure a domain.

4. export CONFIG_JVM_ARGS=-Djava.security.egd=file:/dev/./urandom

how to check your ssl connection from unix server

openssl s_client -connect (url) example: xxx.xxx.com:1223