Posted on

Beginning Oracle WebCenter Portal 12c book– Published!!

15027775_1265334893487331_5199818658147986314_n

bookbb

This book is intended for beginners,expert and software architects, project manager , who are working with WebCenter Portal implementation.Somebody wants to developer rich enterprise portal with WebCenter Portal with WebCenter content and other technologies. Little bit ADF knowledge required.

http://www.apress.com/gp/book/9781484225318

amazon

Chapter 1 : Introduction to Enterprise Portals – Introduction of Enterprise portal. Portal vs website and introduction of Oracle FMW.

Chapter 2 : Introduction to Oracle WebCenter Portal 12c – First chapter to talk about WebCenter portal. Architecture of portal, Main components of WebCenter Portal.New Features and deprecated features of WebCenter portal 12c.

Chapter 3 : Oracle WebCenter Portal12c Administration – How to do administration of WebCenter Portal. Normal task for WebCenter Portal administrator. etc.

Chapter 4 : Portal Asset Development – How to set developer environment for Portal Asset development.How to portal asset publishing.How to develop portal asset runtime.

Chapter 5 : Working with Pages and Navigation – What Is a Page? Working with System and business Pages. how to Working with Personal and portal Pages,Rendering a Portal Navigation.

Chapter 6 : Extend Portal with Shared Libraries– What Are Shared Libraries? You will learn how to deploy nd develop WebCenter Portal Shared Library.explains Development Life Cycle with example.

Chapter 7 : WebCenter Portal Task Flow Customization– Overview of customization, How to do taskflow customization on design and run time.Setting Up a Customizable WebCenter Portal Application. Customizing WebCenter Portal Task Flows of Design Time Customization,Deployment of Customized WebCenter Portal Task Flow.

Chapter 8 : Portlets Integration Using JSR 286 – What is portlet, What is use of it. Learn when to use portlet and taskflow. Learn to create Portlet. How to convert adf taskflow into portlet.Build JSR 286 portlet and deploy in WCP.

Chapter 9 : Creating Pagelet Producer – Learn about Pagelet Producer Architecture.Creating Pagelet Producer Resource .Pagelets in WebCenter Portal.How to add content in pagelet using Web Injector.Know how to add pagelet using javascript and REST API.

Chapter 10 : Portal Security Administration – Learn Security Architecture.Understanding WebCenter Portal Security.Using Enterprise Manager for Security Administration UI,learn Using of WebCenter Portal Security Administration UI.Securing Page Components.

Chapter 11 : Content Integration – Learn to integrate WebCenter Content,Publishing Content via WebCenter Content Integration,Learn Integration with Oracle Document Cloud. Publishing Content Using Pages,Publishing Content Using Data Presenter,Publishing Content: Blogs nd wikis.

Chapter 12 : Portal Tools and Services – Learn Webcenter portal Analytics,Announcements and Discussions,External Applications. Learn on how to work on Events, Instant Messaging and Presence, links, list, mail,People connections, Notes, Notification, RSS, search and tags.

Chapter 13 : Extending WebCenter Portal – Learn how to integrate WebCenter Portal with all third party application for example, EBS, OBIEE etc. Learn how to use portal REST API and WebCenter Portal Java API.

So now horn up your ADF skills to learn WebCenter Portal.

Happy Learning with Vinay….

Posted on

ORA-01078: failure in processing system parameters LRM-00109: could not open parameter file-Fixed

Requirement- When starting up database following occurs:SQL> startup
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file ‘/opt/oracle/product/11.2.0/dbhome_1/dbs/inittest01.ora’

I have faced this problem , while setting up an new image of vmware. I am starting server and i got this error.What does this mean –

Reason-
Database start using spfile (Default). In Unix default path is $ORACLE_HOME/dbs. If spfile is not present it looks for pfile at same path. If pfile is also not present it will give above message.

Implementation- If you have spfie then you can copy default values from spfile to pfile and create pfile.But what if you don’t have spfile.you have to create an pfile

