Oracle_home / Bin Directory Deleted

Nov 4, 2011

I have a major problem my oracle_home/bin directory was delete mistakenly by on of our user. Because i cannot use all oracle utitilessqlplus,dbca,netca,netmgr. how do i the cover this problem?

View 2 Replies


ADVERTISEMENT

Oracle_Home Directory Recovery

Apr 21, 2011

If ORACLE_HOME Directory crash/lose then how ? is there any option to recovery ? if yes how?

View 2 Replies View Related

Client Tools :: SP2-0750 / Set ORACLE_HOME To Oracle Software Directory

Jan 29, 2010

bash: sqlplus: command not found
Error 6 initializing SQL*Plus
Message file sp1<lang>.msb not found
SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory

i install oracle 10gR and the process was successful i could do everything. the problem started when i install Zend Core for oracle, the install of zend was successful but i now can't start sqlplus.

View 18 Replies View Related

Server Administration :: Difference Between ORACLE_HOME And ORACLE_BASE?

Oct 3, 2011

what is

ORACLE_HOME
ORACLE_BASE

difference between ORACLE_HOME and ORACLE_BASE

View 1 Replies View Related

ODA Database Appliance Oakcli Create ORACLE_HOME

May 15, 2013

When using oakcli to create an oracle home in ODA, are there any parameters or configuration files to determine the directory to install the database software? I want to create 3 separate 11.2.0.3 ORACLE_HOMEs in these directories, all owned by the 'oracle' user..

/u01/app/db1/product/11.2.0.3/dbhome_1
/u01/app/db2/product/11.2.0.3/dbhome_1
/u01/app/db3/product/11.2.0.3/dbhome_1

But oakcli seems to accept only the version parameter:

oakcli create dbhome -h
Usage:
oakcli create dbhome [-version <version>]

where:
version - Version information for creating the database home.

That would install Oracle 11.2.0.3 into /u01/app/oracle/product/11.2.0.3/dbhome_1 only. The reason for the separate homes is for flexibility to patch them independently of each other (ie dependent on only the requirements of the products they support)

View 1 Replies View Related

Server Administration :: Core Dump Under $ORACLE_HOME / DBs

Oct 9, 2012

I saw big size .core file is generated in $ORACLE_HOME/dbs folder even when no dump dest parameter is set to dbs folder. How to check what causing this genrarating of these files.

PROD1 /oravl01/oracle/11.1.0.7/dbs > ls
1 core.11528 core.15973 core.22231 core.26792 core.29496 core.5262 initCCLCLMP.ora
controlfile.binary.PROD1.Fri core.12504 core.15981 core.2262 core.27129 core.29802 core.5847 initdw.ora
controlfile.binary.PROD1.Mon core.12520 core.1617 core.23115 core.27196 core.30793 core.6176 init.ora
controlfile.binary.PROD1.Sat core.1256 core.1626 core.23276 core.27531 core.30877 core.6221 initTESTCRM.ora
controlfile.binary.PROD1.Sun core.12594 core.16364 core.23681 core.27560 core.30885 core.6535 orapwPROD1

[code]....

View 7 Replies View Related

Server Administration :: How To Move Listener Log From ORACLE_HOME To DIAG_HOME

Jun 29, 2012

To one of my server i can see listener log are on normal location i.e. $ORACLE_HOME/network/log and on other server listener log is DIAG home. how to move listener log from ORACLE_HOME to DIAG_HOME.

oracle > lsnrctl status LISTENER
LSNRCTL for HPUX: Version 11.2.0.2.0 - Production on 29-JUN-2012 10:20:14
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for HPUX: Version 11.2.0.2.0 - Production
Start Date 03-MAY-2012 08:09:57
Uptime 57 days 0 hr. 10 min. 16 sec
[code]...

View 5 Replies View Related

Server Administration :: Information Regarding Latest Patch Installed For ORACLE_HOME

Feb 23, 2010

How do i find out the information regarding the latest patch installed for ORACLE_HOME..

OR

If given a patch number, how do i find out whether it's applied to ORACLE_HOME

View 1 Replies View Related

Rows Are Not Getting Deleted Using Purge

Nov 8, 2012

declare
min_as_of_dt date;
max_as_of_dt date := to_date('30-SEP-2012', 'DD-MON-YYYY');
begin
DBMS_OUTPUT.ENABLE(10000000);
[code]......

Problem: rows are not getting deleted after running this script.

View 1 Replies View Related

SQL & PL/SQL :: How To Take Backup Of Deleted Statement

Mar 27, 2012

i want to insert values in another table whatever i deleted. i don't want whole information like backup, i just want deleted information only. whenever any 1 will try to delete any information on my database ,easily i would get to know what,when he has deleted .

