Oracle SQL*Developer Plug-in : Insider4Raptor

For Oracle DBA's and Developers...

If you are using a SQL*Developer, there's an interesting plug-in Called Insider4Raptor. This plug-in is a little like Quest Database Monitor, but it's free, just like SQL*Developer.

This product is from www.fourthelephant.com [curious name for a company !!! :) ]

OTN Forum Member Rule

If your're using or administering Oracle Technology, probably are familiarized with OTN (Oracle Technology Network), and its formus. This formus you can find and GIVE solutions. Shay Shmeltzer's Weblog has an intersting post with 10 Rules to follow if you are an OTN Forum Member.

Source: Shay Shmeltzer's Weblog



THIS IS FROM SHAY'S WEBLOG

Five rules to getting a better solution

1. Have a meaningful subject line
I'm tired of seeing a subject line like "I need urgent help". Your subject should specify what the problem core is and in what area

2. Give details about versions and technologies
Are you using JDeveloper 10.1.3.1 or JDeveloper 9.0.4? Are you using ADF BC or EJB?

3. Give detailed error messages
Don't say - it throws an error - tell us what the error is and give the stack trace.

4. If possible provide steps to reproduce the problem
If something doesn't work for you - I can't know why if you don't tell me what you did. Sometime you can even post code that reproduce the problem

5. Search before you post
It's for your own good - it brings you the solution faster. Search both the forum and Google for your question - you'll be surprised how many times you'll find a solution that someone else got.

Five rules to become a better member of the community

6. Get a name
In your forums preferences you can set up a name or handle that will help us recognize you (and even a link to your blog). Do you really want to be known as user5667847? Using your real name is even better - then when someone meets you in a conference or an event - They'll already know who you are.

7. Post the solution
If your issue was solved post the solution on the thread so others that run into the same error can fix it faster. Just writing "I fixed it" doesn't count.

8. Mark solved problems with [Solved]
Once you found a solution to a problem edit the thread and add [SOLVED] to the subject line. This will help people identify solved problems.

9. Track your threads
In your forum preferences check the option that alerts/emails you when your thread has been updated. This way you'll be able to get better response time and also answer follow up questions.

10. Don't just ask question - give some answers as well
The forum is a community - the community will only grow if you'll be an active participant. Posting question is just one side of the coin - actually answering other people questions is even more important. So go ahead and show off the knowledge you have gathered - it is the first step to take if you want to become an Oracle ACE.

50 Acrónimos de SOA (Service Oriented Arquitecture)

Este nuevo producto de Oracle, que en definitiva, puede definirse como OAS pero con aplicaciones incoporadas, tiene una serie de teoría y definiciones que deben internalizarse antes de ingresar a este mundo. En esta tarea me estoy avocando....
Adjunto 50 acrónimos que encontré en este blog.

Para mayor información de SOA recomiendo esta url.

