ORA-00270 ORA-16401

Wed Nov 28 06:34:37 2012
LNS: Closing remote archive destination LOG_ARCHIVE_DEST_2: 'nsnstd' (error 1950                                             2)
 (nsndb)
Wed Nov 28 06:34:37 2012
Errors in file /export/home/oracle/admin/nsndb/bdump/nsndb_lns1_24654.trc:
ORA-00270: error creating archive log
LNS: Failed to archive log 4 thread 1 sequence 7457 (270)

Continue reading “ORA-00270 ORA-16401” »»»»»

ORA-19502 ORA-16055

ORACLE Instance nsndb – Archival Error. Archiver continuing.
Wed Nov 28 05:56:16 2012
Errors in file /export/home/oracle/admin/nsndb/bdump/nsndb_arc0_998.trc:
ORA-19502: write error on file "", blockno  (blocksize=)
Wed Nov 28 05:56:17 2012
FAL[server, ARC0]: FAL archive failed, see trace file.
Wed Nov 28 05:56:17 2012
Errors in file /export/home/oracle/admin/nsndb/bdump/nsndb_arc0_998.trc:
ORA-16055: FAL request rejected
ARCH: FAL archive failed. Archiver continuing

Continue reading “ORA-19502 ORA-16055” »»»»»

UDI-04031 ORA-04031 ORA-06512 ORA-06512 ORA-25254

UDI-04031: operation generated ORACLE error 4031
ORA-04031: unable to allocate 32 bytes of shared memory ("shared pool","SELECT job_id FROM v$datapum…","SQLA","tmp")
ORA-06512: at "SYS.KUPV$FT_INT", line 2904
ORA-06512: at "SYS.KUPC$QUE_INT", line 572
ORA-25254: time-out in LISTEN while waiting for a message
ORA-06512: at "SYS.DBMS_DATAPUMP", line 3263

Continue reading “UDI-04031 ORA-04031 ORA-06512 ORA-06512 ORA-25254” »»»»»

ORA-01652: unable to extend temp segment by 128 in tablespace TEMP

ORA-01652: unable to extend temp segment by 128 in tablespace TEMP

  SOL:

Check the default temporary tablespace first , execute the following query:

SQL> SELECT * FROM DATABASE_PROPERTIES where PROPERTY_NAME='DEFAULT_TEMP_TABLESPACE';

Now check the TEMP Tablespace used and free spaces as below:

SQL> select TABLESPACE_NAME, BYTES_USED, BYTES_FREE from V$TEMP_SPACE_HEADER;

TABLESPACE_NAME                BYTES_USED BYTES_FREE Continue reading “ORA-01652: unable to extend temp segment by 128 in tablespace TEMP” »»»»»

opmnctl startall requires that ORACLE_INSTANCE be correctly set in your environment.

Problem: error occurs when using command opmnctl in oracle 11g grid for starting OMS.

oracle@>opmnctl startall
opmnctl: ORACLE_INSTANCE is not set.

opmnctl startall requires that ORACLE_INSTANCE be correctly set in your
environment.

Make sure you are using ORACLE_INSTANCE/bin/opmnctl, or set ORACLE_INSTANCE
in your environment.

SOLUTION:
–See metalink  [ID 1160335.1]

Cause:

to deploy 10g version we use OC4J but in in 11.1.0.1 grid control release, OMS is deployed in Weblogic server,and so opmnctl is not a valid command to start and stop the OMS. Continue reading “opmnctl startall requires that ORACLE_INSTANCE be correctly set in your environment.” »»»»»

Connection to the repository failed. Verify that the repository connection information provided is correct

oracle@ >emctl start oms

Oracle Enterprise Manager 11g Release 1 Grid Control

Copyright (c) 1996, 2010 Oracle Corporation.  All rights reserved.

Starting WebTier…

WebTier Successfully Started

Starting Oracle Management Server…

Oracle Management Server is not functioning because of the following reason:

Connection to the repository failed. Verify that the repository connection information provided is correct.

SOLUTION:

>>first check the repository database is up and running,listerner is up and running or not.

if not then make them running up and fine.

>>now check :

oracle@ >emctl config oms -list_repos_details

Continue reading “Connection to the repository failed. Verify that the repository connection information provided is correct” »»»»»

Oracle Clustware Command Line Tools in RAC

++++++++Command Line Tools to administer Oracle Clusterware in RAC 10G++++++++

Below are some more  frequently used command line tools list, and we will discuss about each one by one:

crsctl

crs_stat     –shows current status of list of resources

ocrconfig
ocrcheck
ocrdump
srvctl
oifcfg Continue reading “Oracle Clustware Command Line Tools in RAC” »»»»»