How to create pfile –

When database starts it writes list of non default parameters in alert log files. We can use these values to create a pfile and start the database.

Find you alert log file and open it. This is Database Management Software Oracle 11g, Here you will see entry like this:

System parameters with non-default values:
processes = 150
sga_target = 512M
control_files = “/opt/oracle/test01/dbs/control01.ctl”
control_files = “/opt/oracle/test01/dbs/control02.ctl”
control_files = “/opt/oracle/test01/dbs/control03.ctl”
db_block_size = 8192
compatible = “10.2.0.1.0”
log_archive_dest_1 = “LOCATION=/opt/oracle/test01/archive”
log_archive_dest_state_1 = “ENABLE”
log_archive_format = “%t_%s_%r.dbf”
log_archive_max_processes= 10
log_checkpoint_interval = 9999
log_checkpoint_timeout = 0
db_file_multiblock_read_count= 16
db_recovery_file_dest = “/opt/oracle/test01/flash_recovery_area”
db_recovery_file_dest_size= 2G
undo_management = “AUTO”
undo_tablespace = “UNDOTBS1”
remote_login_passwordfile= “EXCLUSIVE”
db_domain = “agilis.com”
job_queue_processes = 32
core_dump_dest = “/opt/oracle/test01/diag/cdump”
audit_file_dest = “/opt/oracle/test01/adump”
open_links = 10
db_name = “test01”
open_cursors = 500
optimizer_index_cost_adj = 20
optimizer_index_caching = 90
pga_aggregate_target = 128M
diagnostic_dest = “/opt/oracle/test01/diag”
Tue May 31 10:55:29 2011
PMON started with pid=2, OS id=4675

Create pfile using these values:

[[email protected]]$ cd /opt/oracle/product/11.2.0/dbhome_1/dbs/
[[email protected]]$ vi inittest01.ora
Copy non default parameter values from alert log in this file and save it. This is your pfile, Start the database using this pfile.

Start the Database using Pfile:

[[email protected] dbs]$ export ORACLE_SID=test01
[[email protected] dbs]$ sqlplus sys as sysdba
SQL*Plus: Release 11.2.0.2.0 Production on Fri Jun 24 15:53:16 2011
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Enter password:
Connected to an idle instance.
SQL> startup pfile=’$ORACLE_HOME/dbs/inittest01.ora’
ORACLE instance started.
Total System Global Area 534462464 bytes
Fixed Size 2228200 bytes
Variable Size 163577880 bytes
Database Buffers 360710144 bytes
Redo Buffers 7946240 bytes
Database mounted.
Database opened.
SQL>

Create spfile from pfile:

SQL> create spfile from pfile=’$ORACLE_HOME/dbs/inittest01.ora’;
File created.

Shutdown the database and restart it will use spfile (Default) and problem is solved. I have also published a list of SPFILE Commands.

Happy coding with Vinay Kumar in techartifact….

Posted on

Finding location of alert.log in Oracle

Requirement-Finding location of alert.log in Oracle

You can try this

SQL> select * from v$version;

BANNER
——————————————————————————–
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 – 64bit Production
PL/SQL Release 11.1.0.7.0 – Production
CORE 11.1.0.7.0 Production
TNS for Linux: Version 11.1.0.7.0 – Production
NLSRTL Version 11.1.0.7.0 – Production

SQL> show parameter background

NAME TYPE VALUE
———————————— ———– ——————————
background_core_dump string partial
background_dump_dest string /oracle/app/oracle/diag/rdbms/PROD/PROD/trace

SQL> !ls -ltr /oracle/app/oracle/diag/rdbms/PROD/PROD/trace/al*
-rw-r—– 1 oracle oinstall 78512424 2011-10-03 02:00 /oracle/app/oracle/diag/rdbms/PROD/PROD/trace/alert_PROD.log

OR before running this query you can check on this location

/u01/app/oracle/diag/rdbms/repo/REPO/trace

Happy learning with Vinay Kumar in techartifact