ORA-02778 / Name Given For The Log Directory Is Invalid

May 6, 2008

I 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]....

View 5 Replies


ADVERTISEMENT

Server Administration :: ORA-02778 - Name Given For Log Directory Is Invalid

Jul 14, 2011

i have manualy create a database using this

1)ORACLE_SID=ORA10G... (set into Env variable )

2)Go to F:oracleproduct10.2.0adminORA10G create new folder (ORA10G)

3) In ORA10G create new all folders adump,bdump,cdump,dpdump,pfile,udump

4) In pfile take a copy of existing init.ora from my orcl databse

5) Change this init.ora

6) Change parameters

7) db_name , instance_name ,control_files ,background_dump

dest,user_dump_dest,

save this file as "init.ora"

9) Create new folder in Oradata --- "ORA10G"

10) create service
Oradim NEW SID ORA10G SYSPWD ORACLE STARTMODE AUTO SPFILE

11) then i have check service is started or not in Control panel- administrative tools - sevices--OracleserviceORA10g---started

12) i have Shut down previously started database

13) Connect to SQL promp

F:oracleproduct10.2.0db_1in> set oracle_sid=ora10g

F:oracleproduct10.2.0db_1in>SQLPLUS

SQL*Plus: Release 10.2.0.5.0 - Production on Thu Jul 14 16:46:59 2011

Copyright (c) 1982, 2010, Oracle. All Rights Reserved.

Enter user-name: SYS AS SYSDBA
Enter password:
Connected to an idle instance.

14)than create spfile
SQL> CREATE SPFILE FROM PFILE = 'F:ORACLEPRODUCT10.2.0ADMINORA10GPFILEINIT.ORA';

File created.

15) than i have run this command

SQL> startup nomount
ORA-02778: Name given for the log directory is invalid

==
i have attached my orcl init.ora file and my new init.ora file also here
======
my orcl init.ora file here that i have used here for this database
====

initorcl.ora
===========
orcl.__db_cache_size=385875968
orcl.__java_pool_size=4194304
orcl.__large_pool_size=4194304

[Code].....

View 19 Replies View Related

SQL & PL/SQL :: ORA-29280 / Invalid Directory Path

May 13, 2012

I 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.

View 2 Replies View Related

PL/SQL :: ORA-29280 / Invalid Directory Path

Sep 9, 2013

When 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].....

View 1 Replies View Related

PL/SQL :: Error / ORA-29280 / Invalid Directory Path

Apr 9, 2013

When 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;

[code]....

View 11 Replies View Related

PL/SQL :: Utl_file  ORA-29280 - Invalid Directory Path

Aug 26, 2012

I am testing to find out that by using utl_file, if I finish reading all the entries in the file, then I encounter no_data_found, just want to make sure I get no data found when all entries in the file are read

SQL> create or replace directory my_docs as 'c:photos';

create or replace procedure myproc is

v_line VARCHAR2(2000); -- Data line read from input file
v_file UTL_FILE.FILE_TYPE; -- Data file handle
v_dir VARCHAR2(250) := 'my_docs'; -- Directory containing the data file

[Code]....

/so I execute this procedure and I get

ERROR at line 1:
ORA-29280: invalid directory path
ORA-06512: at "SYS.UTL_FILE", line 33
ORA-06512: at "SYS.UTL_FILE", line 436
ORA-06512: at "MYPROC", line 12
ORA-06512: at line 2

View 8 Replies View Related

SQL & PL/SQL :: How To Get The File Name From Directory

Dec 12, 2012

How to get the file name from directory without Java. Is there any way to do it in Pl/Sql.

View 13 Replies View Related

SQL & PL/SQL :: XML Not Saving In A Particular Directory

Jul 16, 2013

I 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!!

View 4 Replies View Related

Using Different Directory For Expdp

Apr 17, 2013

For 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 Related

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

Active Directory Integration With EBS

Jun 3, 2013

I 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 Related

