Recreate Parameter File When Lost Or Corrupted?

Jul 1, 2010

recreate paramater file if you lost init.ora or spfile.ora

STEPS

SQL> startup
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file 'D:ORACLEORA92DATABASEINITGPT2.ORA'
How to resolve ORA-01078 with LRM-00109 error?

For resolving these error, you should need to replace init.ora or spfile if you have backup of same files. If you don't have backup then go to alert.log and copy all parameters in one file and save as "init.ora". Modify same init.ora with some parameters which need single quotation mark " ' " like background_dump_dest,controlfiles,db_name and "dispatchers ......)". Connect as sysdba in SQL*Plus and execute command "create spfile from pfile=" or startup pfile or startup.

View 2 Replies


ADVERTISEMENT

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
CREATE CONTROLFILE REUSE DATABASE "ORACL" RESETLOGS ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100

[code]...

View 12 Replies View Related

Enterprise Manager :: How To Recreate File For EMCTL

Jul 19, 2010

I cannot start our Enterprise Manager services for our newly created db. I'm encountering this error:

"$ emctl start dbconsole
Unable to locate file /appl1/home/oracle/10.2/xxx-dbs_abcd/sysman/config/emd.properties : No such file or directory"

I've been executing this command for a no. of times at the ORACLE_HOME directory:

$ ./emca -config dbcontrol db -repos create

.. but still I cannot start EMCTL dbconsole.

View 16 Replies View Related

All Control File Lost?

Oct 12, 2012

I know this question must have been asked several time. I just want to know the many ways in which we can have a DB up and running even if we do not have any backup of control file not even the trace of the same.

View 6 Replies View Related

Server Administration :: How Control File Is Corrupted And Database Not Open

Apr 27, 2011

I am using oracle 10g R2. Some how control file is corrupted and database is not open. and there is no backup of control file. Now i need to open the database without recreating the database.

View 5 Replies View Related

Backup & Recovery :: Control-file Piece Handle Lost From Tape?

May 9, 2011

We are trying to restore a database to a cold backup DBID.However while our datafiles were backuped up for 6 months retention we found out subsequent delete obsolete command wiped out the Control file related to this backup piece..Now what is left with this backup piece is just datafiles..

Can we still recover the database with a subsequent controlfile autobackup for the same DBID.?

View 2 Replies View Related

PL/SQL :: Get Runtime Parameter In SQL File?

Dec 11, 2012

I want to get runtime parameter in .sql file . read values at runtime in .sql file

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

RAC & Failsafe :: How To Know About Listener.ora Parameter And The Endpoints File

Apr 2, 2010

information on this listener.ora parameter and the endpoints file? There is no reference in the docs (except for a sample listener.ora file in the RAC Installation Guide, no explanation).

Following a clusterware with gPNP installation, the listener.ora file has only IPC addresses, plus this parameter:

LISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER))))# line added by Agent
LISTENER_SCAN3=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN3))))# line added by Agent
LISTENER_SCAN2=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN2))))# line added by Agent
LISTENER_SCAN1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1))))# line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1=ON# line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN2=ON# line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN3=ON# line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON# line added by Agent

The endpoints_listener.ora file specifies the fixed and VIP addresses of the public NIC:

LISTENER_GR7244=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.196.182.201)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=10.196.180.44)(PORT=1521)(IP=FIRST))))# line added by Agent

The listener named LISTENER is in fact listening on both its IPC address, and the addresses in the endpoints_listener.ora file:

[grid@gr7244 admin]$ lsnrctl status listener
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 02-APR-2010 04:52:02
Copyright (c) 1991, 2009, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
STATUS of the LISTENER

[code]...

The scan listener on this node is listening on its IPC address, and its VIP:

[grid@gr7244 admin]$ lsnrctl status listener_scan3
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 02-APR-2010 04:46:15
Copyright (c) 1991, 2009, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN3)))
STATUS of the LISTENER
------------------------
Alias LISTENER_SCAN3

[code]...

I did wonder if this parameter and file could be part of the mechanism whereby a listener discovers the DHCP assigned VIPs on which it has to listen?

