Home » RDBMS Server » Server Administration » ORA-02778: Name given for the log directory is invalid (windows 7, oracle 10.2)
ORA-02778: Name given for the log directory is invalid [message #515992] Thu, 14 July 2011 07:20 Go to next message
x-oracle
Messages: 345
Registered: April 2011
Location: gujarat
Senior Member
i have manualy create a database using this

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

2)Go to F:\oracle\product\10.2.0\admin\ORA10G 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,

Cool 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:\oracle\product\10.2.0\db_1\bin> set oracle_sid=ora10g

F:\oracle\product\10.2.0\db_1\bin>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:\ORACLE\PRODUCT\10.2.0\ADMIN\ORA10G\PFILE\INIT.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
orcl.__shared_pool_size=209715200
orcl.__streams_pool_size=0
*.audit_file_dest='D:\oracle\product\10.2.0/admin/orcl/adump'
*.background_dump_dest='D:\oracle\product\10.2.0/admin/orcl/bdump'
*.compatible='10.2.0.1.0'
*.control_files='D:\oracle\product\10.2.0\oradata\orcl\control01.ctl','D:\oracle\product\10.2.0\oradata\orcl\control02.ctl','D:\oracl e\product\10.2.0\oradata\orcl\control03.ctl'
*.core_dump_dest='D:\oracle\product\10.2.0/admin/orcl/cdump'
*.db_block_checking='TRUE'
*.db_block_size=8192
*.db_create_file_dest='D:\oracle\product\10.2.0\oradata'
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_flashback_retention_target=2880
*.db_name='orcl'
*.db_recovery_file_dest='D:\oracle\product\10.2.0/flash_recovery_area'
*.db_recovery_file_dest_size=2147483648
*.dispatchers='(PROTOCOL=TCP) (SERVICE=orclXDB)'
*.job_queue_processes=10
*.log_archive_dest_1='location=D:\oracle\product\10.2.0\oradata\archive'
*.log_archive_format='arcn_%t_%s_%r.arc'
*.O7_DICTIONARY_ACCESSIBILITY=TRUE
*.open_cursors=300
*.pga_aggregate_target=203423744
*.processes=150
*.remote_login_passwordfile='exclusive'
*.sga_target=612368384
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='D:\oracle\product\10.2.0/admin/orcl/udump'
===

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

init.ora
==

orcl.__db_cache_size=385875968
orcl.__java_pool_size=4194304
orcl.__large_pool_size=4194304
orcl.__shared_pool_size=209715200
orcl.__streams_pool_size=0
*.audit_file_dest='F:\oracle\product\10.2.0/admin/ORA10G/adump'
*.background_dump_dest='F:\oracle\product\10.2.0/admin/ORA10G/bdump'
*.compatible='10.2.0.1.0'
*.control_files='F:\oracle\product\10.2.0\oradata\ORA10G\control01.ctl','F:\oracle\product\10.2.0\oradata\ORA10G\control02.ctl','F:\o racle\product\10.2.0\oradata\ORA10G\control03.ctl'
*.core_dump_dest='F:\oracle\product\10.2.0/admin/ORA10G/cdump'
*.db_block_checking='TRUE'
*.db_block_size=8192
*.db_create_file_dest='F:\oracle\product\10.2.0\oradata'
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_flashback_retention_target=2880
*.db_name='ORA10G'
*.db_recovery_file_dest='F:\oracle\product\10.2.0/flash_recovery_area'
*.db_recovery_file_dest_size=2147483648
*.dispatchers='(PROTOCOL=TCP) (SERVICE=orclXDB)'
*.job_queue_processes=10
*.log_archive_dest_1='location=F:\oracle\product\10.2.0\oradata\archive'
*.log_archive_format='arcn_%t_%s_%r.arc'
*.O7_DICTIONARY_ACCESSIBILITY=TRUE
*.open_cursors=300
*.pga_aggregate_target=203423744
*.processes=150
*.remote_login_passwordfile='exclusive'
*.sga_target=612368384
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='F:\oracle\product\10.2.0/admin/ORA10G/udump'