Authenticate 10g Through Active Directory?

Aug 19, 2009

I am trying to authenticate Oracle 10g through Active Directory ..But i am not able to do that successfully...

View 2 Replies View Related

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 View Related

Accessing File From Directory?

Oct 7, 2009

have 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]...

View 1 Replies View Related

SQL & PL/SQL :: Accessing Scripts From Different Directory?

Jun 30, 2010

I 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.

View 6 Replies View Related

SQL & PL/SQL :: Generates CSV File In Directory

Feb 17, 2012

This 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 Related

SQL & PL/SQL :: Retrieve The Path Of A Directory

Oct 27, 2011

I create a directory using this:

CREATE DIRECTORY xml_data AS 'c:\mytest';

How can I retrieve the 'C:mytest' in a select statement?

View 5 Replies View Related

Creating Table In A Directory

May 2, 2013

I 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?

View 3 Replies View Related

Possible To Export Data To Another Directory Other Than Datapump

Sep 8, 2013

Is it possible to export data to another directory other than datapump default directory(DATA_PUMP_DIR) in Linux.

View 5 Replies View Related

Forms :: 10g Error In Writing To Directory

Apr 12, 2006

I'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) .

View 7 Replies View Related

Forms :: Read Set Of Files From A Directory

Apr 28, 2011

Am 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 ]

View 1 Replies View Related

Forms :: Read Image From A Directory?

Mar 16, 2013

I 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

View 1 Replies View Related

SQL & PL/SQL :: Executing Script Files In A Directory?

Feb 16, 2010

Using 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].....

View 5 Replies View Related

PL/SQL :: Loading Data From Local Directory

Jan 22, 2013

I 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 Related

Server Utilities :: Reg Database Directory

Feb 12, 2013

On 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 .

View 3 Replies View Related

There Is No File Audit In Adump Directory

Jan 6, 2013

I 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

View 8 Replies View Related

Security :: Oracle Internet Directory Tables

May 5, 2011

Does any technical details on the tables found in Oracle Internet Directory? I've checked eTRM and google etc.. - nothing there apart from very minor snippets. I'd like logical schema drawings (PDF) if possible or even a list of the tables and what they do as like the modules in EBS.

View 3 Replies View Related

Server Administration :: Database Directory Permission

Feb 4, 2011

My database is running in oracle 10g. I have more than 25 oracle directories which are being used for batch/reporting jobs. I found read and write privileges are missing for 7 Dirs. I checked the last ddl time, it shows Jan 26th.

I want know how to check which userid revoked it.

View 4 Replies View Related

Enterprise Manager :: Setup - No Such File Or Directory

Jun 17, 2010

This is the error message iam getting when trying to open EM... Im new to DBA and also to this DB....

[sandeep@Linux4 ~]$ emctl start dbconsole
TZ set to US/Eastern

Unable to locate file /home/sandeep/oracle/product/10.2.0/db_1/Linux4.localdomain.com_orcl/sysman/config/emd.properties : No such file or directory

View 16 Replies View Related

Forms :: Create Directory With Oracle Form PL/SQL

Jan 16, 2010

i want to know how to create directory or folder which use pl/sql coding in oracle developer suite10g

my problem is when i use this code

trigger WHEN-BUTTON-PRESSED

EXECUTE IMMEDIATE 'CREATE OR REPLACE DIRECTORY'||'C:RESTAURANT';

IT'S ERROR WITH "Error591 this feature is not supported in client-side programs"

I used to use function with webutil that's webutil_file.create_directory('c:RESTAURANT');

trigger WHEN-BUTTON-PRESSED

WEBUTIL_FILE.CREATE_DIRECTORY('c:RESTAURANT');

BUT STILL HAVE ERROR WITH "Error 221 'CREATE_DIRECTORY' is not a procedure or is undefined "

How to create directory with pl/sql that's use in oracle form in trigger when-button-pressed or how to use function webutil_file.create_directory();

View 9 Replies View Related







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