Home » RDBMS Server » Server Administration » LRM-00101: unknown parameter name 'target' (oracle 11g)
LRM-00101: unknown parameter name 'target' [message #666403] Thu, 02 November 2017 12:07 Go to next message
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 Go to previous messageGo to next message
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.
Re: LRM-00101: unknown parameter name 'target' [message #666405 is a reply to message #666403] Thu, 02 November 2017 13:06 Go to previous messageGo to next message
John Watson
Messages: 8922
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?
Re: LRM-00101: unknown parameter name 'target' [message #666531 is a reply to message #666405] Sat, 11 November 2017 10:32 Go to previous messageGo to next message
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.
Re: LRM-00101: unknown parameter name 'target' [message #666532 is a reply to message #666531] Sat, 11 November 2017 11:25 Go to previous messageGo to next message
John Watson
Messages: 8922
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.
Re: LRM-00101: unknown parameter name 'target' [message #666564 is a reply to message #666403] Mon, 13 November 2017 11:36 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
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
Re: LRM-00101: unknown parameter name 'target' [message #666572 is a reply to message #666564] Tue, 14 November 2017 04:17 Go to previous messageGo to next message
gazzag
Messages: 1118
Registered: November 2010
Location: Bedwas, UK
Senior Member
What does the following yield?
SQL> SHOW PARAMETER PFILE
Re: LRM-00101: unknown parameter name 'target' [message #666573 is a reply to message #666572] Tue, 14 November 2017 04:38 Go to previous messageGo to next message
Roachcoach
Messages: 1576
Registered: May 2010
Location: UK
Senior Member
Show parameter won't work if it's not started.

@OP try:

sqlplus / as sysdba
startup pfile='&YOURPFILEPATH'
Re: LRM-00101: unknown parameter name 'target' [message #666574 is a reply to message #666573] Tue, 14 November 2017 04:43 Go to previous message
gazzag
Messages: 1118
Registered: November 2010
Location: Bedwas, UK
Senior Member
Roachcoach wrote on Tue, 14 November 2017 10:38
Show parameter won't work if it's not started.
Good point.
Previous Topic: Block change tracking in standby database
Next Topic: PGA memory exceeds PGA_AGGREGATE_LIMIT
Goto Forum:
  


Current Time: Thu Mar 28 10:35:05 CDT 2024