View 1 Replies View Related

Write Shell Script To Parse Parameter File

Mar 29, 2013

I'm working on trying to write a shell script to parse a parameter file, but at the same time I want to be able to overwrite the parameter file settings with other command line settings. For instance if my par file had export/import settings for the username, password, schema, etc;

I wanted to run the same export/import with those settings for a different schema. I want to be able to put the schema=<different_than_par_file> after the parfile=<parfile.par and have the parfile be read and applied for everything except the different schema.

Right now I'm storing the cmd line and parsing it again looking for other parameters besides the parfile.

View 4 Replies View Related

Server Administration :: Initialization Parameter File - Currently In Effect For Session

Jan 31, 2012

I have a question about spfile.

SQL> SELECT COUNT(*) FROM v$parameter WHERE value IS NOT NULL;
COUNT(*)
----------
246
SQL> SELECT COUNT(*) FROM v$spparameter WHERE value IS NOT NULL;
COUNT(*)
----------
20

v$parameter displays information about the initialization parameters that are currently in effect for the session,but v$spparameter displays information about the contents of the spfile.I want to know why the count of parameters whose values are not null in v$parameter is greater.where are they from? My initialization parameter file is spfile.

View 3 Replies View Related

Oracle DB Corrupted

Feb 7, 2013

Recently we have a weird thing happens in our Oracle Queries to the views return "ORA-00942: table or view does not exist" unless there are a where clause

select * from VIEW1 failed
select * from VIEW1 where 1 = 1 works

What happening? and how we can fix it?

View 11 Replies View Related

SQL & PL/SQL :: Recreate Objects Of One Schema Into Another

Apr 8, 2010

I got the below error while executing the procedure. What the procedure doing is recreate the objects of one schema into another. After recreating some objects it throws the error.

code is...

1 CREATE OR REPLACE PROCEDURE SCHEMA_IMPORT6
2 AUTHID CURRENT_USER
3 AS
4 V_Objid NUMBER;
5 V_Xml XMLTYPE;
6 V_Xml_Ind XMLTYPE;
[code]....

View 3 Replies View Related

SQL & PL/SQL :: Unable To Recreate An Object?

Mar 15, 2010

I have the metadata of an object in one of my database table as xml. I failed to recreate the object in the other schema using metadata api. I developed a stored function to do the above job. My function doesn't throw any error as well as it doesn't create the object.

My code snippet is

CREATE OR REPLACE PROCEDURE DDI.move_table(
table_name in VARCHAR2,
from_schema in VARCHAR2,
to_schema in VARCHAR2 )
AUTHID CURRENT_USER

[code]....

The schema where i create and execute my function have dba privilege also.

View 9 Replies View Related

SQL & PL/SQL :: Materialized View Recreate

Oct 2, 2012

we have a materialized view (in Oracle 11g), usually this MV we easily drop and recreate it.

But last few days, i am trying to drop a MV, but running a long time but no result and it keeps running. not dropped also.

Bcos, db performance is good since we tried to a view using script, it is fine. Problem seems only with Materialized view.

where and how to check what is the issue?

View 1 Replies View Related

RESUMEABLE Parameter / No Space Left On File System Export Fails

Dec 2, 2010

I have some question about the parameter RESUMABLE 10G. My quesition is suppose if i am running a expdp process and if there is no space left on the file system the export fails. So in this case if we set the RESUMABLE parameter in the DB will it be useful to resume the expdp from where it fails or it will useful if we schedule a job for the export.

View 2 Replies View Related

SQL & PL/SQL :: How To Retrieve A View Definition To Recreate

May 20, 2013

How to retrieve a view definition to re-create it somewhere when its size is more than 32767 bytes?Here are some constraints :

- We are in Oracle 9.2.0.8, meaning that we cannot use the DBMS_METADATA package.
- We cannot concatenate char and long : things like
set long 100000

select 'create or replace view my_view as ' || text from dba_views where view_name = 'MY_VIEW';
are not possible.

View 31 Replies View Related