View 14 Replies View Related

SQL & PL/SQL :: Retrieve Deleted Rows

Jun 13, 2013

how to retrieve deleted rows in oracle?

View 7 Replies View Related

How To Know Exact Time Of Row Modified And Deleted

Jul 16, 2010

1)How can i know that in a table when i modified a row or deleted a row and which row i inserted when i want to know the particular time

can it is possiable if possiable then tell me how.

2)Is there any difference between 9i merge and 10g merge command ?

View 4 Replies View Related

SQL & PL/SQL :: Deleted All Records From Table - How To Get Back

Nov 8, 2010

I have deleted all the records from the table.And I have committed.Now I want to get all the records back.

View 16 Replies View Related

SQL & PL/SQL :: Find Out Tables That Are Frequently Getting Deleted?

Mar 25, 2012

How to find out the tables that are frequently getting deleted?

View 2 Replies View Related

SQL & PL/SQL :: Deleted Table In Oracle 11g - How To Restore

Mar 11, 2013

I deleted a table in oracle sql 11g about two weeks ago and commited. Didn't realise that I would need it later on and now I needed. is there a way a can get reverse this.

View 13 Replies View Related

Possible To Recover A Deleted Column Of A Table

Mar 18, 2011

I am new to oracle database. I wanted to know if it is possible to recover a deleted column of a table. If yes, how can it be done? I tried flashback but it seems that flashback doesn't support recovery of deleted column.

View 2 Replies View Related

SQL & PL/SQL :: List Records Being Deleted From All The Tables

Jan 10, 2011

I am executing a script that is deleting some parent records and the corresponding child records as I have used the "on delete cascade" with the Foreign key Constraint.

My question is that can I list the records that are being delete from all the tables i.e. both parent and child tables. Is some thing like spooling can work in this or do I have some other option with which I can see(select) all the deleted records.

View 12 Replies View Related

Restore Deleted Records From A Table

Jul 31, 2012

Somebody deleted records from 10,12 tables in one of the schema. I found in one of the forum that table can be restored also if it exists in the recycle bin. I checked by querying:

select object_name, original_name, type, can_undrop as "UND", can_purge as "PUR", droptime from recyclebin;

> select type, can_undrop as "UND", can_purge as "PUR", droptime from recyclebin WHERE TYPE='TABLE' and droptime like '%2012-07-31%';
PHONE      TABLE                 YES YES 2012-07-31:10:23:08
TABLE                 YES YES 2012-07-31:10:23:08
TABLE                 YES YES 2012-07-31:10:23:08
TABLE                 YES YES 2012-07-31:10:23:08
TABLE                 YES YES 2012-07-31:10:23:08
- -
- - I created a test table and dropped it and restored from recycle bin using following flashback table test query....but in my case tables are not dropped...these tables are shoing 0 records. How can I recover only records from recycle bin tables?
SQL> flashback table test to before drop;

Flashback complete.

DB=10.2.0.5 on RHL

View 6 Replies View Related

Reinsert Deleted Record By Using Same Trigger

Jan 24, 2013

I have a trigger which monitors the deletion activity on the table. But I would like to re-insert those records to the in the table using the same trigger.

View 1 Replies View Related

Create Trigger To Stop Events From Being Deleted

Jun 2, 2010

I am trying to create a trigger to stop events from being deleted if the date is before the current date. This is the SQL syntax for my table

CREATE TABLE event
(event_id numeric(5) not null,
concert_id numeric(5) not null,
event_date date,
);

What I have attempted so far is:

CREATE OR REPLACE TRIGGER event_deleting
BEFORE DELETE ON event
FOR EACH ROW
BEGIN
IF DELETING THEN
[code]......

This gives me a few warnings, the first is that a DECLARE is missing and the second is a INTO is missing.

View 1 Replies View Related

Cataloging Deleted RMAN Backup Pieces?

Oct 7, 2010

A full, online backup (database, archived redo logs, and control file autobackup) is done with rman ("nocatalog", Oracle 9i on AIX 5.2) daily. A media manger is not in use, so the backup is written to disk, then written to tape using an operating system utility. There is room on disk for two full backups, so "redundancy = 1" and obsolete backup sets are deleted to free up space immediately before running the next backup. If the backup(s) on disk are lost and the tapes containing these backups are lost, will it be possible to restore a tape containing older "deleted" backups (using an operating system utility) and catalog each backup piece in the current control file? In other words, can backups considered "deleted" in the control file be reintroduced if they're available on tape?

View 4 Replies View Related

Forms :: FRM 40102 Records Must Be Inserted Or Deleted First?

Jul 26, 2011

How to avoid this error. FRM 40102 Records must be inserted or deleted first

