ORA-16032: parameter LOG_ARCHIVE_DEST destination string cannot be translated

[oracle11@db01 ~]$ export ORACLE_SID=orcl

[oracle11@db01 ~]$ sqlplus
SQL*Plus: Release 11.2.0.3.0 Production on Mon Jul 29 10:12:44 2013

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

Enter user-name: sys as sysdba
Enter password:
Connected to an idle instance.

SQL> startup
ORA-16032: parameter LOG_ARCHIVE_DEST destination string cannot be translated
ORA-07286: sksagdi: cannot obtain device information.
Linux Error: 2: No such file or directory

SQL> create pfile='/data01/orcl.ora' from spfile;

File created.

open the pfile and check this parameter and check the path that path is available or not if not then you have to create the folder same as you set  the path in the parameter. and startup the db.


*.log_archive_dest='/data/oracle11_backup/archive'


All The Best.........:)

ORA-14460: only one COMPRESS or NOCOMPRESS clause may be specified

ORA-14460: only one COMPRESS or NOCOMPRESS clause may be specified

Failing sql is:

CREATE TABLE neer.neeraj( empid number,salary number,lname char(10))…….

ORA-39083: Object type TABLE:"MALI_PRT1"."DAILY_C2S_TRANS_DETAILS" 

failed to create with error:

ORA-14460: only one COMPRESS or NOCOMPRESS clause may be specified

impdp system/manager directory=dump dumpfile=emp.dmp logfile=emp.log remap_schema=hr:neer transform=segment_attributes:n parallel=4

Transform parameter allows you to alter object creation DDL while performing import.  I have tried all the attempt to make the understanding of transform parameter easy.

TRANSFORM = transform_name:value[:object_type]

The transform_name specifies the name of the transform. The possible options are as follows:

  SEGMENT_ATTRIBUTES – If the value is specified as y, then segment attributes (physical attributes, storage attributes, tablespaces, and logging) are included, with appropriate DDL. The default is y.
STORAGE - If the value is specified as y, the storage clauses are included, with appropriate DDL. The default is y. This parameter is ignored if SEGMENT_ATTRIBUTES=n.
OID - If the value is specified as n, the assignment of the exported OID during the creation of object tables and types is inhibited. Instead, a new OID is assigned. This can be useful for cloning schemas, but does not affect referenced objects. The default value is y.
PCTSPACE – The value supplied for this transform must be a number greater than zero. It represents the percentage multiplier used to alter extent allocations and the size of data files.

The object_type is optional. If supplied, it designates the object type to which the transform will be applied. If no object type is specified then the transform applies to all valid object types.

ORA-39700: database must be opened with UPGRADE

RMAN> alter database open resetlogs;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 07/15/2013 11:22:31
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-00704: bootstrap process failure
ORA-39700: database must be opened with UPGRADE option
Process ID: 4308
Session ID: 3726 Serial number: 7
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
ORA-03114: not connected to ORACLE
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 07/15/2013 11:22:31
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-00704: bootstrap process failure
ORA-39700: database must be opened with UPGRADE option
Process ID: 4308
Session ID: 3726 Serial number: 7


[oracle11@hostname ~]$ sqlplus

SQL*Plus: Release 11.2.0.3.0 Production on Mon Jul 15 11:22:57 2013

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

Enter user-name: sys as sysdba
Enter password:
Connected to an idle instance.

SQL> startup mount with pfile='/u01/neeraj_backup/neer.ora'
ORACLE instance started.

Total System Global Area 1238732800 bytes
Fixed Size                  1344624 bytes
Variable Size            1140853648 bytes
Database Buffers           83886080 bytes
Redo Buffers               12648448 bytes
ORA-02231: missing or invalid option to ALTER DATABASE


SQL> alter database mount;

Database altered.

SQL> create spfile from pfile='/u01/neeraj_backup/neer.ora';

File created.


SQL> shutdown immediate
ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.


SQL> conn
Enter user-name: sys as sysdba
Enter password:
Connected to an idle instance.
SQL> startup upgrade
ORACLE instance started.

Total System Global Area 1238732800 bytes
Fixed Size                  1344624 bytes
Variable Size            1140853648 bytes
Database Buffers           83886080 bytes
Redo Buffers               12648448 bytes
Database mounted.
Database opened.

