sqlplus /nolog 无响应

最新推荐文章于 2025-03-14 17:02:51 发布
最新推荐文章于 2025-03-14 17:02:51 发布
阅读量2.4k 收藏
点赞数
分类专栏： 11gR2
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/xxzhaobb/article/details/80464864
版权

之前碰到一个系统，使用sqlplus /nolog命令，进去后。无响应。

使用strace -o /tmp/trace.txt sqlplus /nolog 后，也是卡住了。

后来发现，$ORACLE_HOME/sqlplus/admin/glogin.sql里面写了一些东西。清理后，正常了。

原来的写法-- 容易导致sqlplus /nolog卡住

-- Copyright (c) 1988, 2011, Oracle and/or its affiliates. 
-- All rights reserved. 
--
-- NAME
--   glogin.sql
--
-- DESCRIPTION
--   SQL*Plus global login "site profile" file
--
--   Add any SQL*Plus commands here that are to be executed when a
--   user starts SQL*Plus, or uses the SQL*Plus CONNECT command.
--
-- USAGE
--   This script is automatically run
--

SET FEEDBACK OFF
SET TERMOUT OFF

COLUMN X NEW_VALUE Y
SELECT LOWER(USER || '@' || SYS_CONTEXT('userenv', 'instance_name')) X FROM dual;
SET SQLPROMPT '&Y> '

SET linesize 200
SET pagesize 200
SET TERMOUT ON
SET FEEDBACK ON
SET TAB OFF
SET TRIM ON
SET TRIMSPOOL ON

修改后的写法，一个语句搞定效果 

set sqlp "_user'@'_connect_identifier>"

再次进行strace ，很快就出结果了，原来的那个写法，就是卡住 。

[oracle@test admin]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.4.0 Production on Sat May 26 20:45:22 2018

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

@>exit
[oracle@test admin]$ strace -o /tmp/trace20180526 sqlplus /nolog

SQL*Plus: Release 11.2.0.4.0 Production on Sat May 26 20:45:44 2018

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

@>conn / as sysdba
ERROR:
ORA-12162: TNS:net service name is incorrectly specified