i have used next_record.If i remove this it is working.but i need to use next_record built in.

View 8 Replies View Related

Forms :: ERROR - Record Must Be Entered Or Deleted First

Jul 19, 2011

I'm getting below error. how can we avoid this error?

ERROR: frm-40102 record must be entered or deleted first

View 4 Replies View Related

Server Administration :: How To Remove Deleted Entry From Sys.ts$

Oct 15, 2011

### Changes made ###
1 week before we did a change on tablespace segment management - from MANUAL to AUTO by following method:
1. create INVD2 & INVX2 & LOBD tablespace.
2. Move TABLE from INVD to INVD2.
3. Rebuild INDEX from INVX to INVX2.
4. Move LOBSEGMENT from INVD to LOBD tablespace.
5. After confirm no segments exist in old tablespace, offline and drop INVD & INVX.
6. Change default tablespace for INV user to INVD2.
7. RENAME TABLESPACE INVD2 to INVD, INVX2 to INVX.
8. Change default tablespace for INV user to INVD back.
9. Run Gather Schema Stat for INV using UNIX scheduler which work usually. However, error ended with ORA-03113 & ORA-03114.
10. Manual execute with same statement the following day, procedure completed successfull.

After 1 week later, inventory forms detected error FRM-40735 in all forms. Checked the gather schema stat job was run in the morning before user feedback..

AFter refer notes from metalink, I understand this is a bug where RENAME of the tablespace could not rename as the previous one, as the deleted entry is still exist in sys.ts$?

There is no segments exist in the deleted tablespace, or any user default tablespace is assigned to the deleted tablespace.

My Question:How can we delete the deleted entry from sys.ts$?And should we rename the tablespace from INVD to INVD3 (or can we use back INVD2) to avoid any unforseen error again?

View 4 Replies View Related

Server Administration :: Bdump Dir Deleted / Cannot Get Cause Of Downtime

Sep 19, 2011

Is there any way I can find out what caused the database to crash; either a history of commands executed within the database, I lost my bdump directory before the scheduled backup ran and the only logs available are after I re-created the directory.

SQL> startup
ORA-00444: background process "PMON" failed while starting
ORA-07446: sdnfy: bad value '' for parameter .
SQL>
[code]....

View 4 Replies View Related

Backup & Recovery :: WARNING / Archived Log Not Deleted

Jan 23, 2012

I ran into the message RMAN-08138: WARNING: archived log not deleted - must create more backups during a backup. From what I understand this is caused when logs are removed that are needed for recovery.

rman target / nocatalog <<EOT
CONFIGURE CHANNEL DEVICE TYPE DISK clear ;
CONFIGURE CHANNEL DEVICE TYPE TAPE clear ;
CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' clear ;
CONFIGURE RETENTION POLICY TO recovery window of 14 days;
CONFIGURE BACKUP OPTIMIZATION OFF;
CONFIGURE DEFAULT DEVICE TYPE TO DISK;

[code].....

View 1 Replies View Related

A Datafile Deleted Belongs To Partitioned Table

Oct 11, 2012

A datafile was deleted from a partitioned table which has 31 partitions , that datafile contains data from day 25 to day 31 st I am not having a backups of this database. but I have all the dumps of that table what is the solution to get those 6 partitions data back.

View 9 Replies View Related

Application Express :: SQL Query Deleted After Editing

Nov 20, 2012

The SQL Query portion of Authorization Schemes are deleted or set to NULL after editing. Re-entering the SQL Query will not save the SQL, so the SQL Query is lost.

I had to update WWV_FLOW_SECURITY_SCHEMES.ATTRIBUTE_01 via sql to restore and modify the SQL Query portion of the Authorization Schemes.

View 0 Replies View Related

Create Trigger So That Whenever Record In Employee Table Deleted?

Dec 7, 2009

I'm trying to create a trigger so that whenever a record in the Employee table is deleted, a trigger will automatically delete corresponding records in the Job History table, then the Employee record is archived to EmployeeArchive before it is deleted. It compiles but with warnings. Here's what I've got.

CREATE TABLE EmployeeArchive
(EmployeeID Int, FirstName Char, LastName Char,
EMail Char, PhoneNumber Int, HireDate Date, JobID Char, Salary Int,
Commission Int, ManagerID Int, DepartmentID Char);

[Code]....

View 11 Replies View Related

Unable To Deleted Archive Log File On Windows Server?

Sep 20, 2010

version: 10.2.0.4
OS: windows server 2003

I am not able to delete one month old archive log file manually on windows which doesn't having info about the standby on v$archived_log view of primary database. the sequence were already applied to the standby database. It shows the status as deleted in v$archived_log. while deleting the file manually. it showing an error like another program or person is using it.

View 10 Replies View Related







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