invalid input

[oracle@mac dbs]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.1.0 Production on Tue Sep 18 16:56:14 2012

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

SQL> conn / as sysdba
Connected to an idle instance.
SQL> startup
ORA-01078: failure in processing system parameters
LRM-00123: invalid character 128 found in the input file
SQL>



What is the reason for the input..
tomvvAsked:
Who is Participating?
 
slightwv (䄆 Netminder) Commented:
What database are you wanting to work with?  As I mentioned before it looks like there is a dat and sbi database on the server.

Are you wanting to startup a new database names orcl?

If not, you need to set ORACLE_SID to the correct database.
0
 
slightwv (䄆 Netminder) Commented:
By chance did you manually edit your spfile?  If so, that is the reason.  This is a binary file and you cannot edit it.

If you did, copy it to a known location and use it as a pfile.

cp myoldspfile.ora /tmp/mynewpfile.ora

then try:
startup pfile='/tmp/mynewpfile.ora';

if it starts:
create spfile from pfile='/tmp/mynewpfile.ora';
0
 
tomvvAuthor Commented:
I did not edit spfile..

From the below output it is clear that there is no spfile only initorcl.ora

[oracle@mac dbs]$ ls -ltr
total 9636
-rw-r--r-- 1 oracle oinstall    2851 May 15  2009 init.ora
drwx------ 2 oracle oinstall    4096 Aug 27 05:07 peshm_orcl_0
-rw-rw---- 1 oracle oinstall    1544 Aug 27 05:07 hc_orcl.dat
-rw-r----- 1 oracle oinstall      24 Aug 27 05:09 lkORCL
-rw-r----- 1 oracle oinstall    1536 Aug 27 05:18 orapworcl
drwx------ 2 oracle oinstall    4096 Aug 27 05:29 peshm_DBUA0_0
-rw-rw---- 1 oracle oinstall    1544 Aug 27 05:29 hc_DBUA0.dat
drwx------ 2 oracle oinstall    4096 Aug 27 05:43 peshm_bank_0
-rw-rw---- 1 oracle oinstall    1544 Aug 27 05:44 hc_bank.dat
-rw-r----- 1 oracle oinstall    1536 Aug 27 12:11 orapwbank
drwx------ 2 oracle oinstall    4096 Aug 27 23:09 peshm_sbi_0
-rw-rw---- 1 oracle oinstall    1544 Aug 27 23:10 hc_sbi.dat
-rw-r----- 1 oracle oinstall      24 Aug 27 23:11 lkSBI
-rw-r--r-- 1 oracle oinstall     919 Aug 28 02:21 Desktop
-rw-r--r-- 1 oracle oinstall     905 Aug 28 10:04 initsat.ora
drwx------ 2 oracle oinstall    4096 Aug 28 10:06 peshm_sat_0
-rw-rw---- 1 oracle oinstall    1544 Aug 28 10:07 hc_sat.dat
-rw-r--r-- 1 oracle oinstall       0 Aug 28 10:31 startup
-rw-r--r-- 1 oracle oinstall       0 Aug 28 10:31 shutdown
-rw-r--r-- 1 oracle oinstall       0 Aug 28 10:31 conn
-rw-r--r-- 1 oracle oinstall       0 Aug 28 10:31 exit
drwx------ 2 oracle oinstall    4096 Aug 28 10:42 peshm_dat_0
-rw-rw---- 1 oracle oinstall    1544 Aug 28 10:48 hc_dat.dat
-rw-r----- 1 oracle oinstall      24 Aug 28 13:58 lkDAT
-rw-r--r-- 1 oracle oinstall     878 Aug 28 14:43 initdat.ora
-rw-r----- 1 oracle oinstall    2560 Sep 12 00:18 spfiledat.ora
-rw-r--r-- 1 oracle oinstall     942 Sep 13 13:55 initorcl.ora
-rw-r----- 1 oracle oinstall 9748480 Sep 16 14:07 snapcf_sbi.f
-rw-r----- 1 oracle oinstall    2560 Sep 18 08:10 spfilesbi.ora
-rw-r----- 1 oracle oinstall    1536 Sep 18 08:14 orapwsbi
[oracle@mac dbs]$ ls


Also I tried to create like this too..

It did not work out....
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
slightwv (䄆 Netminder) Commented:
>>From the below output it is clear that there is no spfile only initorcl.ora

Based on your other questions, what is the database/instance you are working with?

ORCL is the 'default' that Oracle uses.  It looks like you have a 'dat' and an 'sbi' instance or did have at one time.

>>Also I tried to create like this too..

Did you forget to post something?
0
 
tomvvAuthor Commented:
ya I forgot

here is that..

the output is blank..

for this


SQL> create spfile from pfile='/u01/app/oracle/product/11.2.0/db_1/dbs/initorcl.ora'
0
 
slightwv (䄆 Netminder) Commented:
Assuming your database is ORCL:  What was the problem with that command?

That also doesn't answer the question of what is the database you are trying to work with?

What is the value of ORACLE_SID?  From a command prompt: echo $ORACLE_SID
0
 
tomvvAuthor Commented:
orcl
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.