Acronym	Meaning	Description
ADF	Application Development Framework	An end-to-end J2EE framework that simplifies development by providing out of the box infrastructure services and a visual and declarative development experience.
ANT	Another Neat Tool	A software tool for automating software build processes. It is written in the Java language, requires the Java platform, and is best suited to building Java projects.
API	Application Programming Interface	The interface that a computer system, library or application provides in order to allow requests for services to be made of it by other computer programs, and/or to allow data to be exchanged between them.
B2B	Business-to-Business	Referes to automated processes between trading partners.
BAM	Business Activity Monitoring	Solution for building interactive, real-time dashboards and proactive alerts for monitoring business processes and services.
BPA	Business Process Analysis	Solution to perform process modeling & analysis, simulation and publishing of process models.
BPEL	Business Process Execution Language	Enables enterprises to orchestrate disparate applications and Web services into business processes.
DIME	Direct Internet Message Encapsulation	A Microsoft-proposed internet standard for the transfer of binary and other encapsulated data over SOAP.
EAI	Enterprise Application Integration	The uses of software and computer systems architectural principles to integrate a set of enterprise computer applications.
EAR	Enterprise Application aRchive	A way of creating a portable collection of logically related Java 2 Platform, Enterprise Edition (J2EE) components.
EDA	Event-Driven Architecture	Provides the capabilities to easily create, process, analyze, and manage events with limited coding.
EDI	Electronic Data Interchange	The computer-to-computer exchange of structured information, by agreed message standards, from one computer application to another by electronic means and with a minimum of human intervention.
EIS	Enterprise Information System	Any kind of computing system that is of "enterprise class". This means typically offering high quality of service, dealing with large volumes of data - capable of supporting some large organization.
EJB	Enterprise Java Bean	the server-side component architecture for Java Platform, Enterprise Edition (Java EE). EJB technology enables rapid and simplified development of distributed, transactional, secure and portable applications based on Java technology.
ESB	Enterprise Service Bus	Moves data among multiple endpoints. It uses open standards to connect, transform, and route business documents (as Extensible Markup Language (XML) messages), among disparate applications.
J2EE	Java 2 platform, Enterprise Edition	A set of coordinated specifications and practices that together enable solutions for developing, deploying, and managing multi-tier server-centric applications.
JAAS	Java Authentication and Authorization Service	An API that enables Java applications to access authentication and access control services without being tied to those services.
JAR	Java ARchive	A collection of class files packaged with the ZIP file format.
JAXB	Java Architecture for Xml Binding	Provides a convenient way to bind an XML schema to a representation in Java code. This makes it easy for you to incorporate XML data and processing functions in applications based on Java technology without having to know much about XML itself.
JAX-RPC	Java Api for Xml-based RPC	Used to build Web applications and Web services, incorporating XML-based RPC functionality according to the SOAP 1.1 specification.
JCA	Java Connector Architecture	Provides a Java technology solution to the problem of connectivity between the many application servers and today’s enterprise information systems (EIS)
JDBC	Java DataBase Connectivity	An API for the Java programming language that defines how a client may access a database.
JMS	Java Message Service	A messaging standard that allows application components based on the Java 2 Platform, Enterprise Edition (J2EE) to create, send, receive, and read messages.
JNDI	Java Naming and Directory Interface	A part of the Java platform, providing applications based on Java technology with a unified interface to multiple naming and directory services.
JSF	JavaServer Faces	A technology that simplifies building user interfaces for JavaServer applications.
JSP	JavaServer Pages	A Java technology that allows software developers to dynamically generate HTML, XML or other types of documents in response to a Web client request.
JSR	Java Specification Request	Formal documents that describe proposed specifications and technologies to be added to the Java platform.
JTA	Java Transaction Api	Standard Java interfaces between a transaction manager and the parties involved in a distributed transaction system: the resource manager, the application server, and the transactional applications.
LDAP	Lightweight Directory Access Protocol	A networking protocol for querying and modifying directory services running over TCP/IP.
MIME	Multipurpose Internet Mail Extensions	A set of extensions to the Internet Mail standards that supports the inclusion of multi-part and multimedia files, such as sound and video, in e-mail messages.
MVC	Model-View-Controller	A design pattern that decouples data access and business logic from data presentation and user interaction, and introduces an intermediate component: the Controller.
OC4J	Oracle Containers for J2EE	the core J2EE runtime component of Oracle Application Server.
OEMS	Oracle Enterprise Messaging Service	A standards based solution built on the Java Message Service (JMS) and the J2EE Connector Architecture (JCA) which allows customers to develop and integrate distributed applications.
OID	Oracle Internet Directory	An LDAP v3 directory that leverages the scalability, high availability and security features of the Oracle Database.
OPMN	Oracle Process Manager and Notification	OPMN is installed and configured with every Oracle Application Server installation type and is essential for running Oracle Application Server. OPMN enables you manage your Oracle Application Server instance in an hierarchical fashion as part of a cluster topology.
OWSM	Oracle Web Services Manager	Oracle Web Services Manager is a comprehensive solution for adding policy-driven best practices to all your existing or new Web services and provides the key security and management capabilities necessary to deploy Service-Oriented Architectures across your line-of-business applications.
POJO	Plain Old Java Object	The name is used to emphasize that the object in question is not somehow special but an ordinary Java Object, in particular not an EJB
REST	REpresentational State Transfer	An XML-based protocol for invoking Web services over HTTP. REST is a lighter version of SOAP.
RMI	Remote Method Invocation	Provides for remote communication between programs written in the Java programming language.
SOA	Service-Oriented Architecture	An arcitecture that facilitates the development of modular business services that can be easily integrated and reused.
SOAP	Simple Object Access Protocol	A protocol for exchanging XML-based messages over computer network, normally using HTTP.
UDDI	Universal Description Discovery and Integration	A Web-based distributed directory that enables businesses to list themselves on the Internet and discover each other, similar to a traditional phone book’s yellow and white pages.
WAR	Web ARchive	A ZIP file used to distribute a set of Java classes
WSDL	Web Services Description Language	An XML-based language for defining Web services.
WSIF	Web Services Invocation Framework	A simple Java API for invoking Web services, no matter how or where the services are provided.
WSM	Web Services Manager	A comprehensive solution for adding policy-driven best practices to all your existing or new Web services and provides the key security and management capabilities necessary to deploy Service-Oriented Architectures across your line-of-business applications.
XML	eXtensible Markup Language	A meta-language that allows you to completely describe a class of other languages, which in turn describe documents.
XSD	Xml Schema Definition	An XML document that describes the structure of another XML document.
XSL	eXtensible Stylesheet Language	A family of transformation languages which allows one to describe how files encoded in the XML standard are to be formatted or transformed.
XSLT	eXtensible Stylesheet Language Transformation	Software that converts an XML document into another format such as HTML, PDF or text. It may also be used to convert one XML document to another XML document with a different set of XML tags

