[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 440
  • Last Modified:

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..
0
tomvv
Asked:
tomvv
  • 4
  • 3
1 Solution
 
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
 
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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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
 
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

Featured Post

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now