- 论坛徽章:
- 0
|
[root@WebServer root]# cd ..
[root@WebServer /]# cd home/oracle/OraHome1
[root@WebServer OraHome1]# su oracle
#####################################################
下面是启动监听服务
#####################################################
[oracle@WebServer OraHome1]$ export ORACLE_HOME=/home/oracle/OraHome1
[oracle@WebServer OraHome1]$ bin/lsnrctl start
LSNRCTL for Linux: Version 9.2.0.1.0 - Production on 20-JAN-2003 16:13:11
Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
Starting /home/oracle/OraHome1/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 9.2.0.1.0 - Production
System parameter file is /home/oracle/OraHome1/network/admin/listener.ora
Log messages written to /home/oracle/OraHome1/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=WebServer.HCIC)(PORT=152
1)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=WebServer.HCIC)(PORT=248
1))(PROTOCOL_STACK=(PRESENTATION=GIOP)(SESSION=RAW)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 9.2.0.1.0 - Production
Start Date 20-JAN-2003 16:13:11
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File /home/oracle/OraHome1/network/admin/listener.ora
Listener Log File /home/oracle/OraHome1/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=WebServer.HCIC)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=WebServer.HCIC)(PORT=2481))(PROTOCOL _STACK=(PRESENTATION=GIOP)(SESSION=RAW)))
Services Summary...
Service "Oracle.HLJ" has 1 instance(s).
Instance "Oracle", status UNKNOWN, has 1 handler(s) for this service...
Service " LSExtProc" has 1 instance(s).
Instance "LSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
#####################################################
执行结果：如上。
问题1:上面启动监听服务是否正常?应该正常吧?
下面是启动sqlplus
#####################################################
[oracle@WebServer OraHome1]$ bin/sqlplus "/ as sysdba"
SQL*Plus: Release 9.2.0.1.0 - Production on Mon Jan 20 16:14:17 2003
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected.
SQL>; desc emp
ERROR:
ORA-01034: ORACLE not available
SQL>; quit
Disconnected
#####################################################
执行结果：如上。
问题2:错误的原因是什么?是否因为没有创建数据库?
下面是创建数据库
#####################################################
[oracle@WebServer OraHome1]$ bin/dbca
#####################################################
执行结果：出现图形界面,但应显示汉字的地方都是ooooooo
下面是修改成英文字符后,创建数据库
#####################################################
[oracle@WebServer OraHome1]$ export LANG=en_US
[oracle@WebServer OraHome1]$ bin/dbca
SIGSEGV 11* segmentation violation
stackbase=0xbffff008, stackpointer=0xbfffeed0
Full thread dump:
"Finalizer thread" (TID:0x430f5210, sys_thread_t:0x403a9e0c, state:R) prio=1
"Async Garbage Collector" (TID:0x430f5258, sys_thread_t:0x40388e0c, state:R) prio=1
"Idle thread" (TID:0x430f52a0, sys_thread_t:0x40367e0c, state:R) prio=0
"Clock" (TID:0x430f5088, sys_thread_t:0x40346e0c, state:CW) prio=12
"main" (TID:0x430f50b0, sys_thread_t:0x8231008, state:R) prio=5 *current thread*
java.lang.System.initializeSystemClass(System.java)
Monitor Cache Dump:
Registered Monitor Dump:
Thread queue lock: <unowned>;
Name and type hash table lock: <unowned>;
String intern lock: <unowned>;
JNI pinning lock: <unowned>;
JNI global reference lock: <unowned>;
BinClass lock: <unowned>;
Class loading lock: <unowned>;
Java stack lock: <unowned>;
Code rewrite lock: <unowned>;
Heap lock: <unowned>;
Has finalization queue lock: <unowned>;
Finalize me queue lock: <unowned>;
Dynamic loading lock: <unowned>;
Monitor IO lock: <unowned>;
Child death monitor: <unowned>;
Event monitor: <unowned>;
I/O monitor: <unowned>;
Alarm monitor: <unowned>;
Waiting to be notified:
"Clock" (0x40346e0c)
Monitor registry: owner "main" (0x8231008, 1 entry)
Thread Alarm Q:
bin/dbca: line 124: 1625 Aborted $JRE_DIR/bin/jre -DORACLE_HOME=$OH -DJDBC_PROTOCOL=thin -mx64m -classpath $CLASSPATH oracle.sysman.assistants.dbca.Dbca $ARGUMENTS
#####################################################
执行结果：如上。无法启动
下面是修改成中文字符后,创建数据库
#####################################################
[oracle@WebServer OraHome1]$ export LANG=zh_CN
[oracle@WebServer OraHome1]$ bin/dbca
#####################################################
执行结果：出现图形界面,显示汉字正常,但无法接受键盘的输入
问题3:我如何才能新创建一个数据库?
#####################################################
[oracle@WebServer OraHome1]$
#####################################################
问题4:下面是Oracle用户的.bash_profile文件.请高手看看,存在哪些错误.
#####################################################
# .bash_profile
#??Oracle??Environment
export??ORACLE_BASE=/home/oracle
export??ORACLE_HOME=/home/oracle/OraHome1
export??ORACLE_SID=Oracle
export??ORACLE_TERM=xterm
#export??TNS_ADMIN=??设置这个变量，如果??sqlnet.ora,??tnsnames.ora等不在$ORACLE_HOME/network/admin??目录下。
NLS_LANG=en_us; export??NLS_LANG=en_US
export??ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/usr/openwin/lib
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/td/lib:/usr/ucblib:/usr/local/lib
export??LD_LIBRARY_PATH
#??Set??shell??search??paths:
PATH=/bin:/usr/bin:/usr/sbin:/etc:/opt/bin:/usr/ccs/bin:/usr/openwin/bin:/opt/local/GNU/bin
PATH=$PATH:/opt/local/bin:/opt/NSCPnav/bin ORACLE_HOME/bin??
PATH=$PATH:/usr/local/samba/bin:/usr/ucb:
export??PATH
#??CLASSPATH??must??include??the??following??JRE??locations:
CLASSPATH=$ORACLE_HOME/JREORACLE_HOME/jlibORACLE_HOME/rdbms/jlib
CLASSPATH=$CLASSPATHORACLE_HOME/network/jlib
#####################################################
问题完,谢谢.
##################################################### |
|
免费注册
发表于 2003-01-20 01:20
