ORA-27101 Linux-x86_64 始终无法登录求教
本帖最后由 e66478 于 2013-04-18 10:33 编辑问题：想通过添加一个表空间给其他人使用，现在默认建立的ORCL空间可以远程通过 PLSQL Developer 使用，新建立的就怎么也不行
百度翻遍了没有解决，大多数人的问题跟我的不一样，我的多出一条Linux-x86_64 Error: 2: No such file or directory 错误，请教有经验的大哥指点下 谢谢
--------------------------- 下面就是错误，本地也就是centos 服务器上登录也是这个错误
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
Process ID: 0
Session ID: 0 Serial number: 0
--------------- 环境--
centos 6.3 64BIT
oracle 11gR2
oracle 静默安装建立默认监听ORCL.paok.cn
lsnrctl status状态
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date 18-APR-2013 17:01:49
Uptime 0 days 1 hr. 14 min. 45 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/oracle11g/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracle11g)(PORT=1521)))
Services Summary...
Service "ORCL.paok.cn" has 1 instance(s).
Instance "ORCL", status READY, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "orcl11gXDB.paok.cn" has 1 instance(s).
Instance "ORCL", status READY, has 1 handler(s) for this service...
Service "paok_dns" has 1 instance(s).
Instance "paok_dns", status UNKNOWN, has 1 handler(s) for this service...
Service "test_data" has 1 instance(s).
Instance "test_data", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
-------------listener.ora ---------
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
)
ADR_BASE_LISTENER = /u01/app/oracle
SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)(PROGRAM = extproc) )(SID_DESC = (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1) (SID_NAME = test_data) )(SID_DESC = (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1) (SID_NAME = paok_cdn)))
-------------- tnsnames.ora ----
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = oracle11g)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ORCL.paok.cn)
)
)
test_data =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.14)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = test_data)
)
)
-------------------------- test_data 表空间建立过程----
create temporary tablespace paok_temp tempfile '/u01/app/oracle/oradata/ORCL/paok_temp.dbf' size 50m autoextend on next 50m maxsize 2048m extent management local;
create tablespace test_data logging datafile '/u01/app/oracle/oradata/ORCL/test_data.dbf' size 50m autoextend on next 50m maxsize 2048m extent management local;
create user test identified by paok001 default tablespace test_data temporary tablespace paok_temp;
grant connect,resource,dba to test;
------------- sysctl.cnf ---- 系统配置
kernel.shmall = 4294967296
fs.aio-max-nr = 1048576
fs.file-max = 6553600
kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default = 4194304
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048586
oracle11g oracle ]$ echo $PATH
.:/u01/app/oracle/product/11.2.0/dbhome_1/bin:/u01/app/oracle/product/11.2.0/dbhome_1/OPatch:/u01/app/oracle/product/11.2.0/dbhome_1/jdk/bin:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin:/home/oracle/bin $ORACLE_BASE/admin/ 这个目录的作用是什么，下面只有ORCL 目录正确吗
登陆的连接串贴下 本帖最后由 e66478 于 2013-04-18 11:19 编辑
sqlplus test/paok001@localhost/test_data
sqlplus test/paok001@192.168.1.14:1521/test_data
都试过不行 都是27101错误代码 就是在本地 oracle 安装服务器登录。客户端命令行登入也是这样
SQL> select status from v$instance;
STATUS
------------
OPEN
SQL> echo $ORACLE_SID看下
$ echo $ORACLE_SID
ORCL
大哥 这个ID只有一个正常吗，在环境变量就设置一个 本帖最后由 e66478 于 2013-04-18 11:28 编辑
oracle 系统用户的变量
# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
# User specific environment and startup programs
PATH=$PATH:$HOME/bin
export PATH
umask 022
export ORACLE_HOSTNAME=oracle11g
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1
export ORACLE_SID=ORCL
export PATH=.:$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$ORACLE_HOME/jdk/bin:$PATH
export LC_ALL="en_US"
export LANG="en_US"
export NLS_LANG="AMERICAN_AMERICA.ZHS16GBK"
export NLS_DATE_FORMAT="YYYY-MM-DD HH24:MI:SS" 如果是ORCL试试sqlplus test/paok001@ORCL
你貌似有多个实例，这个登陆的时候会比较乱 本帖最后由 e66478 于 2013-04-18 11:40 编辑
这样也不行，如果说多个实例 $ORACLE_BASE/admin/ 咋这个目录下是不是只有默认第一个
TNS:listener does not currently know of service requested in connect
descriptor
在windows 客户端 tnsping也通的啊
C:\Documents and Settings\Administrator>tnsping 192.168.1.14:1521/test_data
TNS Ping Utility for 32-bit Windows: Version 11.2.0.1.0 - Production on 18-4月 -2013 11:39:35
Copyright (c) 1997, 2010, Oracle.All rights reserved.
已使用的参数文件:
E:\orcl\Administrator\product\11.2.0\client_1\network\admin\sqlnet.ora
已使用 EZCONNECT 适配器来解析别名
尝试连接 (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=test_data))(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.14)(PORT=1521)))
OK (0 毫秒)
----------------------------------------
SQL> select tablespace_name,file_id,block_id,bytes,blocks from dba_free_space;
TABLESPACE_NAME FILE_ID BLOCK_ID BYTES BLOCKS
------------------------------ ---------- ---------- ---------- ----------
SYSTEM 1 86384 131072 16
SYSTEM 1 86528 4194304 512
SYSAUX 2 60272 131072 16
SYSAUX 2 60416 29360128 3584
UNDOTBS1 3 592 65536 8
UNDOTBS1 3 704 131072 16
UNDOTBS1 3 728 327680 40
UNDOTBS1 3 936 65536 8
UNDOTBS1 3 976 65536 8
UNDOTBS1 3 1016 65536 8
UNDOTBS1 3 1408 65536 8
TABLESPACE_NAME FILE_ID BLOCK_ID BYTES BLOCKS
------------------------------ ---------- ---------- ---------- ----------
UNDOTBS1 3 1424 58589184 7152
UNDOTBS1 3 8976 65536 8
UNDOTBS1 3 9000 65536 8
UNDOTBS1 3 9088 65536 8
UNDOTBS1 3 9112 131072 16
UNDOTBS1 3 9168 65536 8
UNDOTBS1 3 9192 327680 40
UNDOTBS1 3 9280 196608 24
UNDOTBS1 3 9344 2097152 256
USERS 4 168 3866624 472
TEST_DATA 5 128 51380224 6272
22 rows selected. 崩溃就在这里，这个遇到问题跟我遇到一样但是 我的无法解决
http://blog.sina.com.cn/s/blog_517cae3c01015dwu.html
页:
[1]
2