SQL> spool upgrade.log
SQL>
SQL> @ /u01/app/oracle11/product/11.2.0/dbhome_1/rdbms/admin/catupgrd.sql

connect with sqlplus
and login .....




The catupgrd.sql script determines which upgrade scripts must be run, runs them, and then shuts down the database. You must run the script in the Oracle Database 11g Release 2 (11.2) environment.

The upgrade script creates and alters certain data dictionary tables. It also upgrades or installs the following database components in the new Oracle Database 11g Release 2 (11.2) database:

•     Oracle Database Catalog Views
•     Oracle Database Packages and Types
•     JServer JAVA Virtual Machine
•     Oracle Database Java Packages
•     Oracle XDK
•     Oracle Real Application Clusters
•     Oracle Workspace Manager
•     Oracle Multimedia
•     Oracle XML Database
•     OLAP Analytic Workspace
•     Oracle OLAP API
•     OLAP Catalog
•     Oracle Text
•     Spatial
•     Oracle Data Mining
•     Oracle Label Security
•     Messaging Gateway
•     Oracle Expression Filter
•     Oracle Rules Manager
•     Oracle Enterprise Manager Repository
•    Oracle Database Vault
• Oracle Application Express

All the best...... :)

ERROR: ORA-00257: archiver error. and ORA-03113: end-of-file on communication channel

If Anyone face this error so refer this command.....


Enter user-name: neeraj
Enter password:
ERROR:
ORA-00257: archiver error. Connect internal only, until freed.


Warning: You are no longer connected to ORACLE.


SQL> startup mount
ORACLE instance started.

Total System Global Area 1603411968 bytes
Fixed Size            2213776 bytes
Variable Size          905971824 bytes
Database Buffers      687865856 bytes
Redo Buffers            7360512 bytes
Database mounted.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
Process ID: 30790
Session ID: 4519 Serial number: 5



SQL> startup mount
ORACLE instance started.

Total System Global Area 1603411968 bytes
Fixed Size            2213776 bytes
Variable Size          905971824 bytes
Database Buffers      687865856 bytes
Redo Buffers            7360512 bytes
Database mounted.

SQL> alter system set db_recovery_file_dest_size=6g scope=spfile;

System altered.

SQL> shutdown immediate
ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 1603411968 bytes
Fixed Size            2213776 bytes
Variable Size          905971824 bytes
Database Buffers      687865856 bytes
Redo Buffers            7360512 bytes
Database mounted.
Database opened.

All d best.... :)
enjoy.....

An Introduction to SQL Server 2005 Integration Services

Microsoft SQL Server 2005 Integration Services (SSIS) :-
                                                                                                      is a platform for building high performance data integration solutions, including the extraction, transformation, and loading (ETL) of packages for data warehousing. SSIS is the new name assigned to the component formerly branded as Data Transformation Services (DTS).

ETL process and concepts :-
ETL stands for Extraction, Transformation and Loading. ETL is a process that involves the following tasks:

• Extracting :- data from source operational or archive systems which are the primary source of data for the data warehouse
• Transforming :- the data - which may involve cleaning, filtering, validating and applying business rules
• Loading :- the data into a data warehouse or any other database or application that houses data

Data Integration Requirements

In view of this diversity of data, business needs, and user requirements, the Information Technology department has specified the following set of data integration requirements:

• They must provide reliable and consistent historical and current data integrated from a variety of internal and external sources.
• To reduce lags in data acquisition, data from providers and vendors must be available via Web services or some other direct mechanism such as FTP.
• They need to cleanse and remove duplicate data and otherwise enforce data quality.
• Increasing global regulatory demands require that the company maintain clear audit trails. It is not enough to maintain reliable data; the data needs to be tracked and certified.

RMAN-06059: expected archived log not found

RMAN-06059: expected archived log not found

RMAN> backup database plus archivelog;


Starting backup at 10-JUL-13
current log archived
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup plus archivelog command at 07/10/2013 14:37:21
RMAN-06059: expected archived log not found, loss of archived log compromises recoverability
ORA-19625: error identifying file /oracle/flash_recovery_area/neeraj/archivelog/2013_05_27/o1_mf_1_3898_8t6fsgmn_.arc
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3

RMAN>crosscheck archivelog all;
RMAN>delete noprompt expired archivelog all;

RMAN>backup database plus archivelog;

starting backup...........