OraFAQ Forum: Server Administration » LRM-00101: unknown parameter name 'target'

Home » RDBMS Server » Server Administration » LRM-00101: unknown parameter name 'target' (oracle 11g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

LRM-00101: unknown parameter name 'target' [message #666403]

Thu, 02 November 2017 12:07

Pierretom
Messages: 1
Registered: November 2017

Junior Member

please I,m a new dba , I,m trying to install database manually with nomount and this is what I,m getting

SQL> startup nomount
ORA-01078: failure in processing system parameters
LRM-00101: unknown parameter name 'target'
SQL>

as supplement information this is what I have in initprod.ora

db_name=prod
memory_target=500m
control_files='/disk1/prod/control/control01.ctl','disk1/prod/control/control02.ctl' 
diagnostic_dest='/disk1/prod/diag'
compatible=11.2.0

please help

[Updated on: Mon, 13 November 2017 11:32] by Moderator

Report message to a moderator

Re: LRM-00101: unknown parameter name 'target' [message #666404 is a reply to message #666403]

Thu, 02 November 2017 12:13

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Welcome to this forum

Please read and follow the forum guidelines, to enable us to help you:
OraFAQ Forum Guide
How to use {code} tags and make your code easier to read

Since you are anew DBA, I suggest that you use dbca to CREATE DATABASE.

post URL that documents the approach you have tried.

Report message to a moderator

Re: LRM-00101: unknown parameter name 'target' [message #666405 is a reply to message #666403]

Thu, 02 November 2017 13:06

John Watson
Messages: 8960
Registered: January 2010
Location: Global Village

Senior Member

I see twp possibilities:
Either you are not using the initialization file that you think you are using, or you have some unprintable characters in that file that make Oracle see a line break in memory_target.
I would begin by deleting that file. What error do you get then?

Report message to a moderator

Re: LRM-00101: unknown parameter name 'target' [message #666531 is a reply to message #666405]

Sat, 11 November 2017 10:32

ZeeshanAwan
Messages: 2
Registered: November 2017

Junior Member

Dear Member,
BlackSwan replied is the best answer that you should use DBCA. Why?

1. You can say that in Oracle DB there are two DBs are running logically, One database which you can say metadata and second is users DB (Users schemas) and Metadata (Sys Schema. SysAUX Schema and more system users) which are keeping information for user schemas for DDLs, DMLs and DCLs. and it is not just a simple database lot of things involved like security, audits links and rights so on. The best is to create using DBCA.

Report message to a moderator

Re: LRM-00101: unknown parameter name 'target' [message #666532 is a reply to message #666531]

Sat, 11 November 2017 11:25

John Watson
Messages: 8960
Registered: January 2010
Location: Global Village

Senior Member

Welcome to the forum. Please read our OraFAQ Forum Guide and How to use [code] tags and make your code easier to read

I know that you are trying to assist, but your descrption couldo cause a lot of confusion. It would be more accurate to say that in an Oracle database there is a data dictionary owned by the SYS user which contains all the Oracle supplied objects and the metadata describing user created objects.
Are you perhaps drawing an analogy with SQL Server? I have heard SQL Server people say that an Oracle schema is like a SQL Server database.

Report message to a moderator

Re: LRM-00101: unknown parameter name 'target' [message #666564 is a reply to message #666403]

Mon, 13 November 2017 11:36

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Works for me. I would try the prior suggestions. Your init file has issues.

SQL> startup nomount
ORACLE instance started.

Total System Global Area  524288000 bytes
Fixed Size		    8622624 bytes
Variable Size		  415239648 bytes
Database Buffers	   92274688 bytes
Redo Buffers		    8151040 bytes
SQL> !cat inittest.ora
db_name=test
memory_target=500m
control_files=/tmp/1.ctl
diagnostic_dest=/u01/diag
compatible=11.2.0

Report message to a moderator