Re: ORA-02778: Name given for the log directory is invalid [message #515993 is a reply to message #515992] Thu, 14 July 2011 07:23 Go to previous messageGo to next message
cookiemonster
Messages: 11068
Registered: September 2008
Location: Rainy Manchester
Senior Member
Most of the file names in your init.ora have a mixture of / amd \ for directory seperators. This is obviously wrong.
If the DB is on windows they should all be \
Re: ORA-02778: Name given for the log directory is invalid [message #515995 is a reply to message #515993] Thu, 14 July 2011 07:29 Go to previous messageGo to next message
x-oracle
Messages: 345
Registered: April 2011
Location: gujarat
Senior Member
OK I MODIFY IT
HERE IS MY THIS NEW INIT.ORA FILE

ORA10G.__db_cache_size=385875968
ORA10G.__java_pool_size=4194304
ORA10G.__large_pool_size=4194304
ORA10G.__shared_pool_size=209715200
ORA10G.__streams_pool_size=0
*.audit_file_dest='F:\oracle\product\10.2.0\admin\ORA10G\adump'
*.background_dump_dest='F:\oracle\product\10.2.0\admin\ORA10G\bdump'
*.compatible='10.2.0.1.0'
*.control_files='F:\oracle\product\10.2.0\oradata\ORA10G\control01.ctl','F:\oracle\product\10.2.0\oradata\ORA10G\control02.ctl','F:\o racle\product\10.2.0\oradata\ORA10G\control03.ctl'
*.core_dump_dest='F:\oracle\product\10.2.0\admin\ORA10G\cdump'
*.db_block_checking='TRUE'
*.db_block_size=8192
*.db_create_file_dest='F:\oracle\product\10.2.0\oradata'
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_flashback_retention_target=2880
*.db_name='ORA10G'
*.db_recovery_file_dest='F:\oracle\product\10.2.0\flash_recovery_area'
*.db_recovery_file_dest_size=2147483648
*.dispatchers='(PROTOCOL=TCP) (SERVICE=ORA10GXDB)'
*.job_queue_processes=10
*.log_archive_dest_1='location=F:\oracle\product\10.2.0\oradata\archive'
*.log_archive_format='arcn_%t_%s_%r.arc'
*.O7_DICTIONARY_ACCESSIBILITY=TRUE
*.open_cursors=300
*.pga_aggregate_target=203423744
*.processes=150
*.remote_login_passwordfile='exclusive'
*.sga_target=612368384
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='F:\oracle\product\10.2.0\admin\ORA10G\udump'
Re: ORA-02778: Name given for the log directory is invalid [message #515996 is a reply to message #515993] Thu, 14 July 2011 07:31 Go to previous messageGo to next message
x-oracle
Messages: 345
Registered: April 2011
Location: gujarat
Senior Member
AND SIR I JUST MODIFY MY EXISTING INIT.ORA FILE

I JUST CHANGE NAME IN THIS INIT.ORA FILE

STILL I HAVE GOT THIS SAME ERROR
Re: ORA-02778: Name given for the log directory is invalid [message #516000 is a reply to message #515996] Thu, 14 July 2011 07:46 Go to previous messageGo to next message
Littlefoot
Messages: 19678
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Quote:
ORA-02778
Name given for the log directory is invalid

Cause: The name given for the directory in which the logs are to be kept does not correspond to a directory.

Action: Use a different name.

Does this directory (F:\oracle\product\10.2.0\oradata\archive) exist?
Re: ORA-02778: Name given for the log directory is invalid [message #516001 is a reply to message #516000] Thu, 14 July 2011 07:51 Go to previous messageGo to next message
cookiemonster
Messages: 11068
Registered: September 2008
Location: Rainy Manchester
Senior Member
Do not post in all capital letters, it is considered shouting on internet forums.

Did you start up the DB with the init.ora file? Since you have created an spfile already (which will be wrong as well) oracle will use that to start up the DB unless you tell it not to.
Re: ORA-02778: Name given for the log directory is invalid [message #516127 is a reply to message #516001] Fri, 15 July 2011 03:11 Go to previous messageGo to next message
x-oracle
Messages: 345
Registered: April 2011
Location: gujarat
Senior Member
ok i have sucessfuly statup my database in nomount mode but when i run this create statement i got this error

SQL> CREATE DATABASE ORA10G
2 MAXLOGFILES 5
3 MAXLOGMEMBERS 3
4 MAXLOGHISTORY 100
5 MAXDATAFILES 50
6 MAXINSTANCES 1
7 LOGFILE
8 GROUP 1 ('F:\oracle\product\10.2.0\oradata\ORA10G\redo01.log') SIZE 50M,
9 GROUP 2 ('F:\oracle\product\10.2.0\oradata\ORA10G\redo02.log') SIZE 50M,
10 GROUP 3 ('F:\oracle\product\10.2.0\oradata\ORA10G\redo03.log') SIZE 50M
11 DATAFILE `F:\oracle\product\10.2.0\oradata\ORA10G\system01.dbf' SIZE 500M
12 AUTOEXTEND ON NEXT 10M
13 SYSAUX DATAFILE `F:\oracle\product\10.2.0\oradata\ORA10G\sysAUX01.dbf' SIZE
14 AUTOEXTEND ON NEXT 10M
15 DEFAULT TABLESPACE USERS
16 DATAFILE `F:\oracle\product\10.2.0\oradata\ORA10G\USERS01.dbf' SIZE 20M
17 AUTOEXTEND ON NEXT 1M
18 DEFAULT TEMPORARY TABLESPACE temp
19 TEMPFILE `F:\oracle\product\10.2.0\oradata\ORA10G\TEMP01.DBF' SIZE 1024M
20 AUTOEXTEND ON
21 UNDO TABLESPACE undotbs1
22 DATAFILE `F:\oracle\product\10.2.0\oradata\ORA10G\UNDOTBS01.dbf' SIZE 1024M
23 AUTOEXTEND ON
24 CHARACTER SET WE8MSWIN1252
25 /
DATAFILE `F:\oracle\product\10.2.0\oradata\ORA10G\system01.dbf' SIZE 500M
*
ERROR at line 11:
ORA-00911: invalid character

Re: ORA-02778: Name given for the log directory is invalid [message #516129 is a reply to message #516000] Fri, 15 July 2011 03:14 Go to previous messageGo to next message
x-oracle
Messages: 345
Registered: April 2011
Location: gujarat
Senior Member
thanks littlefoot yeah i checkout this and this directory does not exit and i create this directory in
F:\oracle\product\10.2.0\flash_recovery_area\ORA10G\ARCHIVELOG
and now i am succefuly startup my database in nomount mode

but i got this error when i run this above create database syntax.
so what i can do can u help me
Re: ORA-02778: Name given for the log directory is invalid [message #516130 is a reply to message #516129] Fri, 15 July 2011 03:19 Go to previous messageGo to next message
Littlefoot
Messages: 19678
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
This (line 11) is not a valid single quote:

11 DATAFILE `F:\oracle\product\10.2.0\oradata\ORA10G\system01.dbf' SIZE 500M

P.S. The same goes for other invalid single quotes, in other lines.

[Updated on: Fri, 15 July 2011 03:25]

Report message to a moderator

Re: ORA-02778: Name given for the log directory is invalid [message #516131 is a reply to message #516130] Fri, 15 July 2011 03:33 Go to previous messageGo to next message
Michel Cadot
Messages: 59405
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
To avoid such things/errors use only 2 tools: SQL*Plus and Notepad.

Regards
Michel
Re: ORA-02778: Name given for the log directory is invalid [message #516147 is a reply to message #516131] Fri, 15 July 2011 04:04 Go to previous messageGo to next message
x-oracle
Messages: 345
Registered: April 2011
Location: gujarat
Senior Member
michel yes i writed this in notepad

i type ed on sqlpromt and when notepad open i paste this all this in notepad then save it and i run this but error is same
Re: ORA-02778: Name given for the log directory is invalid [message #516149 is a reply to message #516147] Fri, 15 July 2011 04:08 Go to previous messageGo to next message
cookiemonster
Messages: 11068
Registered: September 2008
Location: Rainy Manchester
Senior Member
Have you fixed the typos Littlefoot pointed out?
Re: ORA-02778: Name given for the log directory is invalid [message #516155 is a reply to message #516147] Fri, 15 July 2011 04:40 Go to previous messageGo to next message
Michel Cadot
Messages: 59405
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
when notepad open i paste this

So you didn't write it in Notepad, so you didn't use only these 2 tools.
If you wrote it in Notepad you would not have this type of quote (unless you force it with its code point) and the would be valid.

Regards
Michel
Re: ORA-02778: Name given for the log directory is invalid [message #516159 is a reply to message #516130] Fri, 15 July 2011 04:44 Go to previous messageGo to next message
x-oracle
Messages: 345
Registered: April 2011
Location: gujarat
Senior Member
thanks again littlefoot for giving me helpful suggestion.now i got tis error

SQL> startup nomount
ORACLE instance started.

Total System Global Area 612368384 bytes
Fixed Size 1304728 bytes
Variable Size 218105704 bytes
Database Buffers 385875968 bytes
Redo Buffers 7081984 bytes
SQL> ed
Wrote file afiedt.buf

1 CREATE DATABASE ORA10G
2 MAXLOGFILES 5
3 MAXLOGMEMBERS 3
4 MAXLOGHISTORY 100
5 MAXDATAFILES 50
6 MAXINSTANCES 1
7 LOGFILE
8 GROUP 1 ('F:\oracle\product\10.2.0\oradata\ORA10G\redo01.log') SIZE 50M,
9 GROUP 2 ('F:\oracle\product\10.2.0\oradata\ORA10G\redo02.log') SIZE 50M,
10 GROUP 3 ('F:\oracle\product\10.2.0\oradata\ORA10G\redo03.log') SIZE 50M
11 DATAFILE 'F:\oracle\product\10.2.0\oradata\ORA10G\system01.dbf' SIZE 500M
12 AUTOEXTEND ON NEXT 10M
13 SYSAUX DATAFILE 'F:\oracle\product\10.2.0\oradata\ORA10G\sysAUX01.dbf' SIZE
14 AUTOEXTEND ON NEXT 10M
15 DEFAULT TABLESPACE USERS
16 DATAFILE 'F:\oracle\product\10.2.0\oradata\ORA10G\USERS01.dbf' SIZE 20M
17 AUTOEXTEND ON NEXT 1M
18 DEFAULT TEMPORARY TABLESPACE temp
19 TEMPFILE 'F:\oracle\product\10.2.0\oradata\ORA10G\TEMP01.DBF' SIZE 1024M
20 AUTOEXTEND ON
21 UNDO TABLESPACE undotbs1
22 DATAFILE 'F:\oracle\product\10.2.0\oradata\ORA10G\UNDOTBS01.dbf' SIZE 1024M
23 AUTOEXTEND ON
24* CHARACTER SET WE8MSWIN1252
SQL> /
CREATE DATABASE ORA10G
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced


SQL>
=====

and i am sending you my oradata directory snapshot
  • Attachment: ora.pdf
    (Size: 108.87KB, Downloaded 393 times)
Re: ORA-02778: Name given for the log directory is invalid [message #516161 is a reply to message #516159] Fri, 15 July 2011 04:46 Go to previous messageGo to next message
Michel Cadot
Messages: 59405
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.

Do not in image what can be posted in text and post it inline not as an attachment.

Have a look at alert.log it will tell you why the instance was shut down.

Regards
Michel

Re: ORA-02778: Name given for the log directory is invalid [message #516173 is a reply to message #516161] Fri, 15 July 2011 06:02 Go to previous messageGo to next message
x-oracle
Messages: 345
Registered: April 2011
Location: gujarat
Senior Member
michel its workig ok i use this

CREATE DATABASE ORA10G
MAXLOGFILES 5
MAXLOGMEMBERS 3
MAXLOGHISTORY 100
MAXDATAFILES 50
MAXINSTANCES 1
LOGFILE
GROUP 1 ('F:\oracle\product\10.2.0\oradata\ORA10G\redo01.log') SIZE 50M,
GROUP 2 ('F:\oracle\product\10.2.0\oradata\ORA10G\redo02.log') SIZE 50M,
GROUP 3 ('F:\oracle\product\10.2.0\oradata\ORA10G\redo03.log') SIZE 50M
DATAFILE 'F:\oracle\product\10.2.0\oradata\ORA10G\system01.dbf' SIZE 500M
AUTOEXTEND ON NEXT 10M
SYSAUX DATAFILE 'F:\oracle\product\10.2.0\oradata\ORA10G\sysAUX01.dbf' SIZE 30M
AUTOEXTEND ON NEXT 10M
DEFAULT TABLESPACE USERS
DATAFILE 'F:\oracle\product\10.2.0\oradata\ORA10G\USERS01.dbf' SIZE 20M
AUTOEXTEND ON NEXT 1M
DEFAULT TEMPORARY TABLESPACE temp
TEMPFILE 'F:\oracle\product\10.2.0\oradata\ORA10G\TEMP01.DBF' SIZE 1024M
AUTOEXTEND ON
UNDO TABLESPACE undotbs1
DATAFILE 'F:\oracle\product\10.2.0\oradata\ORA10G\UNDOTBS01.dbf' SIZE 1024M
AUTOEXTEND ON
CHARACTER SET WE8MSWIN1252
/
Re: ORA-02778: Name given for the log directory is invalid [message #516176 is a reply to message #516161] Fri, 15 July 2011 06:06 Go to previous messageGo to next message
x-oracle
Messages: 345
Registered: April 2011
Location: gujarat
Senior Member
now i successfuly create database now can you tell me how can i create oracle enterprise manager.
Re: ORA-02778: Name given for the log directory is invalid [message #516199 is a reply to message #516176] Fri, 15 July 2011 08:04 Go to previous messageGo to next message
Michel Cadot
Messages: 59405
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Did you have a look at the documentation?

Regards
Michel
Re: ORA-02778: Name given for the log directory is invalid [message #516290 is a reply to message #516199] Sat, 16 July 2011 03:28 Go to previous messageGo to next message
x-oracle
Messages: 345
Registered: April 2011
Location: gujarat
Senior Member
michel i search this google but i cannot find complete solution how can i create enterprise manually.

so can you give me any usefull link so with the help of this i can manually create enterprise manager
Re: ORA-02778: Name given for the log directory is invalid [message #516312 is a reply to message #516290] Sat, 16 July 2011 09:47 Go to previous message
Michel Cadot
Messages: 59405
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
http://www.oracle.com/pls/db102/portal.portal_db?selected=21

Regards
Michel

Previous Topic: Total No of files in FRA
Next Topic: rare log archiization issue
Goto Forum:
  


Current Time: Mon Oct 20 21:52:54 CDT 2014

Total time taken to generate the page: 0.10775 seconds