Link to home
Start Free TrialLog in
Avatar of tomvv
tomvv

asked on

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..
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

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';
Avatar of tomvv

ASKER

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....
>>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?
Avatar of tomvv

ASKER

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'
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
Avatar of tomvv

ASKER

orcl
ASKER CERTIFIED SOLUTION
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial