D:\oracle\product\10.2.0\db_1>sqlplus
SP2-1503: Unable to initialize
Oracle call interface
SP2-0152: ORACLE may not be
functioning properly
Windows 7 has this issue
Run sqlplus as administrator. I just right-clicked on the
shortcut for the gui app and selected "Run as Administrator" and
SQLPlus ran just fine. I'm not sure how to use this information to run it in
command mode but I'm sure it's possible
RMAN ERROR:
RMAN> connect target /
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-04002: ocipi failed, ORA--1
Solution :
Go to ORACLE_HOME/bin -> right click on the sqlplus.exe file and choose as Run as administrator.
SQL*Plus: Release 10.2.0.1.0 - Production on Mon Dec 19 20:38:26 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Enter user-name: / as sysdba
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> select name.open_mode from v$database
2 ;
select name.open_mode from v$database
*
ERROR at line 1:
ORA-00904: "NAME"."OPEN_MODE": invalid identifier
SQL> host
Microsoft Windows [Version 6.1.7600]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.
D:\oracle\product\10.2.0\db_1\BIN>rman
Recovery Manager: Release 10.2.0.1.0 - Production on Mon Dec 19 20:38:55 201
Copyright (c) 1982, 2005, Oracle. All rights reserved.
RMAN> connect target /
connected to target database: ORCL (DBID=1297918715)
RMAN ERROR:
RMAN> connect target /
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-04002: ocipi failed, ORA--1
Solution :
Go to ORACLE_HOME/bin -> right click on the sqlplus.exe file and choose as Run as administrator.
SQL*Plus: Release 10.2.0.1.0 - Production on Mon Dec 19 20:38:26 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Enter user-name: / as sysdba
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> select name.open_mode from v$database
2 ;
select name.open_mode from v$database
*
ERROR at line 1:
ORA-00904: "NAME"."OPEN_MODE": invalid identifier
SQL> host
Microsoft Windows [Version 6.1.7600]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.
D:\oracle\product\10.2.0\db_1\BIN>rman
Recovery Manager: Release 10.2.0.1.0 - Production on Mon Dec 19 20:38:55 201
Copyright (c) 1982, 2005, Oracle. All rights reserved.
RMAN> connect target /
connected to target database: ORCL (DBID=1297918715)