Manage Tablespaces

Create:
CREATE TABLESPACE DATA05 DATAFILE 'D:\app_db12c\oracle\oradata\orcl\sample01.dbf' SIZE 1M AUTOEXTEND ON NEXT 1M;

Extend:
ALTER TABLESPACE DATA05 ADD
  DATAFILE 'D:\app_db12c\oracle\oradata\orcl\sample02.dbf' SIZE 1M
  AUTOEXTEND ON NEXT 1M;

Delete:
DROP TABLESPACE DATA05 INCLUDING CONTENTS AND DATAFILES;

SQLPLUS command to start oracle pdbs

sqlplus sys/xxxxx as sysdba@pdborcl.xxxx.com

SQL*Plus: Release 12.1.0.2.0 Production on Fri Nov 4 12:07:01 2016

Copyright (c) 1982, 2014, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> SELECT name,open_mode from v$pdbs ORDER BY name;

NAME                           OPEN_MODE
------------------------------ ----------
PDB$SEED                       READ ONLY
PDBORCL                        MOUNTED

SQL> alter pluggable database pdborcl open read write;

Pluggable database altered.

SQL> SELECT name,open_mode from v$pdbs ORDER BY name;

NAME                           OPEN_MODE
------------------------------ ----------
PDB$SEED                       READ ONLY
PDBORCL                        READ WRITE

SQL>

How to modify vncveiwer settings on Windows 7?

To modify VNC Viewer/Server setting:-

1. Start -> regedit  to open Registry Editor
2. Navigate to HKEY_CURRENT_USER -> Software -> RealVNC  -> vncviewer
3. Select 'vncviewer' and modify ColorLevel to full to resolve 'Bad ColourLevel' while opening VNC Viewer.

NodeJS express security

app.use(session( {

httpOnly: true, // don't let browser javascript access cookies ever
secure: true, // only use cookies over https
ephemeral: true // delete this cookie when the browser is closed.

)});

EM Configuration issue.

bash-4.1$ emctl
EM Configuration issue. /opt/usr01/app/usr01/product/11.2.0/dbhome_1/<hostname>_orcl not found.

For above error saying missing _orcl directory, search for _orcl folder in your /opt/usr01/app/usr01/product/11.2.0/dbhome_1 and set the actual required hostname to ORACLE_HOSTNAME (typically It would be localhost)

bash-4.1$ export ORACLE_HOSTNAME=localhost
bash-4.1$ emctl (now works fine)
Oracle Enterprise Manager 11g Database Control Release 11.2.0.3.0
Copyright (c) 1996, 2011 Oracle Corporation.  All rights reserved.
   Oracle Enterprise Manager 10g Database Control commands:
        emctl start | stop dbconsole
        emctl status | secure | setpasswd dbconsole
        emctl config dbconsole -heap_size <size_value> -max_perm_size <size_value>
       emctl status agent
       emctl status agent -secure [-omsurl <http://<oms-hostname>:<oms-unsecure-port>/em/*>]
       emctl getversion
       emctl reload | upload | clearstate | getversion agent
       emctl reload agent dynamicproperties [<Target_name>:<Target_Type>]....
       emctl config agent <options>
       emctl config agent updateTZ
       emctl config agent getTZ
       emctl resetTZ agent
       emctl config agent credentials [<Target_name>[:<Target_Type>]]
       emctl gensudoprops
       emctl clearsudoprops
 Blackout Usage :
       emctl start blackout <Blackoutname> [-nodeLevel] [<Target_name>[:<Target_Type>]].... [-d <Duration>]
       emctl stop blackout <Blackoutname>
       emctl status blackout [<Target_name>[:<Target_Type>]]....

Generate a Self Signed Certificate using Java Keytool

Run the following command to Generate a Self Signed Certificate using Java Keytool

keytool -genkey -keyalg RSA -alias selfsigned -keystore keystore.jks -storepass password -validity 360 -keysize 2048





Java EE 6 Web Services Developer Certified Expert

Exam Number: 1Z0-897 Associated Certifications: Oracle Certified Expert, Java EE 6 Web Services Developer Exam Product Version: Java EE

Duration: 90 minutes Number of Questions: 55 Passing Score: 65% View passing score policy Validated Against: format: Multiple Choice

Exam Topics:-

  Assume the following:

• Missing package and import statements: If sample code do not include package or import statements, and the question does not explicitly refer to these missing statements, then assume that all sample code is in the same package, and import statements exist to support them.
• No file or directory path names for classes: If a question does not state the file names or directory locations of classes, then assume one of the following, whichever will enable the code to compile and run:
  • All classes are in one file
  • Each class is contained in a separate file, and all files are in one directory
• Unintended line breaks: Sample code might have unintended line breaks. If you see a line of code that looks like it has wrapped, and this creates a situation where the wrapping is significant (for example, a quoted String literal has wrapped), assume that the wrapping is an extension of the same line, and the line does not contain a hard carriage return that would cause a compilation failure.
• Code fragments: A code fragment is a small section of source code that is presented without its context. Assume that all necessary supporting code exists is present and that the supporting environment fully supports the correct compilation and execution of the code shown and its omitted environment.
• Descriptive comments: Take descriptive comments, such as "setter and getters go here," at face value. Assume that correct code exists, compiles, and runs successfully to create the described effect.

TOPICS

• Create an SOAP web service in a servlet container
• Create a RESTful web service in a servlet container
• Create a SOAP based web service implemented by an EJB component
• Create a RESTful web service implemented by an EJB component
• Configure JavaEE security for a SOAP web service
• Create a web service client for a SOAP based web service
• Create a web service client for a RESTful web service
• Create a SOAP based web service using Java SE platform
• Create handlers for SOAP web services
• Create low-level SOAP web services
• Use MTOM and MIME in a SOAP web service
• Use WS-Addressing with a SOAP web service
• Configure Message Level security for a SOAP web service
• Apply best practices to design and implement web services