Acrónimos en Oracle

Los informáticos somos especialistas en crear acrónimos, como, DNS (Domain Name Server), IP (Internet Protocol) y así la lista puede ser infinita...
Para el caso de Oracle RAC (Real Application Cluster ... otro acrónimo), encontré un blog con los 50 mas usados ..

Acrónimos en Oracle


Acrónimos de SOA ...

• RAC (Real Application Clusters) Is Oracle Implementation of Clustered Database Instances.
• CRS (Cluster Ready Services) Oracle's own clusterware tightly coupled with Oracle Real Application Clusters (RAC).
• OCSF (Oracle Cluster File System) Oracle File system Implementation For Linux.
• PCP (Parallel Concurrent Processing) PCP allows concurrent processing activities to be distributed across multiple nodes in an RAC environment, maximizing throughput and providing resilience to node failure.
• OCR (Oracle Cluster Registry) The OCR contains cluster and database configuration information for RAC and Cluster Ready Services (CRS).
• ASM (Automatic Storage Management) Simplifies database administration by enabling you to create disk groups and manage them instead of individual datafiles.
• SSH (Secure Shell) SSH is a set of standards and an associated network protocol that allows establishing a secure channel between a local and a remote computer.
• RSH (Remote Shell) rsh (remote shell) is a command line computer program which can execute shell commands as another user, and on another computer across a computer network.
• DSA (Digital Signature Algorithm) The Digital Signature Algorithm (DSA) is a United States Federal Government standard or FIPS for digital signatures.
• SCSI (Small Computer System Interface) standard interface and command set for transferring data between devices commonly used for interfaces for hard disks, and USB and FireWire connections for external devices.
• NAS (Network-attached storage) Is a dedicated data storage technology that can be connected directly to a computer network to provide centralized data access and storage to heterogeneous network clients.
• NFS (Network Filesystem) is a protocol allows a user on a client computer to access files over a network as easily as if attached to its local disks.
• OSCP (Oracle Storage Compatibility Program) An Oracle Programe To assist third-parties with their Oracle compatibility with respect to storage devices.
• DTP (Distributed Transaction Processing) DTP model is the synchronization of any commits and rollbacks that are required to complete a distributed transaction request.
• VIP (virtual IP Address) is an IP address that is not connected to a specific computer or network interface card (NIC) on a computer.
• TCP/IP ( Transmission Control Protocol (TCP) and the Internet Protocol (IP)
• DNS (Domain Name Server) The domain name system is responsible for translating it translates domain names (computer hostnames) to IP addresses.
• MAC (Media Access Control) Media Access Control address (MAC address) is a unique identifier attached to most network adapters.
• JDBC (Java Database Connectivity) A Java API that allows independent connectivity between the Java programming language and a wide range of databases.
• LB (Load Balancing) Is a technique to balance the load between configured servers.
• FAN (Fast Application Notification) enables end-to-end, lights-out recovery of applications and load balancing when a cluster configuration changes.
• FCF (Fast Connection Failover) Fast Connection Failover provides the ability to failover connections in the connection cache as quickly and efficiently as the database itself.
• TAF (Transparent Application Failover) Using transparent application recovery (TAF), Oracle can automatically reconnect users to the database in the case of instance or node failure.
• OCI (Oracle Call Interface) OCI allows you to develop applications that take advantage of the capabilites of SQL from within the application.
• ODP (Oracle Data Provider) ODP.NET features optimized data access to the Oracle database from a .NET environment.
• ONS (Oracle Names Server) Oracle Names makes network address and database link information available to all nodes throughout the network.
• ORION (Oracle I/O) ORION is a test tool freely available tool which simulates Oracle I/O.
• GSD (Global Services Daemon) The Global Services Daemon (GSD) background process allows usage of Oracle Enterprise Manager or the SRVCTL utility to perform system management tasks.
• NTP (Network Time Protocol) The Network Time Protocol (NTP) is a protocol for synchronizing the clocks of computer.
• CVU (Cluster Verification Utility) CVU is used to verify all the important components that need to be verified at different stages in a RAC environment.
• VSD (Virtual Shared Disk) A Virtual Shared Disk (VSD) facility is a layer of software that allows a processing node to access disk devices physically attached to a remote node as if those devices were attached locally.
• LPARs (Logical Partitions) a Logical Partition, commonly called an LPAR, is a virtualized computing environment abstracted from all physical devices.
• DBCA (Oracle Database Configuration Assistant) An Oracle utility that facilitates the creation and configuration of a database.
• ORACM (Oracle Cluster Manager) allows to add new nodes to an existing cluster without having to stop/start the whole cluster.
• RDA (Remote Diagnostic Agent) An Oracle Diagnostic Tool used in troubleshooting.
• GFS (Global Filesystem) GFS allows a cluster of Linux servers to share data in a common pool of storage.
• NIC (Network Interface Controller) is a piece of computer hardware designed to allow computers to communicate over a computer network.
• LVM (Logical Volume Manager)
• GPFS (General Parrel File System) GPFS is IBM’s high-performance parallel, scalable file system for IBM UNIX clusters.
• HA (High Avaliblity)
• MAA (Maximum Availability Architecture)
• RACDDT (RAC Data Collection Tool) is a data collection tool designed and configured specifically for gathering diagnostic data related to Oracle's Real Application Cluster (RAC) technology.
• OSW (OSWatcher) is an operating system diagnostic utility tool that gathers archival performance data using various native Unix utilities, such as vmstat, iostat and top.
• OLS (Oracle Label Security) Oracle Label Security is developed based on virtual private database (VPD) technology and provides a flexible, fine-grained access control functionality that is achieved by comparing a sensitive label assigned to a piece of data with label authorizations assigned to an application user.
• RSM (Remote Shared Memory) is a feature that bypasses the UDP/IP communication in Solaris.
• UDP/IP (User Datagram Protocol) can send short messages sometimes known as datagrams to one another.
• TNS (Transparent Network Substrate) Allows peer-to-peer connectivity where no machine-level connectivity can occur.
• EMCA (Enterprise Manager Configuration Assistant) An Oracle tool to set up the Enterprise Manager.
• OPS (Oracle Parallel Server) The OPS option allows multiple instances on different computer systems (nodes) can access the same database files simultaneously.
• SRVCTL (Server Control) A utility to assist in administration and maintenance of RAC databases.