Server Administration :: Errors While Starting DB Using SP File

Sep 16, 2008

SP file was removed during the testing and I started the database after making some changes in the pfile, and it works fine.
But when I try to start the database using the SPFILE, it gives an error.

SQL> STARTUP PFILE='D:oracleproduct10.2.0adminorclpfileINITORCL.ORA'
ORACLE instance started.

Total System Global Area 289406976 bytes
Fixed Size 1248576 bytes
Variable Size 109052608 bytes
Database Buffers 171966464 bytes
Redo Buffers 7139328 bytes
Database mounted.
Database opened.
SQL> create spfile from pfile;

File created.

SQL> shut immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORA-01565: error in identifying file 'D:oracleproduct10.2.0db_7/dbs/SPFILEORCL.ORA'
ORA-27046: file size is not a multiple of logical block size
OSD-04012: file size mismatch (OS 1541)

The contents of the spfile in $ORACLE_HOMEdatabase are

View 12 Replies


Server Administration :: TNS Errors In Listener Log File?

Sep 11, 2012

We are getting the below error messages in LISTENER LOG FILE. That too every 5 Mins.

10-SEP-2012 16:25:43 * (CONNECT_DATA=(SERVICE_NAME=dpm)(CID=(PROGRAM=W:Applicationdpm2010.exe)(HOST=ISSLDMUM01PC169)(USER=bharathi))) * (ADDRESS=(PROTOCOL=tcp)(HOST= * establish * dpm * 0

10-SEP-2012 16:25:46 * service_update * DPM * 0
10-SEP-2012 16:25:47 * 12546
TNS-12546: TNS:permission denied
TNS-12560: TNS:protocol adapter error
TNS-00516: Permission denied

I am not getting the reason for it.

View 3 Replies View Related

Server Administration :: Window Not Starting OracleserviceORCL On Local Computer?

Oct 29, 2013

i m facing an issue about TNS connectivity after some time i start my notebook and then sql butt it can not be login from any side like sql,pl/sql,forms or reports it shows same error ora-12203 tns unable to connect to the destination also my service of oracleserviceORCL can not start it shows an error like 'windows could not start the service on local computer '

View 4 Replies View Related

Server Administration :: New Instance Not Starting / ORA-12547 / TNS / Lost Contact

Mar 29, 2011

I have successfully installed Oracle R12 on my machine but after rebooting I can not start.

This is what I did

/d01/oracle/VIS/db/tech_st/11.1.0/appsutil/scripts/VIS_localhost/ start listener

/d01/oracle/VIS/db/tech_st/11.1.0/appsutil/scripts/VIS_localhost/ start

You are running version 120.1

Starting the database VIS ...

SQL*Plus: Release - Production on Tue Mar 29 21:02:42 2011
Copyright (c) 1982, 2008, Oracle. All rights reserved.
ORA-12547: TNS:lost contact exiting with status 9
/d01/oracle/VIS/db/tech_st/11.1.0/appsutil/scripts/VIS_localhost/ start



View 18 Replies View Related

Server Administration :: Server Installation Gets Abruptly Ended For Client Get TNS Errors

Jan 11, 2011

after a long time,(i never remember when was the last time i installed 9i)i was asked to install 9i.So, whether i install server or cilent i get this error <attachment>

after i ignore it and finished the installation,The server installation gets abruptly ended for the client i get TNS errors.

View 2 Replies View Related

Server Utilities :: Handling Errors In Batch File?

Aug 21, 2010

i get flat file and i have set up a control M job so that it runs at a particular time.

initially my control file was as below:

INFILE 'DFILEabcd.dat'
BADFILE 'BDabcd.bad'
INTO TABLE abcd_table
(A position(01:09) CHAR,
B position(11:12) CHAR,
C position(14:33) CHAR,
D position(37:50) char)

this was working fine. control M did not send FAIL message.but later i had to change the ctl file due to requirement. i had to add a when clause.

my code after modification is:

INFILE 'DFILEabcd.dat'
BADFILE 'BDabcd.bad'
INTO TABLE abcd_table
when A<>'10'
(A position(01:09) CHAR,
B position(11:12) CHAR,
C position(14:33) CHAR,
D position(37:50)

now the control M is sending an erro message after it runs the job. error is Return 5. thats all it gives.

i think it is due to errorlevel 1. in log file it says zero records inserted due to data error. then what is causing control M to send fail message??

sqlloader is loading all the required records correctly.

View 10 Replies View Related

Server Administration :: Where To Find Alert Log Errors

May 10, 2010

where i can find an alert log errors so whenever they occur in my RAC so i can comprehend them very well. I am trying to know that what can be the errors when u have RAC with ASM and SAN .

View 3 Replies View Related

Server Administration :: ORA-35571 / Maximum Number Of Load Errors Has Occurred

Jul 29, 2011

In our development database, we have created 5 dimensions and a cube with 2 measures in OLAP. All these are mapped to relational tables. When we try to load this cube (MAINTAIN CUBE option from AWM) we are getting this below error:

An error has occurred on the server
Error class: Express Failure
Server error descriptions:
INI: error creating a definition manager, Generic at TxsOqConnection::generic<BuildProcess>
INI: XOQ-01600: OLAP DML error "ORA-35571: The maximum number of load errors has occured." while executing DML


What are the database parameter i should look for as a DBA ?

View 1 Replies View Related

Server Administration :: ORA-01111 / Name For Data File 636 Is Unknown - Rename To Correct File

Nov 3, 2012

i have two tablespaces dictionary managed (SYSTEM,APPLSYSX) i tried to change to locally cause it will cause problem in future when trying to run OATM migration.i did it successfully on APPLSYSX,when i did it on system upon oracle procedure.i have to change all tablespaces to read only when i did that with tablespace APPLSYSD(alter tablespace APPLSYSD read only) i received errors

SQL> alter tablespace APPLSYSD READ ONLY;
alter tablespace APPLSYSD READ ONLY
ERROR at line 1:
ORA-01230: cannot make read only - file 636 is offline
ORA-01111: name for data file 636 is unknown - rename to correct file
ORA-01110: data file 636: '/vol5u/oracle/prddb/9.2.0/dbs/MISSING00636'
i have not this file on the OS

View 1 Replies View Related

Trace File Errors Interpretation

Apr 18, 2013

We are running Oracle on a Windows 2008 R2 Server with an app server on the same. Our app has a search function that has recently started timing out on us. Sometimes intermittently but often now. I've ran a trace in our dev environment, below code, in an attempt to track down the issue but I'm finding very little useful information in relation to the errors I see in the trace file below. My experience in deciphering trace code is nill so how to interpret these errors.

*** 2013-04-18 14:27:23.353
*** SESSION ID:(3093.63097) 2013-04-18 14:27:23.353
*** CLIENT ID:() 2013-04-18 14:27:23.353
*** SERVICE NAME:(SYS$USERS) 2013-04-18 14:27:23.353
*** MODULE NAME:(w3pw.exe) 2013-04-18 14:27:23.353
*** ACTION NAME:() 2013-04-18 14:27:23.353

View 3 Replies View Related

Clusterware :: Grid On Standalone Server Cluster Daemons Not Starting During Server Boot

Jul 4, 2012

I have installed Oracle Grid on a standalone server and setup Oracle db on Oracle Linux 6.2 64 bit server.When I reoot the server and run crs_stat -t,several daemons havent started thus the ASM and db instances are also down as below

Name Type Target State Host
ora.DATA.dg ora....up.type OFFLINE OFFLINE
ora.FRADG.dg ora....up.type OFFLINE OFFLINE
ora....ER.lsnr ONLINE ONLINE amldb01dc
ora.amldb.db OFFLINE OFFLINE
ora.asm ora.asm.type OFFLINE OFFLINE
ora.cssd ora.cssd.type ONLINE OFFLINE
ora.diskmon ora....on.type ONLINE OFFLINE
ora.evmd ora.evm.type ONLINE ONLINE amldb01dc
ora.ons ora.ons.type OFFLINE OFFLINE

I am forced to manually start the daemons via command crsctl start resource -all then I manually start the ASM and db instances. Yet when I run the commands

crsctl config has
CRS-4622: Oracle High Availability Services autostart is enabled.

crsctl check has
CRS-4638: Oracle High Availability Services is online.

Thus I would assume the daemons would start automatically during boot.

View 5 Replies View Related

Application Express Listener :: Log Errors When Uploading File?

Sep 28, 2012

I get an ERR-7621 from Apex whenever I do anything in an application the tries to read a file. For example importing images, css files, themes, or applications. Even the data loader app will get the error if you choose to load a "csv" file. The following appears in my Apex Listener Log (version 2 early adopter). I am running 4.1.1 of Apex and also have another server running the same where the problem does not exist. Following is the log output whenever the load occurs:

Sep 28, 2012 11:21:18 AM com.sun.grizzly.http.servlet.ServletAdapter doService
SEVERE: service exception:
java.lang.NumberFormatException: For input string: ""
at java.lang.NumberFormatException.forInputString(


View 1 Replies View Related

Reports & Discoverer :: Server Is Shutting Down / When Starting Up

Aug 17, 2011

I want to start up a reports server by executing the command "rwserver server=<server_name> start" via the windows command line. The status shows that the server is starting up but, the next second the status shows "Server is shutting down"

View 2 Replies View Related

Server Administration :: Identify Tnsnames.ora File?

Jun 10, 2011

How to find out the database TNSNAMES.ora file if there are multiple .ora files with different names in Oracle_home/network/admin directory ?

View 6 Replies View Related

Server Administration :: UNDO In Parameter File?

Dec 9, 2011

I have a question ragarding undo tablespace. I want to ask that why only undo tablespace information we need to specify in parameter file. We do not specify any other tablespace information. Not even for temporary tablespace. Then why we need to give undo tablespace name while instance is creating.

View 5 Replies View Related

Server Administration :: ARC File Size Too Small?

Oct 2, 2012

I noticed my DB is generating a lot of "small" .arc files and I am usure why. As you can see from the v$log query my log file size is set to 50MB. But yet BLOCKS*BLOCK_SIZE never adds up to 50MB.

Is there anything else I can look into to see how to make the .arc files larger?

SQL> select group#, thread#, bytes from v$log;
---------- ---------- ----------
1 1 52428800
2 1 52428800
3 2 52428800
4 2 52428800

select blocks, block_size, blocks*block_size from v$archived_log where sequence# between 63876 and 72851 and thread# = 1

---------- ---------- -----------------
28 512 14336
28 512 14336
28 512 14336
55 512 28160


View 18 Replies View Related

Server Administration :: How To Check Alertlog File

Mar 3, 2012

you have some 500 Db how will u check the alertlog file. do u do it manually or is their any tool to check the alertlog files. how to check it.

View 7 Replies View Related

Server Administration :: Archive Log File Generating?

Jan 10, 2011

I want to know how many archive log generating in One hour at the peak time. We have 6 nodes RAC multiplex 2.

Is there are any query through which I can achieve the above purpose.

Note: As this is a prod instance client is not happy to implement Log Miner utility.

View 9 Replies View Related

Server Administration :: Unable To Run Setup EXE File?

Mar 14, 2012

when i try to install Oracle 10g ( 64- bits on windows server 2003 enterprise edition 64 bits service pack1 and i try for windows server 2003 standard edition 64 bits on a pc,i am getting the below error.

the image file E: is valid, but it is for a machine type other than current machine

i need to install it as soon as possible .

View 3 Replies View Related

Server Administration :: File Format Of DBF Files

Apr 12, 2010

I want to know the file format of .dbf file.I want to open it in hex editor and want to read contents of that file from there.

View 4 Replies View Related

Server Administration :: Create A New Control File?

Jul 12, 2012

I am trying to create a new controlfile. I used "alter database backup controlfile to trace;" and then I copied and pasted the contents of the trace file into the .sql file. My sql script is



Actually, the name of my database was 'STAR' and I changed it to "FIVESTAR" int this .sql script. Now when I run this script with SQL> @ <path of my sql script>, it gives me the following errors:

ERROR at line 1:
ORA-01504: database name 'FIVESTAR' does not match parameter db_name 'STAR'

View 2 Replies View Related

Server Administration :: How To Recreate Control File

Jun 12, 2012

I can not run the control file treace file,why?

[oracle@hxl oradata_bak]$ more run_sql.sql


View 12 Replies View Related

Server Administration :: Generation Of Redo Log File

Aug 20, 2010

redo generation. As I found the below statement in another forum."Undo segment generates the redo data also, because undo segment is database changes, so it generates the redo data also."

How a Undo segment can generate Redo and Undo datas.

View 12 Replies View Related

Server Administration :: Writing Control File

Nov 25, 2011

I was doing some R&D on my test machine trying to understand how controlfile works. I started up my db and then deleted (renamed)the controlfiles at OS level. I was expecting the db to shutdown. But it dint. Moreover when i queried select name from v$controlfile; it was still reflecting the old controlfile names. To check if it was still functioning, i created a new tablespace with one file and it also got created without any error.

What i dint understand is how could the db still be running when the control file was'nt there and new tablespace and datafile get created? As i understand, whenever a new file is created, an entry is made in the control file. But when control file dint exist where was the data about new tablespace and datafile written?

View 5 Replies View Related

Server Administration :: Move File System Datafile To ASM

Oct 23, 2012

I mistakenly added a datafile to a tablespace which is asm, however the datafile was created in a default location and not the asm location:

alter tablespace pdaiidata1 add datafile '<filename>' size 2048M;

What I should have done:

alter tablepsace <tablespace_name> add datafile '+DATA1' size 2048M;

Is there any way to move this filesystem datafile into the asm tablespace? In previous Oracle versions, I've taken a tablespace offline, moved a datafile, renamed it, then brought the tablespace back online. Can I do something similar here in this situation?

View 4 Replies View Related

Server Administration :: Unable To Create Control File

Jun 3, 2010

I am not able to create control file from scrip . it showing following error

ORA-01081: cannot start already-running ORACLE - shut it down first
ERROR at line 19:
ORA-02236: invalid file name

View 4 Replies View Related

Server Administration :: ORA-03113 - End-of-file On Communication Channel

Sep 27, 2010

My archivelog database get error because my flash_recovery_area is full.

so I disable archivelog mode. When to restart database server I got this message:

ORA-03113: end-of-file on communication channel
processus ID : 27427
session id : 96, Numéro de série : 3

Do you think I can delete manually ( Os commande rm ) files in flash_recovery_area ?

How to restart database server

View 8 Replies View Related

Server Administration :: Size Storing JPG File In Database

Feb 13, 2012

I am storing customer's snaps in a table ( column's data type as LONG RAW) using oracle forms Webutil. Now there are 250 snaps in the table. The file type of these snaps is JPG with the average size 30KB.

I made a backup using export utility before storing these snaps and the exported DMP file's size was 36MB. Now after storing these just 250 snaps of 30KB the DMP file's size is gone over 300MB.

i need to change column's datatype? or some where in oracle forms's image item. Because on window's file system the size of these files is just 8MB.

View 8 Replies View Related

Server Administration :: What Can Be Maximum Size Of Data File

Nov 24, 2011

I am having I/O issues if i create 20 GB DATAFILES on SMALL TABLE SPACE. guide me with the maximum size limit of data file that I can create in Windows 2003 32 bit server.

View 3 Replies View Related

Server Administration :: Split 30GB DBF File Into 6 - 5GB Files?

Dec 27, 2011

We have a tablespace with one 30GB datafile. We would like to add 5 more datafiles then re-size the original to make six 5GB datafiles.

View 6 Replies View Related

Copyrights 2005-15, All rights reserved