Oracle_Home Directory Recovery
Apr 21, 2011If ORACLE_HOME Directory crash/lose then how ? is there any option to recovery ? if yes how?
View 2 Replies
ADVERTISEMENT
Oracle_home / Bin Directory Deleted
Nov 4, 2011I 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 View RelatedClient Tools :: SP2-0750 / Set ORACLE_HOME To Oracle Software Directory
Jan 29, 2010bash: 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.
Backup & Recovery :: RMAN Deleting Backup Directory
May 5, 2013i have a database (test1 10gr2 ) on rhel 5.5 and am using ASM (raw devices). for this database i have arch location as
log_archive_dest_1='location=+DG_ARC/arch'
My backup location is +DG_bak/test1.
Now when i run rman backup (nocatalog mode).. backup database plus archivelog delete input; it completes successfully but deletes the arch directory from +DG_ARC diskgroup and when i switch logfile it hangs ... alert log says unable to find archive destination. this thing is driving me nuts not sure why arch directory is being deleted. but when i get into asmcmd and manually create the arch directory logswitch takes place now.
Server Administration :: Difference Between ORACLE_HOME And ORACLE_BASE?
Oct 3, 2011what is
ORACLE_HOME
ORACLE_BASE
difference between ORACLE_HOME and ORACLE_BASE
ODA Database Appliance Oakcli Create ORACLE_HOME
May 15, 2013When 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)
Server Administration :: Core Dump Under $ORACLE_HOME / DBs
Oct 9, 2012I 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]....
Server Administration :: How To Move Listener Log From ORACLE_HOME To DIAG_HOME
Jun 29, 2012To 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]...
Server Administration :: Information Regarding Latest Patch Installed For ORACLE_HOME
Feb 23, 2010How 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
SQL & PL/SQL :: How To Get The File Name From Directory
Dec 12, 2012How to get the file name from directory without Java. Is there any way to do it in Pl/Sql.
View 13 Replies View RelatedSQL & PL/SQL :: XML Not Saving In A Particular Directory
Jul 16, 2013I want to create a xml file for a particular query and i have used the following
SELECT DBMS_XMLGEN.getXML('SELECT * FROM EMPL_NEW') FROM dual:
the output of this is
<?xml version="1.0"?>
<ROWSET>
<ROW>
<ENO>10001</ENO>
<ENAME>rajkumar</ENAME>
[Code]....
and i need to save this as .xml file in a particular file directory in client machine and i have coded like this
DECLARE
F UTL_FILE.FILE_TYPE;
MYCLOB CLOB;
DIR_STR varchar2(100);
BEGIN
DIR_STR:='XML';
SELECT
DBMS_XMLGEN.GETXML('
[Code]...
XML is the name of directory name i have created in my user and I have also created the directory manually in D:/xml.
UTL_FILE package access given to public..
but still this error(refer the pic) exists!!
Using Different Directory For Expdp
Apr 17, 2013For now we have a directory defined as /exp wherein we do the export using expdp. Can we define a new directory and use this directory for expdp.
View 3 Replies View RelatedActive Directory Integration With EBS
Jun 3, 2013I have task to integrate AD users with oracle ebs r12 . Is there any mechanism to do it directly without OID between oracle ebs and Active directory during login to ebs or i have to install OID to finish that task .
View 1 Replies View RelatedAuthenticate 10g Through Active Directory?
Aug 19, 2009I am trying to authenticate Oracle 10g through Active Directory ..But i am not able to do that successfully...
View 2 Replies View RelatedORA-02778 / Name Given For The Log Directory Is Invalid
May 6, 2008I restored a date in my database (the backup of that date was taked by a snap on Windows Server 2003), now I try to startup the database it gives me the following error
ORA-02778: Name given for the log directory is invalid
here is a copy of my spfile
*.background_dump_dest='H:\oracle\oradata\gdwh2401\BDUMP'
*.bitmap_merge_area_size=16777216
*.cluster_database=FALSE
*.compatible='9.2.0.0.0'
*.control_files='G:\oracle\oradata\DWHLIVE\CONTROL01.CTL','H:\oracle\oradata\DWHLIVE\CONTROL02.CTL','I:\oracle\oradata\DWHLIVE\CONTROL03.CTL'
*.core_dump_dest='H:\oracle\oradata\gdwh2401\CDUMP'
[code]....
this is a picture of my alert_log file
Tue May 06 09:42:15 2008
Starting background process EMN0
EMN0 started with pid=53, OS id=13704
Tue May 06 09:42:16 2008
Shutting down instance: further logons disabled
Tue May 06 09:42:18 2008
Stopping background process QMNC
Tue May 06 09:42:19 2008
[code]....
Accessing File From Directory?
Oct 7, 2009have a log file in unix server under(/usr/home/oraj/log/abc.log) I am trying to access from oracle stored procedure as fallows
src_clob BFILE := BFILENAME('/usr/home/oraj/log', 'abc.log');
Exception:
ERROR at line 1:
ORA-22285: non-existent directory or file for FILEOPEN operation
ORA-06512: at "SYS.DBMS_LOB", line 716
ORA-06512: at "usr.LOAD_CLOB_FROM_XML_FILE", line 39
ORA-06512: at line 1
I dont want to create directory as such ('/usr/home/oraj/log') as it is already exists and all log files sits there.
CREATE OR REPLACE PROCEDURE Load_CLOB_From_XML_File
IS
dest_clob CLOB;
src_clob BFILE := BFILENAME('/usr/home/oraj/log/', 'abc.log');
dst_offset number := 1 ;
src_offset number := 1 ;
[code]...
SQL & PL/SQL :: Accessing Scripts From Different Directory?
Jun 30, 2010I have customized my sqlprompt. I put the code for that in a script p.sql.
Now I log into sql from multiple directories as I have different scripts in different directories. How do I access p.sql which is not in the currect directory.
Also I wanted to know if I could change directories from the sql prompt.
SQL & PL/SQL :: Generates CSV File In Directory
Feb 17, 2012This generates a CSV file in an directory. When it runs for the 1st time it take SYSDATE -7 data. After the 1st run it appends the data since the last run. Now my problem is the appending happens at the bottom of the file and every time the header appears. I want the header only the first time and the new data should keep appending at the top so that i get the latest data always at the top.
View 18 Replies View RelatedSQL & PL/SQL :: Retrieve The Path Of A Directory
Oct 27, 2011I create a directory using this:
CREATE DIRECTORY xml_data AS 'c:\mytest';
How can I retrieve the 'C:mytest' in a select statement?
Creating Table In A Directory
May 2, 2013I have a directory defined as TDM_IN where a directory has been created. There is a table which has been created as
create table abc.IFP_GRP_D_INT
(
IFP_GRP_DIM_KEY VARCHAR2(10),
.....
[Code]...
Now how can i select the records from this table?
Possible To Export Data To Another Directory Other Than Datapump
Sep 8, 2013Is it possible to export data to another directory other than datapump default directory(DATA_PUMP_DIR) in Linux.
View 5 Replies View RelatedForms :: 10g Error In Writing To Directory
Apr 12, 2006I'm trying to install forms 10g on my windows 2000 professional os which is having oracle 9i client. but while installing 10g i'm geting oracle universal installer error. error in writing to directory c:...
My D drive is having 10GB free space and C drive is having 800MB free space (both drive have normal attribute i.e it's not read only ) and oracle have already copied some temp files in C drive (size 13.6 MB) .
Forms :: Read Set Of Files From A Directory
Apr 28, 2011Am creating a form for some processing text files available in a local users system. Now I would like to get the directory name from the user using dialog box and read the files
[ I am already reading the file, but I allow the user to select the specific file name using get_file_name ]
Forms :: Read Image From A Directory?
Mar 16, 2013I have 100 image file in C:My_PIC/ i want read these image files and put in a table .
My table have 2 column : Id_pic varchar2(20) ,
PIC BLOB
I want read all files in C:MY_PIC and Insert in My table with a BUTTON in My form
ID_PIC = file name
PIC = image
SQL & PL/SQL :: Executing Script Files In A Directory?
Feb 16, 2010Using PL/SQL I want to search inside a directory and execute the script files with a specific pattern.
I know that with @@ command I can execute a script, however when the name of the files come in a variable I don't know how to execute the script.
Here is the code for searching the files:
set serveroutput on
declare
directory2 varchar2(1024):='/home/oracle/dir';
[Code].....
SQL & PL/SQL :: ORA-29280 / Invalid Directory Path
May 13, 2012I started working on utl_files. When i Am working on this topic I struck with an error: Quote:ORA-29280: invalid directory path. Below are the steps I followed to work on utl_files,
STEP1: connect sys as sysdba
STEP2: @$ORACLE_HOME/rdbms/admin/utlfile.sql
STEP3: create or replace directory utl_data_files as '/home/oracle/siva/data/'; --(the directory path is already exists in the OS)
STEP4: below is the code
DECLARE
out_file UTL_FILE.file_type;
linebuf varchar2(1999);
directory_name varchar2(100):='utl_data_files';
BEGIN
out_file:=UTL_FILE.fopen(directory_name,'emp.dat','W');
for emp_cur in (SELECT * FROM scott.EMP)
[code].....
STEP5: then it's giving the below result/error info
Quote:
SQL ERRORCODE IS:-29280
SQL ERROR MSG IS:ORA-29280: invalid directory path
PL/SQL procedure successfully completed.
PL/SQL :: ORA-29280 / Invalid Directory Path
Sep 9, 2013When i am running the below script i am getting error like Invalid directory path. how to check the path by using dbms_ouput.
error : ORA-29280: invalid directory path
ORA-06512: at line 34
DECLARE
l_out_file UTL_FILE.file_type;
g_convert_crlf BOOLEAN := TRUE;
P_DATA VARCHAR2(32767);
l_buffer VARCHAR2(32767);
l_amount BINARY_INTEGER := 32767;
l_pos INTEGER := 1;
[code].....
PL/SQL :: Loading Data From Local Directory
Jan 22, 2013I have a requirement like, I received .dat files and placed in my local directory and there is a process/method where this data which is there in .dat file will insert into my oracle external tables?Any link of the example with clear steps?
View 9 Replies View RelatedServer Utilities :: Reg Database Directory
Feb 12, 2013On last week we have migrated our oracle database from 9i to 10g through imp utility ,but now i have facing one small issue where as new have our old live database with us and suppose we have fired
"SELECT* FROM V$PARAMETER WHERE NAME LIKE 'utl%'"
to check directory name and valus then in output its shown name:-utl_file_dir and valus:-E:RAB but in our new database its does not shown any value like E:RAB in migrated database as i have recreated that directory in new database but still that issue persist .
There Is No File Audit In Adump Directory
Jan 6, 2013I have an issue when I enable auditing feature in oracle,I use 'DB' to store the audit from user in oracle, my command is
SQL>alter system set audit_trail=db scope=spfile;
SQL>shutdown immediate;
SQL>startup;
in show parameter audit, I see that the audit_trail already changed to DB after I create a user and enable audit for this user, I can see in the audit table dba_audit_trail for insert, update, delete,etc but If I am not wrong, if I using DB to setting the audit parameter then I will get audit file both in oracle table and in adump oracle folder installation, but in my case I cannot find any file in adump directory.
my operating system is windows7 and I use oracle database 10g express edition