SQLPLUS Fails With SP2-1503 SP2-0152 After New 11.2 Installation解決
今天準備測試一下10g升級到11g的場景,裝完10g的,然後再裝11g的服務端。sqlplus就報錯了。
因為ORACLE_BASE,ORACLE_HOME已經改過來了。但是怎麼試都不行。
查了metalink,上面說可能是因為$ORACLE_HOME/oracore/zoneinfo的許可權可能有問題,我一條一條比對了下,沒發現許可權有問題。
metaLink:
SQLPLUS Fails With SP2-1503 SP2-0152 After New 11.2 Installation [ID 974515.1] |
不經意間切換使用者,發現原來切換使用者就能夠搞定。
[ora10g@centos ~]$ sqlplus
SP2-1503: Unable to initialize Oracle call interface
SP2-0152: ORACLE may not be functioning properly
[ora10g@centos ~]$ su - ora10g
Password:
[ora10g@centos ~]$ sqlplus
SQL*Plus: Release 10.2.0.1.0 - Production on Sat Jul 6 07:37:59 2013
Copyright (c) 1982, 2005, Oracle. All rights reserved.
然後切換回11g
修改 .bash_profile
# User specific environment and startup programs
export ORACLE_BASE=/u01/app/upg11g
#export ORACLE_BASE=/u01/app/ora10g
#export ORACLE_HOME=$ORACLE_BASE/product/10.2/db_1
export ORACLE_HOME=$ORACLE_BASE/product/11.2/db_home1
[ora10g@centos ~]$ source .bash_profile
[ora10g@centos ~]$ sqlplus
SP2-1503: Unable to initialize Oracle call interface
SP2-0152: ORACLE may not be functioning properly
[ora10g@centos ~]$ su - ora10g
Password:
[ora10g@centos ~]$ sqlplus
SQL*Plus: Release 11.2.0.1.0 Production on Sat Jul 6 07:44:59 2013
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Enter user-name:
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/23718752/viewspace-765659/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Post Installation for Databases Created after Installation of 10.2.0.4.4Database
- Autoconfig On Db Tier Fails With Error - SP2-1503AIError
- Bug 12725963 - New database connection fails with ORA-12541 after vip failoverDatabaseAI
- After mysql installation, we need to change the password of root as belowMySql
- How to Clean Up After a Failed Oracle Clusterware (CRS) InstallationAIOracle
- root.sh Fails on the First Node for 11gR2 GI InstallationAI
- After failed upgrade, startup fails on ORA-00704 [ID 1345417.1]AI
- No OAM Application Manager Link in R12 after a fresh installationAPP
- clean all Oracle 10gR2 CRS after a failed CRS installationOracle 10gAI
- 被蘋果11.2警告的解決方案蘋果
- sqlplus之prompt_&&_&_new_valueSQL
- 11.2 sqlplus新增連線是指定版本SQL
- 解決IllegalStateException: Can not perform this action after onSaveInstanceStateExceptionORM
- 解決 ocrconfig -replace ocr Fails With PROT-16AI
- sqlplus: command not found解決SQL
- Unable To Open Database After ASM Upgrade From Release 11.1 To Release 11.2DatabaseASM
- cannot allocate new log 的解決方法
- sqlplus hang 解決方法一例SQL
- oracle10g new feature -- 1. SqlplusOracleSQL
- Mysql_secure_installation詳解MySql
- sqlplus 顯示問號,解決辦法SQL
- 解決E: Package ‘libmysqlclient-dev‘ has no installation candidate報錯PackageIBMMySqlclientdev
- 報錯(已解決)Command timed out after no timeout
- ASMCA fails to create 11.2 ASM instance when upgrading from 10.2 [ID 1125053.1]ASMAI
- 如何解決 After Effects報警
- 問題解決——Sqlplus與換行前空格(一)SQL
- 問題解決——Sqlplus與換行前空格(二)SQL
- 真機除錯出現 application installation failed 錯誤 解決方案除錯APPAI
- sqlplus因selinux報錯cannot restore segment prot after reloc: Permission deniedSQLLinuxREST
- Exchange 2000/2003 System Attendant does not start after disaster recovery installation, event ID 90AST
- pecl PHP Parse error: syntax error, unexpected 'new' (T_NEW) 以及 XML缺失解決辦法PHPErrorXML
- MySQL 5.7半同步複製after sync和after commit詳解MySqlMIT
- 【轉載】啟動sqlplus命令,會報的cannot restore segment prot after relocSQLREST
- Linux中sqlplus退格顯示“^H” 的解決LinuxSQL
- sqlplus無法啟動的問題及解決SQL
- 11.2 RAC 修改了uid後crs不能啟動的解決方法UI
- Recreating Controlfile With New Database Name Fails ORA-01503_ 109502.1DatabaseAI
- C++ new A 和 new A() 的區別詳解C++