Sqlplus component is accidentally compromised recovery test

Sqlplus component is accidentally damaged and restored

Did not react after executing sqlplus/as sysdba command, a little strangeness ...
[[email protected] bin] #sqlplus/as sysdba
[Email protected] bin]# Ls-trl
...
-rwxr-x--x 1 Oracle Oinstall 0 DEC 9 15:52 sqlplus-------This file was written empty.
...

Recovery test:
Copy a sqlplus from Oracle 11201 and test after you have modified the permissions:

[Email protected] bin]# Ls-trl
-rwxr-x--x 1 Oracle oinstall 9197 DEC 10:26 sqlplus
[Email protected] ~]$ Sqlplus/as SYSDBA
Sp2-1503:unable to initialize Oracle call interface
Sp2-0152:oracle May is not functioning properly
[Email protected] ~]$


Official explanation of the above error:
01503,0, "Unable to initialize Oracle call interface\n"
*cause:indicates a library used by Sql*plus-communicate with
The database failed to initialize correctly.
*action:check that the Oracle environment or registry entries is
Consistent and correct. If using the Sql*plus Instant Client
Make sure the Sql*plus and Oracle libraries is from the
Same release. Make sure has read access to the libraries.


00152,0, "ORACLE May is not functioning properly\n"
*cause:unable to initialize a session to the Oracle instance.
*action:make a note of the message and the number, then contact
The Database Administrator.


From the information of the error, the main reason is that Sqlplus cannot invoke the normal Lib library file, so it cannot communicate with Oracle (RDBMS) in the/bin/directory;
So if you're copying a sqlplus component from the same version of the Oracle database on the same platform, maybe it'll work?
[Email protected] bin]# Ls-trl
...
-rwxr-x--x 1 Oracle oinstall 7725 DEC 10:29 sqlplus


Test again:
[Email protected] bin]$!sql
Sqlplus/as SYSDBA
Sql*plus:release 10.2.0.3.0-production on Wed Dec 24 10:30:18 2014
Copyright (c) 1982, 2006, Oracle. All rights Reserved.
Connected to an idle instance.


Sql> Startup

ORACLE instance started.

Total System Global area 583008256 bytes
Fixed Size 2074440 bytes
Variable Size 436209848 bytes
Database buffers 138412032 bytes
Redo buffers 6311936 bytes
Database mounted. --------Database can start normally
Database opened.


A little violent, but does it feel like a database?
sql> Startup force
ORACLE instance started.
Total System Global area 583008256 bytes
Fixed Size 2074440 bytes
Variable Size 440404152 bytes
Database buffers 134217728 bytes
Redo buffers 6311936 bytes
Database mounted.
Database opened.


Sql> Show parameter Dump
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
Background_core_dump string Partial
Background_dump_dest String/oracle/admin/lixora/bdump
Core_dump_dest String/oracle/admin/lixora/cdump
Max_dump_file_size string 1024
Shadow_core_dump string Partial
User_dump_dest String/oracle/admin/lixora/udump
Sql> select Open_mode from V$database;
Open_mode
----------
READ WRITE

Sql> SELECT * from dual;
D
-
X




Everything OK, here comes an idea, if Rman or DBCA or NETCA .... Accidental damage, is it possible to replace the solution by the method? Find the opportunity to measure

Sqlplus component is accidentally compromised recovery test