@>exit
[oracle@test admin]$ cat /tmp/trace20180526
execve("/u01/app/oracle/product/11.2.0/dbhome_1/bin/sqlplus", ["sqlplus", "/nolog"], [/* 27 vars */]                                                         ) = 0
brk(0)                                  = 0x1284000
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f756a7a5000
access("/etc/ld.so.preload", R_OK)      = -1 ENOENT (No such file or directory)
open("/u01/app/oracle/product/11.2.0/dbhome_1/lib/tls/x86_64/libsqlplus.so", O_RDONLY) = -1 ENOENT (                                                         No such file or directory)
stat("/u01/app/oracle/product/11.2.0/dbhome_1/lib/tls/x86_64", 0x7fff04dad000) = -1 ENOENT (No such                                                          file or directory)
open("/u01/app/oracle/product/11.2.0/dbhome_1/lib/tls/libsqlplus.so", O_RDONLY) = -1 ENOENT (No such                                                          file or directory)
stat("/u01/app/oracle/product/11.2.0/dbhome_1/lib/tls", 0x7fff04dad000) = -1 ENOENT (No such file or                                                          directory)
open("/u01/app/oracle/product/11.2.0/dbhome_1/lib/x86_64/libsqlplus.so", O_RDONLY) = -1 ENOENT (No s                                                         uch file or directory)
stat("/u01/app/oracle/product/11.2.0/dbhome_1/lib/x86_64", 0x7fff04dad000) = -1 ENOENT (No such file                                                          or directory)
open("/u01/app/oracle/product/11.2.0/dbhome_1/lib/libsqlplus.so", O_RDONLY) = 3
read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\320\355\1\0\0\0\0\0"..., 832) = 832
fstat(3, {st_mode=S_IFREG|0640, st_size=1469688, ...}) = 0
mmap(NULL, 3033576, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7f756a4c0000
mprotect(0x7f756a596000, 2097152, PROT_NONE) = 0
mmap(0x7f756a796000, 57344, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0xd6000) =                                                          0x7f756a796000
mmap(0x7f756a7a4000, 2536, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x7f7                                                         56a7a4000
close(3)                                = 0
open("/u01/app/oracle/product/11.2.0/dbhome_1/lib/libclntsh.so.11.1", O_RDONLY) = 3
read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\240\340G\0\0\0\0\0"..., 832) = 832
fstat(3, {st_mode=S_IFREG|0755, st_size=53823580, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f756a4bf000
mmap(NULL, 44501608, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7f7567a4e000
mprotect(0x7f756a0d3000, 2093056, PROT_NONE) = 0
mmap(0x7f756a2d2000, 1855488, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x268400                                                         0) = 0x7f756a2d2000
mmap(0x7f756a497000, 162408, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x7                                                         f756a497000
close(3)                                = 0
open("/u01/app/oracle/product/11.2.0/dbhome_1/lib/libnnz11.so", O_RDONLY) = 3
read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\0\326\4\0\0\0\0\0"..., 832) = 832
fstat(3, {st_mode=S_IFREG|0644, st_size=7980109, ...}) = 0
mmap(NULL, 3986304, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7f7567680000
mprotect(0x7f756790a000, 1048576, PROT_NONE) = 0
mmap(0x7f7567a0a000, 270336, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x28a000)                                                          = 0x7f7567a0a000
mmap(0x7f7567a4c000, 4992, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x7f7                                                         567a4c000
close(3)                                = 0
open("/u01/app/oracle/product/11.2.0/dbhome_1/lib/libdl.so.2", O_RDONLY) = -1 ENOENT (No such file o                                                         r directory)
open("/u01/app/oracle/product/11.2.0/dbhome_1/lib/libdl.so.2", O_RDONLY) = -1 ENOENT (No such file o                                                         r directory)
open("/u01/app/oracle/product/11.2.0/dbhome_1/network/lib/tls/x86_64/libdl.so.2", O_RDONLY) = -1 ENO                                                         ENT (No such file or directory)
stat("/u01/app/oracle/product/11.2.0/dbhome_1/network/lib/tls/x86_64", 0x7fff04dacf70) = -1 ENOENT (                                                         No such file or directory)
open("/u01/app/oracle/product/11.2.0/dbhome_1/network/lib/tls/libdl.so.2", O_RDONLY) = -1 ENOENT (No                                                          such file or directory)
stat("/u01/app/oracle/product/11.2.0/dbhome_1/network/lib/tls", 0x7fff04dacf70) = -1 ENOENT (No such                                                          file or directory)
open("/u01/app/oracle/product/11.2.0/dbhome_1/network/lib/x86_64/libdl.so.2", O_RDONLY) = -1 ENOENT                                                          (No such file or directory)
stat("/u01/app/oracle/product/11.2.0/dbhome_1/network/lib/x86_64", 0x7fff04dacf70) = -1 ENOENT (No s                                                         uch file or directory)
open("/u01/app/oracle/product/11.2.0/dbhome_1/network/lib/libdl.so.2", O_RDONLY) = -1 ENOENT (No suc                                                         h file or directory)
stat("/u01/app/oracle/product/11.2.0/dbhome_1/network/lib", {st_mode=S_IFDIR|0755, st_size=4096, ...                                                         }) = 0
open("/etc/ld.so.cache", O_RDONLY)      = 3
fstat(3, {st_mode=S_IFREG|0644, st_size=61901, ...}) = 0
mmap(NULL, 61901, PROT_READ, MAP_PRIVATE, 3, 0) = 0x7f7567670000
close(3)                                = 0
open("/lib64/libdl.so.2", O_RDONLY)     = 3
read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\340\r\340\2368\0\0\0"..., 832) = 832
fstat(3, {st_mode=S_IFREG|0755, st_size=23088, ...}) = 0
mmap(0x389ee00000, 2109696, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x389ee00000
mprotect(0x389ee02000, 2097152, PROT_NONE) = 0
mmap(0x389f002000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x2000) = 0x3                                                         89f002000
close(3)                                = 0
open("/u01/app/oracle/product/11.2.0/dbhome_1/lib/libm.so.6", O_RDONLY) = -1 ENOENT (No such file or                                                          directory)
open("/u01/app/oracle/product/11.2.0/dbhome_1/lib/libm.so.6", O_RDONLY) = -1 ENOENT (No such file or                                                          directory)
open("/u01/app/oracle/product/11.2.0/dbhome_1/network/lib/libm.so.6", O_RDONLY) = -1 ENOENT (No such                                                          file or directory)
open("/lib64/libm.so.6", O_RDONLY)      = 3
read(3, "\177ELF\2\1\1\3\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0`>\340\2378\0\0\0"..., 832) = 832
fstat(3, {st_mode=S_IFREG|0755, st_size=600048, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f756766f000
mmap(0x389fe00000, 2633912, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x389fe00000
mprotect(0x389fe83000, 2093056, PROT_NONE) = 0
mmap(0x38a0082000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x82000) = 0x                                                         38a0082000
close(3)                                = 0
open("/u01/app/oracle/product/11.2.0/dbhome_1/lib/libpthread.so.0", O_RDONLY) = -1 ENOENT (No such f                                                         ile or directory)
open("/u01/app/oracle/product/11.2.0/dbhome_1/lib/libpthread.so.0", O_RDONLY) = -1 ENOENT (No such f                                                         ile or directory)
open("/u01/app/oracle/product/11.2.0/dbhome_1/network/lib/libpthread.so.0", O_RDONLY) = -1 ENOENT (N                                                         o such file or directory)
open("/lib64/libpthread.so.0", O_RDONLY) = 3
read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0000^`\2378\0\0\0"..., 832) = 832
fstat(3, {st_mode=S_IFREG|0755, st_size=146592, ...}) = 0
mmap(0x389f600000, 2212848, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x389f600000
mprotect(0x389f617000, 2097152, PROT_NONE) = 0
mmap(0x389f817000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x17000) = 0x                                                         389f817000
mmap(0x389f819000, 13296, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x389f                                                         819000
close(3)                                = 0
open("/u01/app/oracle/product/11.2.0/dbhome_1/lib/libnsl.so.1", O_RDONLY) = -1 ENOENT (No such file                                                          or directory)
open("/u01/app/oracle/product/11.2.0/dbhome_1/lib/libnsl.so.1", O_RDONLY) = -1 ENOENT (No such file                                                          or directory)
open("/u01/app/oracle/product/11.2.0/dbhome_1/network/lib/libnsl.so.1", O_RDONLY) = -1 ENOENT (No su                                                         ch file or directory)
open("/lib64/libnsl.so.1", O_RDONLY)    = 3
read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0p@`\2538\0\0\0"..., 832) = 832
fstat(3, {st_mode=S_IFREG|0755, st_size=116904, ...}) = 0
mmap(0x38ab600000, 2198192, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x38ab600000
mprotect(0x38ab616000, 2093056, PROT_NONE) = 0
mmap(0x38ab815000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x15000) = 0x                                                         38ab815000
mmap(0x38ab817000, 6832, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x38ab8                                                         17000
close(3)                                = 0
open("/u01/app/oracle/product/11.2.0/dbhome_1/lib/libc.so.6", O_RDONLY) = -1 ENOENT (No such file or                                                          directory)
open("/u01/app/oracle/product/11.2.0/dbhome_1/lib/libc.so.6", O_RDONLY) = -1 ENOENT (No such file or                                                          directory)
open("/u01/app/oracle/product/11.2.0/dbhome_1/network/lib/libc.so.6", O_RDONLY) = -1 ENOENT (No such                                                          file or directory)
open("/lib64/libc.so.6", O_RDONLY)      = 3
read(3, "\177ELF\2\1\1\3\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0000\356!\2378\0\0\0"..., 832) = 832
fstat(3, {st_mode=S_IFREG|0755, st_size=1930416, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f756766e000
mmap(0x389f200000, 3750184, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x389f200000
mprotect(0x389f38a000, 2097152, PROT_NONE) = 0
mmap(0x389f58a000, 24576, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x18a000) =                                                          0x389f58a000
mmap(0x389f590000, 14632, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x389f                                                         590000
close(3)                                = 0
open("/u01/app/oracle/product/11.2.0/dbhome_1/lib/libaio.so.1", O_RDONLY) = -1 ENOENT (No such file                                                          or directory)
open("/u01/app/oracle/product/11.2.0/dbhome_1/lib/libaio.so.1", O_RDONLY) = -1 ENOENT (No such file                                                          or directory)
open("/u01/app/oracle/product/11.2.0/dbhome_1/lib/libaio.so.1", O_RDONLY) = -1 ENOENT (No such file                                                          or directory)
open("/u01/app/oracle/product/11.2.0/dbhome_1/network/lib/libaio.so.1", O_RDONLY) = -1 ENOENT (No su                                                         ch file or directory)
open("/lib64/libaio.so.1", O_RDONLY)    = 3
read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0p\5\340\2368\0\0\0"..., 832) = 832
fstat(3, {st_mode=S_IFREG|0755, st_size=5624, ...}) = 0
mmap(0x389ee00000, 2099840, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7f756746d000
mprotect(0x7f756746e000, 2093056, PROT_NONE) = 0
mmap(0x7f756766d000, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0) = 0x7f75                                                         6766d000
close(3)                                = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f756746c000
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f756746b000
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f756746a000
arch_prctl(ARCH_SET_FS, 0x7f756746b700) = 0
mprotect(0x389f58a000, 16384, PROT_READ) = 0
mprotect(0x38ab815000, 4096, PROT_READ) = 0
mprotect(0x389f817000, 4096, PROT_READ) = 0
mprotect(0x38a0082000, 4096, PROT_READ) = 0
mprotect(0x389f002000, 4096, PROT_READ) = 0
mprotect(0x389ec20000, 4096, PROT_READ) = 0
munmap(0x7f7567670000, 61901)           = 0
set_tid_address(0x7f756746b9d0)         = 8500
set_robust_list(0x7f756746b9e0, 24)     = 0
futex(0x7fff04dae91c, FUTEX_WAKE_PRIVATE, 1) = 0
futex(0x7fff04dae91c, FUTEX_WAIT_BITSET_PRIVATE|FUTEX_CLOCK_REALTIME, 1, NULL, 7f756746b700) = -1 EA                                                         GAIN (Resource temporarily unavailable)
rt_sigaction(SIGRTMIN, {0x389f605cb0, [], SA_RESTORER|SA_SIGINFO, 0x389f60f7e0}, NULL, 8) = 0
rt_sigaction(SIGRT_1, {0x389f605d40, [], SA_RESTORER|SA_RESTART|SA_SIGINFO, 0x389f60f7e0}, NULL, 8)                                                          = 0
rt_sigprocmask(SIG_UNBLOCK, [RTMIN RT_1], NULL, 8) = 0
getrlimit(RLIMIT_STACK, {rlim_cur=10240*1024, rlim_max=32768*1024}) = 0
brk(0)                                  = 0x1284000
brk(0x12a5000)                          = 0x12a5000
rt_sigaction(SIGQUIT, {0x7f756a5689b8, [QUIT], SA_RESTORER|SA_RESTART, 0x389f232510}, {SIG_DFL, [],                                                          0}, 8) = 0
rt_sigaction(SIGABRT, {0x7f756a5689b8, [ABRT], SA_RESTORER|SA_RESTART, 0x389f232510}, {SIG_DFL, [],                                                          0}, 8) = 0
mmap(NULL, 143360, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f7567447000
futex(0x389f0030ec, FUTEX_WAKE_PRIVATE, 2147483647) = 0
open("/u01/app/oracle/product/11.2.0/dbhome_1/lib/libsqlplusic.so", O_RDONLY) = -1 ENOENT (No such f                                                         ile or directory)
open("/u01/app/oracle/product/11.2.0/dbhome_1/lib/libociicus.so", O_RDONLY) = -1 ENOENT (No such fil                                                         e or directory)
open("/u01/app/oracle/product/11.2.0/dbhome_1/lib/libociei.so", O_RDONLY) = -1 ENOENT (No such file                                                          or directory)
open("/u01/app/oracle/product/11.2.0/dbhome_1/nls/data/lx1boot.nlb", O_RDONLY) = 3
read(3, "\0\0\0\3\0\4 \v\260W\0\0\230\363\216\0\0\0\0\0\1\0E\0\276\0\304\1\32\2,\2"..., 48) = 48
read(3, "\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 22400) = 22400
close(3)                                = 0
open("/u01/app/oracle/product/11.2.0/dbhome_1/nls/data/lx00001.nlb", O_RDONLY) = 3
read(3, "\0\0\0\3\0\4 \v\267\3\0\0s\2\0\0\0\0\0\0\0\0\0\0\0Z\1\0\0\0\0\0"..., 92) = 92
read(3, "\3\0\0\0\1\0\1\0\1\0`\0\0\0\4\0\6\0\10\0\n\0\20\0\30\0 \0(\0000\0"..., 859) = 859
close(3)                                = 0
open("/u01/app/oracle/product/11.2.0/dbhome_1/nls/data/lx20001.nlb", O_RDONLY) = 3
read(3, "\0\0\0\3\0\4 \v9\33\0\0\215\21\0\0\0\0\0\0\2\0\0\0\0Z\1\0\0\0\0\0"..., 92) = 92
read(3, "\1\0\37\0\t\0\2\0\0\0\0\0\0\0\0\0\0\0?\0\0\0\0\1\0\0\0\0\0\0\0\0"..., 6877) = 6877
close(3)                                = 0
open("/u01/app/oracle/product/11.2.0/dbhome_1/nls/data/lx10001.nlb", O_RDONLY) = 3
read(3, "\0\0\0\3\0\4 \vt\4\0\0\220\3\0\0\0\0\0\0\1\0\0\0\0Z\1\0\0\0\0\0"..., 92) = 92
read(3, "\3\0\0\0\1\0\1\0\0\0\0\0\0\0\4\0\1\0\2\0\2\0\1\0\1\0\0\0\0\0\0\0"..., 1048) = 1048
close(3)                                = 0
brk(0x12c9000)                          = 0x12c9000
open("/u01/app/oracle/product/11.2.0/dbhome_1/nls/data/lx40011.nlb", O_RDONLY) = 3
read(3, "\0\0\0\5\0\4 \vaV\0\0aV\0\0\0\0\0\0\4\0\0\0\0Z\1\0\0\0\0\0"..., 92) = 92
read(3, "\0\0\0\0(\1\0\0,\1\0\0000\1\0\0004\1\0\0<A\0\0TF\0\0TV\0\0"..., 22021) = 22021
close(3)                                = 0
open("/u01/app/oracle/product/11.2.0/dbhome_1/nls/data/lx40001.nlb", O_RDONLY) = 3
read(3, "\0\0\0\3\0\4 \v\20\177\0\0\354}\0\0\0\0\0\0\4\0\0\0\0Z\1\0\0\0\0\0"..., 92) = 92
read(3, "\0\0\0\0\4\0\0\0\4\0\0\0\354O\0\0L[\0\0004]\0\0L^\0\0Da\0\0"..., 32436) = 32436
close(3)                                = 0
open("/u01/app/oracle/product/11.2.0/dbhome_1/sqlplus/mesg/sp1us.msb", O_RDONLY) = 3
fcntl(3, F_SETFD, FD_CLOEXEC)           = 0
lseek(3, 0, SEEK_SET)                   = 0
read(3, "\25\23\"\1\23\3\t\t\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 256) = 256
lseek(3, 512, SEEK_SET)                 = 512
read(3, "m$\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 512) = 512
lseek(3, 1024, SEEK_SET)                = 1024
read(3, "\26\0-\0@\0R\0g\0\177\0\222\0\246\0\300\0\346\0\357\0\1\1L\1a\1\201\1\226\1"..., 36) = 36
open("/u01/app/oracle/product/11.2.0/dbhome_1/sqlplus/mesg/sp2us.msb", O_RDONLY) = 4
fcntl(4, F_SETFD, FD_CLOEXEC)           = 0
lseek(4, 0, SEEK_SET)                   = 0
read(4, "\25\23\"\1\23\3\t\t\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 256) = 256
lseek(4, 512, SEEK_SET)                 = 512
read(4, "\263\27\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 512) = 512
lseek(4, 1024, SEEK_SET)                = 1024
read(4, "\26\0*\0R\0h\0\201\0\236\0\350\0\374\0\n\1#\1?\1M\1\251\1\307\1\346\1\3\2"..., 124) = 124
open("/u01/app/oracle/product/11.2.0/dbhome_1/sqlplus/mesg/cpyus.msb", O_RDONLY) = 5
fcntl(5, F_SETFD, FD_CLOEXEC)           = 0
lseek(5, 0, SEEK_SET)                   = 0
read(5, "\25\23\"\1\23\3\t\t\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 256) = 256
lseek(5, 512, SEEK_SET)                 = 512
read(5, "\f\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 512) = 512
lseek(5, 1024, SEEK_SET)                = 1024
read(5, "\t\0\f\0", 4)                  = 4
getcwd("/u01/app/oracle/product/11.2.0/dbhome_1/sqlplus/admin", 256) = 54
socket(PF_INET6, SOCK_DGRAM, IPPROTO_IP) = 6
bind(6, {sa_family=AF_INET6, sin6_port=htons(0), inet_pton(AF_INET6, "::1", &sin6_addr), sin6_flowin                                                         fo=0, sin6_scope_id=0}, 28) = 0
close(6)                                = 0
access("/u01/app/oracle/product/11.2.0/dbhome_1/network/admin/sqlnet.ora", F_OK) = -1 ENOENT (No suc                                                         h file or directory)
access("/home/oracle/.sqlnet.ora", F_OK) = -1 ENOENT (No such file or directory)
stat("/u01/app/oracle", {st_mode=S_IFDIR|0775, st_size=4096, ...}) = 0
stat("/u01/app/oracle/diag", {st_mode=S_IFDIR|0775, st_size=4096, ...}) = 0
stat("/u01/app/oracle/diag/clients", {st_mode=S_IFDIR|0775, st_size=4096, ...}) = 0
uname({sys="Linux", node="test.us.oracle.com", ...}) = 0
getuid()                                = 54321
socket(PF_LOCAL, SOCK_STREAM|SOCK_CLOEXEC|SOCK_NONBLOCK, 0) = 6
connect(6, {sa_family=AF_LOCAL, sun_path="/var/run/nscd/socket"}, 110) = -1 ENOENT (No such file or                                                          directory)
close(6)                                = 0
socket(PF_LOCAL, SOCK_STREAM|SOCK_CLOEXEC|SOCK_NONBLOCK, 0) = 6
connect(6, {sa_family=AF_LOCAL, sun_path="/var/run/nscd/socket"}, 110) = -1 ENOENT (No such file or                                                          directory)
close(6)                                = 0
open("/etc/nsswitch.conf", O_RDONLY|O_CLOEXEC) = 6
fstat(6, {st_mode=S_IFREG|0644, st_size=1688, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f756767f000
read(6, "#\n# /etc/nsswitch.conf\n#\n# An ex"..., 4096) = 1688
read(6, "", 4096)                       = 0
close(6)                                = 0
munmap(0x7f756767f000, 4096)            = 0
open("/u01/app/oracle/product/11.2.0/dbhome_1/lib/libnss_files.so.2", O_RDONLY) = -1 ENOENT (No such                                                          file or directory)
open("/u01/app/oracle/product/11.2.0/dbhome_1/lib/libnss_files.so.2", O_RDONLY) = -1 ENOENT (No such                                                          file or directory)
open("/u01/app/oracle/product/11.2.0/dbhome_1/network/lib/libnss_files.so.2", O_RDONLY) = -1 ENOENT                                                          (No such file or directory)
open("/etc/ld.so.cache", O_RDONLY)      = 6
fstat(6, {st_mode=S_IFREG|0644, st_size=61901, ...}) = 0
mmap(NULL, 61901, PROT_READ, MAP_PRIVATE, 6, 0) = 0x7f7567670000
close(6)                                = 0
open("/lib64/libnss_files.so.2", O_RDONLY) = 6
read(6, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0P\"\0\0\0\0\0\0"..., 832) = 832
fstat(6, {st_mode=S_IFREG|0755, st_size=62392, ...}) = 0
mmap(NULL, 2147760, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 6, 0) = 0x7f756723a000
mprotect(0x7f7567246000, 2093056, PROT_NONE) = 0
mmap(0x7f7567445000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 6, 0xb000) = 0                                                         x7f7567445000
close(6)                                = 0
mprotect(0x7f7567445000, 4096, PROT_READ) = 0
munmap(0x7f7567670000, 61901)           = 0
open("/etc/passwd", O_RDONLY|O_CLOEXEC) = 6
fcntl(6, F_GETFD)                       = 0x1 (flags FD_CLOEXEC)
fstat(6, {st_mode=S_IFREG|0644, st_size=1664, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f756767f000
read(6, "root:x:0:0:root:/root:/bin/bash\n"..., 4096) = 1664
close(6)                                = 0
munmap(0x7f756767f000, 4096)            = 0
brk(0x12eb000)                          = 0x12eb000
times({tms_utime=0, tms_stime=0, tms_cutime=0, tms_cstime=0}) = 433983470
open("/u01/app/oracle/product/11.2.0/dbhome_1/rdbms/mesg/diaus.msb", O_RDONLY) = 6
fcntl(6, F_SETFD, FD_CLOEXEC)           = 0
lseek(6, 0, SEEK_SET)                   = 0
read(6, "\25\23\"\1\23\3\t\t\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 256) = 256
lseek(6, 512, SEEK_SET)                 = 512
read(6, "\371\311\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 512) = 512
lseek(6, 1024, SEEK_SET)                = 1024
read(6, "\210\273\353\273\363\273\373\273\4\274\16\274\26\274!\274)\2741\274<\274G\274T\274_\274k\27                                                         4t\274"..., 192) = 192
stat("/u01/app/oracle", {st_mode=S_IFDIR|0775, st_size=4096, ...}) = 0
getrlimit(RLIMIT_NOFILE, {rlim_cur=1024, rlim_max=64*1024}) = 0
open("/proc/self/fd/", O_RDONLY|O_NONBLOCK|O_DIRECTORY|O_CLOEXEC) = 7
fcntl(7, F_GETFD)                       = 0x1 (flags FD_CLOEXEC)
brk(0x1312000)                          = 0x1312000
getrlimit(RLIMIT_FSIZE, {rlim_cur=RLIM64_INFINITY, rlim_max=RLIM64_INFINITY}) = 0
stat("/u01/app/oracle", {st_mode=S_IFDIR|0775, st_size=4096, ...}) = 0
stat("/u01/app/oracle/diag", {st_mode=S_IFDIR|0775, st_size=4096, ...}) = 0
stat("/u01/app/oracle/diag/clients", {st_mode=S_IFDIR|0775, st_size=4096, ...}) = 0
uname({sys="Linux", node="test.us.oracle.com", ...}) = 0
getuid()                                = 54321
open("/etc/passwd", O_RDONLY|O_CLOEXEC) = 8
fstat(8, {st_mode=S_IFREG|0644, st_size=1664, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f756767f000
read(8, "root:x:0:0:root:/root:/bin/bash\n"..., 4096) = 1664
close(8)                                = 0
munmap(0x7f756767f000, 4096)            = 0
access("/u01/app/oracle/product/11.2.0/dbhome_1/network/admin/sqlnet.ora", F_OK) = -1 ENOENT (No suc                                                         h file or directory)
access("/etc/intchg.ora", F_OK)         = -1 ENOENT (No such file or directory)
access("/u01/app/oracle/product/11.2.0/dbhome_1/network/admin/intchg.ora", F_OK) = -1 ENOENT (No suc                                                         h file or directory)
access("/etc/tnsnav.ora", F_OK)         = -1 ENOENT (No such file or directory)
access("/u01/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnav.ora", F_OK) = -1 ENOENT (No suc                                                         h file or directory)
rt_sigaction(SIGQUIT, NULL, NULL, 8)    = 0
rt_sigaction(SIGQUIT, NULL, {0x7f756a5689b8, [QUIT], SA_RESTORER|SA_RESTART, 0x389f232510}, 8) = 0
rt_sigaction(SIGILL, NULL, NULL, 8)     = 0
rt_sigaction(SIGILL, NULL, {SIG_DFL, [], 0}, 8) = 0
rt_sigaction(SIGILL, {0x7f75695966f8, [], SA_RESTORER|SA_SIGINFO, 0x389f60f7e0}, {SIG_DFL, [], 0}, 8                                                         ) = 0
rt_sigaction(SIGABRT, NULL, NULL, 8)    = 0
rt_sigaction(SIGABRT, NULL, {0x7f756a5689b8, [ABRT], SA_RESTORER|SA_RESTART, 0x389f232510}, 8) = 0
rt_sigaction(SIGFPE, NULL, NULL, 8)     = 0
rt_sigaction(SIGFPE, NULL, {SIG_DFL, [], 0}, 8) = 0
rt_sigaction(SIGFPE, {0x7f75695966f8, [], SA_RESTORER|SA_SIGINFO, 0x389f60f7e0}, {SIG_DFL, [], 0}, 8                                                         ) = 0
rt_sigaction(SIGSEGV, NULL, NULL, 8)    = 0
rt_sigaction(SIGSEGV, NULL, {SIG_DFL, [], 0}, 8) = 0
rt_sigaction(SIGSEGV, {0x7f75695966f8, [], SA_RESTORER|SA_SIGINFO, 0x389f60f7e0}, {SIG_DFL, [], 0},                                                          8) = 0
rt_sigaction(SIGBUS, NULL, NULL, 8)     = 0
rt_sigaction(SIGBUS, NULL, {SIG_DFL, [], 0}, 8) = 0
rt_sigaction(SIGBUS, {0x7f75695966f8, [], SA_RESTORER|SA_SIGINFO, 0x389f60f7e0}, {SIG_DFL, [], 0}, 8                                                         ) = 0
rt_sigaction(SIGSYS, NULL, NULL, 8)     = 0
rt_sigaction(SIGSYS, NULL, {SIG_DFL, [], 0}, 8) = 0
rt_sigaction(SIGSYS, {0x7f75695966f8, [], SA_RESTORER|SA_SIGINFO, 0x389f60f7e0}, {SIG_DFL, [], 0}, 8                                                         ) = 0
rt_sigaction(SIGTRAP, NULL, NULL, 8)    = 0
rt_sigaction(SIGTRAP, NULL, {SIG_DFL, [], 0}, 8) = 0
rt_sigaction(SIGTRAP, {0x7f75695966f8, [], SA_RESTORER|SA_SIGINFO, 0x389f60f7e0}, {SIG_DFL, [], 0},                                                          8) = 0
rt_sigaction(SIGXCPU, NULL, NULL, 8)    = 0
rt_sigaction(SIGXCPU, NULL, {SIG_DFL, [], 0}, 8) = 0
rt_sigaction(SIGXCPU, {0x7f75695966f8, [], SA_RESTORER|SA_SIGINFO, 0x389f60f7e0}, {SIG_DFL, [], 0},                                                          8) = 0
rt_sigaction(SIGXFSZ, NULL, NULL, 8)    = 0
rt_sigaction(SIGXFSZ, NULL, {SIG_DFL, [], 0}, 8) = 0
rt_sigaction(SIGXFSZ, {0x7f75695966f8, [], SA_RESTORER|SA_SIGINFO, 0x389f60f7e0}, {SIG_DFL, [], 0},                                                          8) = 0
open("/u01/app/oracle/product/11.2.0/dbhome_1/oracore/zoneinfo", O_RDONLY|O_NONBLOCK|O_DIRECTORY|O_C                                                         LOEXEC) = 8
getdents(8, /* 34 entries */, 32768)    = 1288
open("/u01/app/oracle/product/11.2.0/dbhome_1/oracore/zoneinfo/timezlrg_4.dat", O_RDONLY) = 9
fstat(9, {st_mode=S_IFREG|0644, st_size=531137, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f756767f000
read(9, "ZTrO\301\32\10\0\3\0\4\0\2\0\210\0016A\0\0\323\2\0\0<\0\2\0|\f\2\0"..., 4096) = 4096
close(9)                                = 0
munmap(0x7f756767f000, 4096)            = 0
open("/u01/app/oracle/product/11.2.0/dbhome_1/oracore/zoneinfo/timezone_6.dat", O_RDONLY) = 9
fstat(9, {st_mode=S_IFREG|0644, st_size=286217, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f756767f000
read(9, "ZTrO\t^\4\0\3\0\6\0\1\0\275\0@\31\0\0\357\0\0\0<\0\2\0$\6\2\0"..., 4096) = 4096
close(9)                                = 0
munmap(0x7f756767f000, 4096)            = 0
open("/u01/app/oracle/product/11.2.0/dbhome_1/oracore/zoneinfo/timezone_1.dat", O_RDONLY) = 9
fstat(9, {st_mode=S_IFREG|0644, st_size=274427, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f756767f000
read(9, "ZTrO\373/\4\0\3\0\1\0\1\0\267\0A\27\0\0\350\0\0\0<\0\2\0\364\5\2\0"..., 4096) = 4096
close(9)                                = 0
munmap(0x7f756767f000, 4096)            = 0
open("/u01/app/oracle/product/11.2.0/dbhome_1/oracore/zoneinfo/timezlrg_5.dat", O_RDONLY) = 9
fstat(9, {st_mode=S_IFREG|0644, st_size=587487, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f756767f000
read(9, "ZTrO\337\366\10\0\3\0\5\0\2\0\2\2\370I\0\0\225\3\0\0<\0\2\0L\20\2\0"..., 4096) = 4096
close(9)                                = 0
munmap(0x7f756767f000, 4096)            = 0
open("/u01/app/oracle/product/11.2.0/dbhome_1/oracore/zoneinfo/big", O_RDONLY) = 9
fstat(9, {st_mode=S_IFDIR|0755, st_size=4096, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f756767f000
read(9, 0x7f756767f000, 4096)           = -1 EISDIR (Is a directory)
close(9)                                = 0
munmap(0x7f756767f000, 4096)            = 0
open("/u01/app/oracle/product/11.2.0/dbhome_1/oracore/zoneinfo/timezone_4.dat", O_RDONLY) = 9
fstat(9, {st_mode=S_IFREG|0644, st_size=286264, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f756767f000
read(9, "ZTrO8^\4\0\3\0\4\0\1\0\275\0>\31\0\0\357\0\0\0<\0\2\0$\6\2\0"..., 4096) = 4096
close(9)                                = 0
munmap(0x7f756767f000, 4096)            = 0
open("/u01/app/oracle/product/11.2.0/dbhome_1/oracore/zoneinfo/timezlrg_2.dat", O_RDONLY) = 9
fstat(9, {st_mode=S_IFREG|0644, st_size=507957, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f756767f000
read(9, "ZTrO5\300\7\0\3\0\2\0\2\0y\1_=\0\0\276\2\0\0<\0\2\0\4\f\2\0"..., 4096) = 4096
close(9)                                = 0
munmap(0x7f756767f000, 4096)            = 0
open("/u01/app/oracle/product/11.2.0/dbhome_1/oracore/zoneinfo/timezlrg_6.dat", O_RDONLY) = 9
fstat(9, {st_mode=S_IFREG|0644, st_size=586750, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f756767f000
read(9, "ZTrO\376\363\10\0\3\0\6\0\2\0\2\2\334I\0\0\225\3\0\0<\0\2\0L\20\2\0"..., 4096) = 4096
close(9)                                = 0
munmap(0x7f756767f000, 4096)            = 0
open("/u01/app/oracle/product/11.2.0/dbhome_1/oracore/zoneinfo/timezone_12.dat", O_RDONLY) = 9
fstat(9, {st_mode=S_IFREG|0644, st_size=345024, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f756767f000
read(9, "ZTrO\300C\5\0\3\0\f\0\1\0\307\0##\0\0\f\1\0\0<\0\2\0t\6\2\0"..., 4096) = 4096
close(9)                                = 0
munmap(0x7f756767f000, 4096)            = 0
open("/u01/app/oracle/product/11.2.0/dbhome_1/oracore/zoneinfo/timezdif.csv", O_RDONLY) = 9
fstat(9, {st_mode=S_IFREG|0644, st_size=31525, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f756767f000
read(9, "# File version 1.0\n# Fields: VER"..., 4096) = 4096
close(9)                                = 0
munmap(0x7f756767f000, 4096)            = 0
open("/u01/app/oracle/product/11.2.0/dbhome_1/oracore/zoneinfo/timezone_11.dat", O_RDONLY) = 9
fstat(9, {st_mode=S_IFREG|0644, st_size=345356, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f756767f000
read(9, "ZTrO\fE\5\0\3\0\v\0\1\0\307\0001#\0\0\r\1\0\0<\0\2\0t\6\2\0"..., 4096) = 4096
close(9)                                = 0
munmap(0x7f756767f000, 4096)            = 0
open("/u01/app/oracle/product/11.2.0/dbhome_1/oracore/zoneinfo/timezone_9.dat", O_RDONLY) = 9
fstat(9, {st_mode=S_IFREG|0644, st_size=351525, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f756767f000
read(9, "ZTrO%]\5\0\3\0\t\0\1\0\306\0F$\0\0\375\0\0\0<\0\2\0l\6\2\0"..., 4096) = 4096
close(9)                                = 0
munmap(0x7f756767f000, 4096)            = 0
open("/u01/app/oracle/product/11.2.0/dbhome_1/oracore/zoneinfo/readme.txt", O_RDONLY) = 9
fstat(9, {st_mode=S_IFREG|0644, st_size=6068, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f756767f000
read(9, "Current Structure version: 3\nCur"..., 4096) = 4096
close(9)                                = 0
munmap(0x7f756767f000, 4096)            = 0
open("/u01/app/oracle/product/11.2.0/dbhome_1/oracore/zoneinfo/timezlrg_12.dat", O_RDONLY) = 9
fstat(9, {st_mode=S_IFREG|0644, st_size=785621, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f756767f000
read(9, "ZTrO\325\374\v\0\3\0\f\0\2\0'\2]k\0\0\320\3\0\0<\0\2\0t\21\2\0"..., 4096) = 4096
close(9)                                = 0
munmap(0x7f756767f000, 4096)            = 0
open("/u01/app/oracle/product/11.2.0/dbhome_1/oracore/zoneinfo/timezlrg_1.dat", O_RDONLY) = 9
fstat(9, {st_mode=S_IFREG|0644, st_size=493675, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f756767f000
read(9, "ZTrOk\210\7\0\3\0\1\0\2\0c\1$;\0\0v\2\0\0<\0\2\0T\v\2\0"..., 4096) = 4096
close(9)                                = 0
munmap(0x7f756767f000, 4096)            = 0
open("/u01/app/oracle/product/11.2.0/dbhome_1/oracore/zoneinfo/timezlrg_3.dat", O_RDONLY) = 9
fstat(9, {st_mode=S_IFREG|0644, st_size=527717, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f756767f000
read(9, "ZTrOe\r\10\0\3\0\3\0\2\0\203\1\252@\0\0\314\2\0\0<\0\2\0T\f\2\0"..., 4096) = 4096
close(9)                                = 0
munmap(0x7f756767f000, 4096)            = 0
open("/u01/app/oracle/product/11.2.0/dbhome_1/oracore/zoneinfo/timezone_8.dat", O_RDONLY) = 9
fstat(9, {st_mode=S_IFREG|0644, st_size=302100, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f756767f000
read(9, "ZTrO\24\234\4\0\3\0\10\0\1\0\305\0\342\33\0\0\375\0\0\0<\0\2\0d\6\2\0"..., 4096) = 4096
close(9)                                = 0
munmap(0x7f756767f000, 4096)            = 0
open("/u01/app/oracle/product/11.2.0/dbhome_1/oracore/zoneinfo/timezone_13.dat", O_RDONLY) = 9
fstat(9, {st_mode=S_IFREG|0644, st_size=344425, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f756767f000
read(9, "ZTrOiA\5\0\3\0\r\0\1\0\307\0\t#\0\0\f\1\0\0<\0\2\0t\6\2\0"..., 4096) = 4096
close(9)                                = 0
munmap(0x7f756767f000, 4096)            = 0
open("/u01/app/oracle/product/11.2.0/dbhome_1/oracore/zoneinfo/timezone_5.dat", O_RDONLY) = 9
fstat(9, {st_mode=S_IFREG|0644, st_size=286310, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f756767f000
read(9, "ZTrOf^\4\0\3\0\5\0\1\0\275\0@\31\0\0\357\0\0\0<\0\2\0$\6\2\0"..., 4096) = 4096
close(9)                                = 0
munmap(0x7f756767f000, 4096)            = 0
open("/u01/app/oracle/product/11.2.0/dbhome_1/oracore/zoneinfo/timezlrg_14.dat", O_RDONLY) = 9
fstat(9, {st_mode=S_IFREG|0644, st_size=791430, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f756767f000
read(9, "ZTrO\206\23\f\0\3\0\16\0\2\0,\2Ol\0\0\333\3\0\0<\0\2\0\234\21\2\0"..., 4096) = 4096
close(9)                                = 0
munmap(0x7f756767f000, 4096)            = 0
open("/u01/app/oracle/product/11.2.0/dbhome_1/oracore/zoneinfo/timezlrg_9.dat", O_RDONLY) = 9
fstat(9, {st_mode=S_IFREG|0644, st_size=801410, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f756767f000
read(9, "ZTrO\202:\f\0\3\0\t\0\2\0%\2\20n\0\0\313\3\0\0<\0\2\0d\21\2\0"..., 4096) = 4096
close(9)                                = 0
munmap(0x7f756767f000, 4096)            = 0
open("/u01/app/oracle/product/11.2.0/dbhome_1/oracore/zoneinfo/timezlrg_11.dat", O_RDONLY) = 9
fstat(9, {st_mode=S_IFREG|0644, st_size=787272, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f756767f000
read(9, "ZTrOH\3\f\0\3\0\v\0\2\0'\2\244k\0\0\322\3\0\0<\0\2\0t\21\2\0"..., 4096) = 4096
close(9)                                = 0
munmap(0x7f756767f000, 4096)            = 0
open("/u01/app/oracle/product/11.2.0/dbhome_1/oracore/zoneinfo/timezlrg_13.dat", O_RDONLY) = 9
fstat(9, {st_mode=S_IFREG|0644, st_size=782475, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f756767f000
read(9, "ZTrO\213\360\v\0\3\0\r\0\2\0'\2\322j\0\0\325\3\0\0<\0\2\0t\21\2\0"..., 4096) = 4096
close(9)                                = 0
munmap(0x7f756767f000, 4096)            = 0
open("/u01/app/oracle/product/11.2.0/dbhome_1/oracore/zoneinfo/timezlrg_10.dat", O_RDONLY) = 9
fstat(9, {st_mode=S_IFREG|0644, st_size=792894, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f756767f000
read(9, "ZTrO>\31\f\0\3\0\n\0\2\0&\2\234l\0\0\314\3\0\0<\0\2\0l\21\2\0"..., 4096) = 4096
close(9)                                = 0
munmap(0x7f756767f000, 4096)            = 0
open("/u01/app/oracle/product/11.2.0/dbhome_1/oracore/zoneinfo/timezone_2.dat", O_RDONLY) = 9
fstat(9, {st_mode=S_IFREG|0644, st_size=274900, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f756767f000
read(9, "ZTrO\3241\4\0\3\0\2\0\1\0\272\0U\27\0\0\352\0\0\0<\0\2\0\f\6\2\0"..., 4096) = 4096
close(9)                                = 0
munmap(0x7f756767f000, 4096)            = 0
open("/u01/app/oracle/product/11.2.0/dbhome_1/oracore/zoneinfo/timezlrg_8.dat", O_RDONLY) = 9
fstat(9, {st_mode=S_IFREG|0644, st_size=616723, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f756767f000
read(9, "ZTrO\23i\t\0\3\0\10\0\2\0\21\2\332N\0\0\247\3\0\0<\0\2\0\304\20\2\0"..., 4096) = 4096
close(9)                                = 0
munmap(0x7f756767f000, 4096)            = 0
open("/u01/app/oracle/product/11.2.0/dbhome_1/oracore/zoneinfo/timezone_3.dat", O_RDONLY) = 9
fstat(9, {st_mode=S_IFREG|0644, st_size=286651, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f756767f000
read(9, "ZTrO\273_\4\0\3\0\3\0\1\0\272\0R\31\0\0\357\0\0\0<\0\2\0\f\6\2\0"..., 4096) = 4096
close(9)                                = 0
munmap(0x7f756767f000, 4096)            = 0
open("/u01/app/oracle/product/11.2.0/dbhome_1/oracore/zoneinfo/timezone_7.dat", O_RDONLY) = 9
fstat(9, {st_mode=S_IFREG|0644, st_size=286815, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f756767f000
read(9, "ZTrO_`\4\0\3\0\7\0\1\0\275\0Z\31\0\0\357\0\0\0<\0\2\0$\6\2\0"..., 4096) = 4096
close(9)                                = 0
munmap(0x7f756767f000, 4096)            = 0
open("/u01/app/oracle/product/11.2.0/dbhome_1/oracore/zoneinfo/timezone_10.dat", O_RDONLY) = 9
fstat(9, {st_mode=S_IFREG|0644, st_size=345637, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f756767f000
read(9, "ZTrO%F\5\0\3\0\n\0\1\0\306\0F#\0\0\375\0\0\0<\0\2\0l\6\2\0"..., 4096) = 4096
close(9)                                = 0
munmap(0x7f756767f000, 4096)            = 0
open("/u01/app/oracle/product/11.2.0/dbhome_1/oracore/zoneinfo/timezlrg_7.dat", O_RDONLY) = 9
fstat(9, {st_mode=S_IFREG|0644, st_size=601242, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f756767f000
read(9, "ZTrO\232,\t\0\3\0\7\0\2\0\10\2IL\0\0\233\3\0\0<\0\2\0|\20\2\0"..., 4096) = 4096
close(9)                                = 0
munmap(0x7f756767f000, 4096)            = 0
open("/u01/app/oracle/product/11.2.0/dbhome_1/oracore/zoneinfo/little", O_RDONLY) = 9
fstat(9, {st_mode=S_IFDIR|0755, st_size=4096, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f756767f000
read(9, 0x7f756767f000, 4096)           = -1 EISDIR (Is a directory)
close(9)                                = 0
munmap(0x7f756767f000, 4096)            = 0
open("/u01/app/oracle/product/11.2.0/dbhome_1/oracore/zoneinfo/timezone_14.dat", O_RDONLY) = 9
fstat(9, {st_mode=S_IFREG|0644, st_size=344448, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f756767f000
read(9, "ZTrO\200A\5\0\3\0\16\0\1\0\307\0\n#\0\0\f\1\0\0<\0\2\0t\6\2\0"..., 4096) = 4096
close(9)                                = 0
munmap(0x7f756767f000, 4096)            = 0
getdents(8, /* 0 entries */, 32768)     = 0
close(8)                                = 0
open("/u01/app/oracle/product/11.2.0/dbhome_1/oracore/zoneinfo/timezlrg_14.dat", O_RDONLY) = 8
fstat(8, {st_mode=S_IFREG|0644, st_size=791430, ...}) = 0
mmap(NULL, 791430, PROT_READ, MAP_PRIVATE|MAP_NORESERVE, 8, 0) = 0x7f7567178000
close(8)                                = 0
getrlimit(RLIMIT_STACK, {rlim_cur=10240*1024, rlim_max=32768*1024}) = 0
open("/usr/lib64/libnuma.so", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/usr/lib64/libnuma.so.1", O_RDONLY) = 8
read(8, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0 3\240\2428\0\0\0"..., 832) = 832
fstat(8, {st_mode=S_IFREG|0755, st_size=47464, ...}) = 0
mmap(0x38a2a00000, 2140992, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 8, 0) = 0x38a2a00000
mprotect(0x38a2a0a000, 2097152, PROT_NONE) = 0
mmap(0x38a2c0a000, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 8, 0xa000) = 0x3                                                         8a2c0a000
close(8)                                = 0
open("/proc/self/status", O_RDONLY)     = 8
fstat(8, {st_mode=S_IFREG|0444, st_size=0, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f756767f000
read(8, "Name:\tsqlplus\nState:\tR (running)"..., 1024) = 1024
read(8, "0,00000000,00000000,00000000,000"..., 1024) = 137
close(8)                                = 0
munmap(0x7f756767f000, 4096)            = 0
open("/sys/devices/system/node", O_RDONLY|O_NONBLOCK|O_DIRECTORY|O_CLOEXEC) = 8
getdents(8, /* 9 entries */, 32768)     = 280
open("/sys/devices/system/node/node0/meminfo", O_RDONLY) = 9
fstat(9, {st_mode=S_IFREG|0444, st_size=4096, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f756767f000
read(9, "Node 0 MemTotal:        3054896 "..., 4096) = 1000
read(9, "", 4096)                       = 0
close(9)                                = 0
munmap(0x7f756767f000, 4096)            = 0
getdents(8, /* 0 entries */, 32768)     = 0
close(8)                                = 0
sched_getaffinity(0, 512, {1})          = 8
open("/sys/devices/system/cpu", O_RDONLY|O_NONBLOCK|O_DIRECTORY|O_CLOEXEC) = 8
getdents(8, /* 13 entries */, 32768)    = 392
getdents(8, /* 0 entries */, 32768)     = 0
close(8)                                = 0
open("/proc/self/status", O_RDONLY)     = 8
fstat(8, {st_mode=S_IFREG|0444, st_size=0, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f756767f000
read(8, "Name:\tsqlplus\nState:\tR (running)"..., 1024) = 1024
read(8, "0,00000000,00000000,00000000,000"..., 1024) = 137
read(8, "", 1024)                       = 0
close(8)                                = 0
munmap(0x7f756767f000, 4096)            = 0
get_mempolicy(NULL, {}, 0, 0, 0)        = 0
open("/proc/sys/kernel/shmmax", O_RDONLY) = 8
fstat(8, {st_mode=S_IFREG|0644, st_size=0, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f756767f000
read(8, "4398046511104\n", 1024)        = 14
close(8)                                = 0
munmap(0x7f756767f000, 4096)            = 0
open("/proc/meminfo", O_RDONLY)         = 8
fstat(8, {st_mode=S_IFREG|0444, st_size=0, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f756767f000
read(8, "MemTotal:        3054896 kB\nMemF"..., 1024) = 1024
read(8, "         16384 kB\nCmaFree:      "..., 1024) = 230
close(8)                                = 0
munmap(0x7f756767f000, 4096)            = 0
getrlimit(RLIMIT_STACK, {rlim_cur=10240*1024, rlim_max=32768*1024}) = 0
setrlimit(RLIMIT_STACK, {rlim_cur=32768*1024, rlim_max=32768*1024}) = 0
open("/usr/lib64/libnuma.so", O_RDONLY) = -1 ENOENT (No such file or directory)
get_mempolicy(NULL, {}, 0, 0, 0)        = 0
getrlimit(RLIMIT_STACK, {rlim_cur=32768*1024, rlim_max=32768*1024}) = 0
getrlimit(RLIMIT_STACK, {rlim_cur=32768*1024, rlim_max=32768*1024}) = 0
setrlimit(RLIMIT_STACK, {rlim_cur=10240*1024, rlim_max=32768*1024}) = 0
open("/etc/localtime", O_RDONLY)        = 8
fstat(8, {st_mode=S_IFREG|0644, st_size=1159, ...}) = 0
fstat(8, {st_mode=S_IFREG|0644, st_size=1159, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f756767f000
read(8, "TZif2\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\4\0\0\0\4\0\0\0\0"..., 4096) = 1159
lseek(8, -721, SEEK_CUR)                = 438
read(8, "TZif2\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\4\0\0\0\4\0\0\0\0"..., 4096) = 721
close(8)                                = 0
munmap(0x7f756767f000, 4096)            = 0
open("/u01/app/oracle/product/11.2.0/dbhome_1/rdbms/mesg/ocius.msb", O_RDONLY) = 8
fcntl(8, F_SETFD, FD_CLOEXEC)           = 0
lseek(8, 0, SEEK_SET)                   = 0
read(8, "\25\23\"\1\23\3\t\t\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 256) = 256
lseek(8, 512, SEEK_SET)                 = 512
read(8, "\337y\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 512) = 512
lseek(8, 1024, SEEK_SET)                = 1024
read(8, "\25\7'\0072\7>\7J\7U\7#\10\326\17Q'\7K5S\24TDTbT\304T\315T"..., 94) = 94
mmap(NULL, 135168, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f7567157000
brk(0x1333000)                          = 0x1333000
times({tms_utime=0, tms_stime=0, tms_cutime=0, tms_cstime=0}) = 433983471
rt_sigprocmask(SIG_BLOCK, [INT], NULL, 8) = 0
rt_sigaction(SIGINT, {0x7f756916afd4, ~[ILL ABRT BUS FPE SEGV USR2 XCPU XFSZ SYS RTMIN RT_1], SA_RES                                                         TORER|SA_RESTART|SA_SIGINFO, 0x389f60f7e0}, {SIG_DFL, [], 0}, 8) = 0
rt_sigprocmask(SIG_UNBLOCK, [INT], NULL, 8) = 0
brk(0x1356000)                          = 0x1356000
fstat(1, {st_mode=S_IFCHR|0620, st_rdev=makedev(136, 1), ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f756767f000
write(1, "\n", 1)                       = 1
write(1, "SQL*Plus: Release 11.2.0.4.0 Pro"..., 68) = 68
write(1, "\n", 1)                       = 1
write(1, "Copyright (c) 1982, 2013, Oracle"..., 56) = 56
write(1, "\n", 1)                       = 1
mmap(NULL, 143360, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f7567134000
munmap(0x7f7567134000, 143360)          = 0
stat("/u01/app/oracle/product/11.2.0/dbhome_1/sqlplus/admin/glogin.sql", {st_mode=S_IFREG|0644, st_s                                                         ize=408, ...}) = 0
access("/u01/app/oracle/product/11.2.0/dbhome_1/sqlplus/admin/glogin.sql", F_OK) = 0
statfs("/u01/app/oracle/product/11.2.0/dbhome_1/sqlplus/admin/glogin.sql", {f_type="EXT2_SUPER_MAGIC                                                         ", f_bsize=4096, f_blocks=12868767, f_bfree=6697206, f_bavail=6037750, f_files=3276800, f_ffree=3069                                                         836, f_fsid={-807499197, 950378274}, f_namelen=255, f_frsize=4096}) = 0
open("/u01/app/oracle/product/11.2.0/dbhome_1/sqlplus/admin/glogin.sql", O_RDONLY) = 9
read(9, "--\n-- Copyright (c) 1988, 2011, "..., 57344) = 408
brk(0x1382000)                          = 0x1382000
read(9, "", 57344)                      = 0
close(9)                                = 0
write(1, "@>", 2)                       = 2
fstat(0, {st_mode=S_IFCHR|0620, st_rdev=makedev(136, 1), ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f756767e000
read(0, "conn / as sysdba\n", 1024)     = 17
getcwd("/u01/app/oracle/product/11.2.0/dbhome_1/sqlplus/admin", 256) = 54
open("/u01/app/oracle/product/11.2.0/dbhome_1/rdbms/mesg/oraus.msb", O_RDONLY) = 9
fcntl(9, F_SETFD, FD_CLOEXEC)           = 0
lseek(9, 0, SEEK_SET)                   = 0
read(9, "\25\23\"\1\23\3\t\t\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 256) = 256
lseek(9, 512, SEEK_SET)                 = 512
read(9, "f\31\2603gJ>h\374y\311\2072\226Q\310m\374\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 512) = 512
lseek(9, 1536, SEEK_SET)                = 1536
read(9, "q\31|\31\210\31\222\31\234\31\245\31\256\31\302\31\313\31\327\31/\32B\32X\32d\32s\32\207\32                                                         "..., 512) = 512
lseek(9, 234496, SEEK_SET)              = 234496
read(9, "\v\0{/\0\0J\0|/\0\0w\0}/\0\0\243\0~/\0\0\313\0\177/\0\0\367\0"..., 512) = 512
close(9)                                = 0
lseek(4, 5120, SEEK_SET)                = 5120
read(4, "\r\0\351\0\0\0V\0\352\0\0\0\220\0\353\0\0\0\240\0\356\0\0\0\320\0\357\0\0\0\344\0"..., 512)                                                          = 512
write(1, "ERROR:\n", 7)                 = 7
write(1, "ORA-12162: TNS:net service name "..., 57) = 57
write(1, "\n", 1)                       = 1
write(1, "\n", 1)                       = 1
write(1, "@>", 2)                       = 2
read(0, "exit\n", 1024)                 = 5
rt_sigprocmask(SIG_BLOCK, [INT], NULL, 8) = 0
rt_sigaction(SIGINT, {SIG_DFL, ~[ILL ABRT BUS FPE SEGV USR2 XCPU XFSZ SYS RTMIN RT_1], SA_RESTORER|S                                                         A_RESTART|SA_SIGINFO, 0x389f60f7e0}, {0x7f756916afd4, ~[ILL ABRT BUS FPE KILL SEGV USR2 STOP XCPU XF                                                         SZ SYS RTMIN RT_1], SA_RESTORER|SA_RESTART|SA_SIGINFO, 0x389f60f7e0}, 8) = 0
rt_sigprocmask(SIG_UNBLOCK, [INT], NULL, 8) = 0
close(8)                                = 0
munmap(0x7f7567157000, 135168)          = 0
close(5)                                = 0
close(3)                                = 0
close(4)                                = 0
munmap(0x7f7567447000, 143360)          = 0
exit_group(0)                           = ?
+++ exited with 0 +++
[oracle@test admin]$
End
记录一次sqlplus客户端无响应问题处理
糊了hule的博客
07-19 1893
上午给一台应用服务器配置oracle客户端,复制oracle客户端压缩包并解压，配置环境变量后，测试可用就甩给维护人员了，下午收到通知sqlplus用不了！用不了！用不了！登陆服务器-bash-4.1$ iduid=701(oracle) gid=700(dba) groups=700(dba)-bash-4.1$-bash-4.1$-bash-4.1$ cat .bash_profile#...
instantclient-sqlplus-linux.x64-11.2.0.4.0
09-19
sqlplus /nolog connect username/password@//hostname:port/service_name ``` 此外，Instant Client还支持OCI（Oracle Call Interface）和ODBC（Open Database Connectivity），使得其他应用程序能够通过API调用来...
oracle命令sqlplus/nolog无法进入
csdn_tym的博客
07-22 7103
cmd->sqlplus/nolog 登录sqlplus时，提示“sqlplus不是内部或外部命令，也不是可运行的程序或批处理文件” 可能原因：①没有正确安装oracle客户端 ②没有将oracle注册到path系统环境变量中 ③oracle相关文件损坏 解决方法：针对第二种原因  计算机（右键）--属性--高级系统设置--高级--环境变量--新建--输入
Oracle底层原理解析-适用于DBA
最新发布
Albert Tan DBA之路
03-14 1291
Oracle底层原理解析-适用于DBA
关于dbstart脚本启动数据库后无法使用sqlplus /nolog连接的问题
08-18 225
问题描述：如果用dbstart启动数据库，启动正常，用dbstop也能正常关闭。如果用sqlplus /nolog连接数据库，在startup正常，shutdown也正常。若用dbstart启动数据库，之后用sqlplus /n...
Linux Tomcat 下的项目局域网中访问不了
我的成长之路
05-23 509
1.在自己虚拟机的centos系统的tomcat下发布了一个程序，在虚拟机上用   http://localhost/xxx  和  http://172.16.1.160/xxx 可以访问，但是在 局域网中用  http://172.16.1.160/xxx 访问不了 ------------------------------------------------------------...
sqlplus连接oracle直接卡死,求教 pl/sql连接本机数据库是未响应问题
weixin_35501678的博客
04-10 1256
该楼层疑似违规已被系统折叠隐藏此楼查看此楼本机安装ORACLE 10G，可以用sqlplus连接上数据库，但是用PLSQL Developer连接数据库时会出现卡死情况,连接其他数据库没有问题 请问高手是怎么回事！TNS配置：# tnsnames.ora Network Configuration File: D:\oracle\product\10.2.0\db_1\network\admi...
linux系统oracle数据库出现ora12505问题的解决方法
09-09
在Linux系统中，Oracle数据库可能会遇到各种问题，其中ORA-12505错误是一个常见的问题，它通常表示客户端尝试连接到数据库时，监听器没有识别或无法响应请求的服务。以下是一些解决ORA-12505问题的步骤和详细解释： ...
AWR生成方法汇总，linux和windows
10-22
- 输入`sqlplus/nolog`进入SQL*Plus环境。 - 再次输入`sqlplus/nolog`确认进入。 - 使用`connsys/zlsoft@demoassysdba`命令连接到数据库，其中`sys`是用户名，`zlsoft`是密码，`demoa`是服务名，`sysdba`表示以...
Oracle 常用命令完整版
06-20
以`root`用户切换到`oracle`用户，然后进入SQL*Plus环境，使用`sqlplus /nolog`。要以管理员身份登录，执行`sqlplus / as sysdba`，接着输入`startup`启动数据库，`shutdown immediate`则可立即停止数据库。若要远程...
数据库sqlplus连接及启动很慢
文档搬运工
03-08 1664
RDBMS 19.14 ，实际是从11.2.0.4升级到12.2.0.1，再升级到19c。 现象： 1 通过sqlplus /nolog连接的时候，很慢，大约7秒以上 2 startup 启动数据库，也很慢，大约26秒左右 -- 之前连接，大约7秒左右 [oracle@redhat762100 ~]$ sqlplus /nolog SQL*Plus: Release 19.0.0.0.0 - Production on Tue Mar 8 14:32:30 2022 Version 19.14
oracle脚本执行连接断开,关于dbstart脚本启动数据库后无法使用sqlplus /nolog连接的问题...
weixin_36218209的博客
04-07 294
问题描述：如果用dbstart启动数据库，启动正常，用dbstop也能正常关闭。如果用sqlplus /nolog连接数据库，在startup正常，shutdown也正常。若用dbstart启动数据库，之后用sqlplus /nolog连接，则出现以下错误sqlplus /nologSQL> connect /as sysdbaConnected to an idle instance.SQ...
oracle11g nolog,Oracle11g - dos 命令 sqlplus/nolog 提示 不是内部命令解决办法
weixin_32955207的博客
04-10 222
http状态代码-转载一些常见的状态码为: 200 – 服务器成功返回网页 404 – 请求的网页不存在 503 – 服务不可用 1xx(临时响应) 表示临时响应并需要请求者继续执行操作的状态代码. 代码 说明 100 ( ...python3&period;5------购物车笔者:QQ: 360212316 逻辑图 程序代码 # /usr/bin/env python # -*- ...
oracle退出sqlplus,改回oracle.key文件后的sqlplus进不去了.
weixin_35051623的博客
04-02 251
在上一篇帖子中,我做了如下更改:改oracle.key文件的内容如下:SOFTWARE\ORACLE\KEY_OraDb10g_home111 ,也就是在最后追加了11在本帖中,我将追加的11去掉,然后再保存,退出.然后再登陆sqlplus,报错Microsoft Windows XP [版本 5.1.2600](C) 版权所有 1985-2001 Microsoft Corp.C:\Docume...
PL/SQL登陆不成功!出现no logging
qq_27447897的博客
09-08 791
在确保登录名,密码等都配置正确之后.仍然无法登陆. 请看以下代码: @echo off set path=D:\oracle\orclClient\oracle set ORACLE_HOME=D:\oracle\orclClient\oracle set TNS_ADMIN=D:\oracle\orclClient\oracle set NLS_LANG=AMERICAN_AMERI
Linux下Oracle sqlplus无响应
ckreglt13022的博客
02-14 435
操作系统版本：Red Hat Enterprise Linux Server release 5.4 i686 数据库版本：Oracle 10.2.0.1 测试环境一台服务器，使用sqlplus无响应，不仅是sqlpl...
sqlplus登录卡死无响应异常处理
Ruishine的博客
03-15 1896
通过Sqlplus 访问数据hang死在登录界面，且不能通过Ctrl+C取消。
sqlplus命令无响应，cpu占用率很高的问题处理
02-16 490
今天准备连接一台测试服务器的数据库，但是迟迟未能连上。直接登录主机，用sqlplus连，一直没反应。杀掉进程也无法连接sqlplus。 实在搞不清楚为什么，抱着试试看的心情搜索了一下，却发现这是普遍现象。 下面是一篇文章： ...
oracle 卡住的语句,求助！一个简单的语句在SQLPLUS里面卡住，奇怪
weixin_42231590的博客
04-15 299
现在数据库里面全是这种锁~~~郁闷，找不到原因啊SQL> select * from v$lock order by ctime;ADDR KADDR SID TY ID1 ID2 LMODE REQUEST CTIME BLOCK---------------- --...
oracle12c linux静默安装步骤
05-18
Oracle 12c的Linux静默安装步骤如下： 1. 准备安装文件 下载Oracle 12c的Linux安装文件，解压到本地目录。 2. 创建响应文件 使用Oracle提供的工具创建响应文件（response file），响应文件是用来自动化安装过程中需要输入的各种参数的文件。 例如： ``` [ENGINE] Response File Version=1.0.0.0.0 [GENERIC] ORACLE_HOME=/u01/app/oracle/product/12.1.0/dbhome_1 UNIX_GROUP_NAME=oinstall INVENTORY_LOCATION=/u01/app/oraInventory SELECTED_LANGUAGES=en,zh_CN ``` 其中，`ORACLE_HOME`指定Oracle软件的安装目录，`UNIX_GROUP_NAME`指定Oracle软件所属的组，`INVENTORY_LOCATION`指定Oracle Inventory的目录，`SELECTED_LANGUAGES`指定需要安装的语言。 3. 开始安装 使用以下命令开始安装： ``` ./runInstaller -silent -responseFile /path/to/response/file.rsp ``` 安装过程中，Oracle会读取响应文件中指定的参数，完成自动化安装。 4. 验证安装 安装完成后，使用以下命令验证Oracle是否正常运行： ``` $ORACLE_HOME/bin/sqlplus /nolog SQL> connect / as sysdba SQL> select instance_name from v$instance; ``` 如果返回正确的实例名，则说明Oracle已经成功安装。
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值