Server Administration :: How To Recreate Lobindex

May 24, 2011

i missed a tablespace that includes more than 20,000 indexes for reason. there is nothing to do with it without recreate these indexes.i could find these index's ddl createment from "dbms_metadata.get_ddl" packages.

but the DDL createment like this:

CREATE UNIQUE INDEX "AMV"."SYS_IL0000241510C00002$$" ON "AMV"."DR$AMV_C_CHANNELS_DESC_CTX$R" (
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 524288 NEXT 524288 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "APPS_TS_TX_IDX"
PARALLEL (DEGREE 0 INSTANCES 0)

PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS

*ERROR at line 2: ORA-00936: missing expression

note: this tablespace is in ORACLE EBS R11 name "APPS_TS_TX_IDX" how to recreate LOBINDEX?

View 1 Replies View Related

SQL & PL/SQL :: Unable To Recreate DBLink In Another DB / Schema?

Mar 25, 2010

I'm unable to recreate the db link (private) in another schema/database. Even its a schema object, its come without schema name while extracting from database using metadata api.

code is below (just for extracting)

CREATE OR REPLACE FUNCTION DDI.DBLINK_DDL
RETURN CLOB
AUTHID CURRENT_USER
AS
v_meta_handle NUMBER;
v_meta_handle_trans NUMBER;
V_DOC CLOB;

[code].....

View 8 Replies View Related

Hyperlink Inside A Mail Got Corrupted

May 4, 2012

I have an application written in Pl SQL Oracle which suppose to send email using utl_smtp. For users that are using Exchange Server 2010 Windows the hyperlinks inside the email are correctly but for users that have a Postfix version installed on a Debian 5 Linux mail server the hyperlinks contains some extra spaces. I think that the CRLF that I'm using inside my code to create the MIME message is not ok interpreted.

View 5 Replies View Related

Windows :: Delete Corrupted Files In Win 7?

Mar 12, 2012

I was having troubles with deleting some files and folders in windows 7, I used a software called SPAM. It works fine. Do I have any other options to do that thing? Or is it ok to be with SPAM? This tool has more options too.

View -1 Replies View Related

RMAN :: How To Restore Corrupted Database

Dec 19, 2012

We have Oracle 10.2.0.3 database installed on Itanium server.

1. One day we found some packages got invalid & not compiling at all with error – ORA-00600: internal error code, arguments: [4097], [], [], [], [], [], [], [].

2. Then we successfully restored the database from old RMAN backup of previous date that caused this error.

3. After 2 days again we found the same error in alert_prd log - ORA-00600: internal error code, arguments: [ORA-00600: internal error code, arguments: [4097], [], [], [], [], [], [], [] ORA-06512: at "SYS.DBMS_STATS", line 19089 ], [], [], [], [], [], [], []     

4. Then for testing we exported database using exp command & found 3 tables are not exporting because of data block corruption issue.

5. Then we truncated the data from all 3 tables and then able to export successfully.

6. After all this we manually run SYS.DMS_STATS job but found same error logged in prd_alert log.

This looks like, still database block corruption issue is there & we are unable to cure it 100% This is a production system & in very critical state now.

View 1 Replies View Related

Server Administration :: How To Clean Corrupted Dba_tables

Feb 5, 2013

I have a table enrty in dba_tables:

SQL> select OWNER,TABLE_NAME from dba_tables where TABLE_NAME='Viep_Porteur_Etudiant';
OWNER TABLE_NAME
------------------------------ ------------------------------
IEP_PESSAC Viep_Porteur_Etudiant

But this tables doesn't exist then I can't drop this table:

SQL> desc IEP_PESSAC.Viep_Porteur_Etudiant;
ERROR:
ORA-04043: objet IEP_PESSAC.Viep_Porteur_Etudiant inexistant
SQL> drop table IEP_PESSAC.Viep_Porteur_Etudiant;
drop table IEP_PESSAC.Viep_Porteur_Etudiant
*
ERREUR à la ligne 1 :
ORA-00942: Table ou vue inexistante

How can I clean dba_table? I suppose that that's happened because the user tablespace was full when he tried to create this table...

View 6 Replies View Related

Server Administration :: Temporary Tablespace Was Corrupted

Aug 8, 2013

i found a temporary tablespace was corrupted,what happens to the database level, how to recover that tablespace? If need any recovery?

View 3 Replies View Related

PL/SQL :: Materialized View - Update Query Without Drop And Recreate

Aug 24, 2012

i have a little doubt in Materialized view. i created a materialized view and log with the following query,

create table test_mv (a number ,b number )
alter table test_mv add constraint t_pk primary key ( a );
insert into test_mv values (1,2);

[Code]...

Now i want to update the query in the MV as 'Select a from test_mv' . for that i tried with

*'ALTER MATERIALIZED VIEW product_sales_mv AS SELECT a from test_mv;'*

But it throwing error,

Error starting at line 5 in command:

alter  MATERIALIZED VIEW product_sales_mv   AS SELECT  b  from test_mv

Error report:

SQL Error: ORA-00933: SQL command not properly ended +00933. 00000 - "SQL command not properly ended"+

*Cause:+   
*Action:+

i guess i am doing wrong. i want to update it without drop and recreate

View 2 Replies View Related

Backup & Recovery :: Oracle Crashed And Data Corrupted?

May 20, 2013

I am the only DBA in my company and Oracle just crashed on me. The data is corrupted as well as the data on my backup! Is there ANY way I can get the information back?

View 2 Replies View Related

Ora-01578 ORACLE Data Block Corrupted For New Site

Nov 14, 2012

Oracle 10gR2 on red hat.

I have an application that writes blobs via pro*c. It is running at several sites without errors for a few years now. One of the newer sites has started reporting "ora-01578 ORACLE data block corrupted".

I've tried using rman backup validate - it does not report any errors.

I've tried using rman restore and recover to correct the problem.

I've tried deleting the file with the corrupt block and using rman restore and recover to recreate it.

In any of the above cases, I do not see any errors being encountered, and when I restart the application, it works for a while and then starts reporting "ora-01578 ORACLE data block corrupted".

I've had the client do a physical check of the disk and it indicated the media was okay.

We've failed over to the standby system, so I have a wee bit of breathing room - but I'm going to be away for 4 days and will have to get back on this when I get back. I'm a little puzzled that I can fix it for a short while and then it breaks again.

View 2 Replies View Related

Server Administration :: Find Database Is Corrupted Or Crashed

Mar 3, 2012

how will you find your db is Corrupted or crashed. how will u recover it.

View 2 Replies View Related

RMAN - ORA-01578 Oracle Data Block Corrupted

Feb 11, 2013

we are running oracle 9iR2 ( 9.2.0.1.0) on windows server 2003 R2 and facing ORA-01578: ORACLE data block corrupted (file # 17, block # 312316)

SQL> select * from payrol.slip;
select * from payrol.slip
*
ERROR at line 1:
ORA-01578: ORACLE data block corrupted (file # 17, block # 312316)
ORA-01110: data file 17: 'E:ORACLEORADATAMTMASYSMTM.ORA'
ORA-26040: Data block was loaded using the NOLOGGING option

1) SELECT name FROM v$datafile WHERE file#=17;
output
E:ORACLEORADATAMTMASYSMTM.ORA

2) SELECT block_size FROM dba_tablespaces
WHERE tablespace_name =
(SELECT tablespace_name FROM dba_data_files WHERE file_id=17);
output
8192

3) SELECT tablespace_name, segment_type, owner, segment_name
FROM dba_extents
WHERE file_id = &AFN
and &BL between block_id AND block_id + blocks - 1;

file_id=17, BL=312316
output
SYSMTM TABLE PAYROL SLIP

I am not using RMAN. How to recover payrol.slip table ?

View 7 Replies View Related

Recreate Global OraInventory Directory For 9iR2 In Solaris SPARC 64 Bit?

Jan 22, 2011

recreate global OraInventory directory for Oracle 9iR2 in Solaris SPARC 64 bit.

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved