'sqlplus'에 해당되는 글 1건
- 2011.09.25 Unix에서 Oracle 사용자 찾아서 sqlplus 실행시키기
- Unix에서 Oracle 사용자 찾아서 sqlplus 실행시키기
- 日常茶飯事
- 2011. 9. 25. 21:05
root로 작업중에 sqlplus를 실행시키지 못하고 있음.
$ cat /etc/passwd //어떤 사용자가 있나
root:!:0:0:- KR/E/000070//system admin:/:/usr/bin/ksh
daemon:!:1:1:- KR/E/000070//system admin:/etc:
...
xxxadm:!:417:404:SAP System Administrator:/home/xxxadm:/bin/csh
oraxxx:!:418:406:SAP Database Administrator:/oracle/XXX:/bin/csh //오라클 사용자다.
$ su - oraxxx
> env
PATH=/oracle/XXX/99_64/bin:/oracle/XXX:/usr/sap/XXX/SYS/exe/run:/usr/bin:/etc:/usr/sbin:/usr/ucb:/oracle/XXX/bin:/usr/bin/X11:/sbin:.
...
LANG=en_US
LOGIN=oraxxx
SAPSYSTEMNAME=XXX
DIR_LIBRARY=/usr/sap/XXX/SYS/exe/run
dbms_type=ORA
dbs_ora_tnsname=XXX
ORACLE_SID=XXX
DB_SID=XXX
ORACLE_BASE=/oracle
ORACLE_HOME=/oracle/XXX/99_64
NLS_LANG=AMERICAN_AMERICA.UTF8
SAPDATA_HOME=/oracle/XXX
NLSPATH=/usr/lib/nls/msg/%L/%N:/usr/lib/nls/msg/%L/%N.cat
LIBPATH=/usr/lib:/lib:/usr/sap/XXX/SYS/exe/run:/oracle/XXX/99_64/lib
> sqlplus orauser
SQL*Plus: Release 10.2.0.1.0 - Production on Sun Sep 25 20:01:15 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Enter password:
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning and Data Mining options
root:!:0:0:- KR/E/000070//system admin:/:/usr/bin/ksh
daemon:!:1:1:- KR/E/000070//system admin:/etc:
...
xxxadm:!:417:404:SAP System Administrator:/home/xxxadm:/bin/csh
oraxxx:!:418:406:SAP Database Administrator:/oracle/XXX:/bin/csh //오라클 사용자다.
$ su - oraxxx
> env
PATH=/oracle/XXX/99_64/bin:/oracle/XXX:/usr/sap/XXX/SYS/exe/run:/usr/bin:/etc:/usr/sbin:/usr/ucb:/oracle/XXX/bin:/usr/bin/X11:/sbin:.
...
LANG=en_US
LOGIN=oraxxx
SAPSYSTEMNAME=XXX
DIR_LIBRARY=/usr/sap/XXX/SYS/exe/run
dbms_type=ORA
dbs_ora_tnsname=XXX
ORACLE_SID=XXX
DB_SID=XXX
ORACLE_BASE=/oracle
ORACLE_HOME=/oracle/XXX/99_64
NLS_LANG=AMERICAN_AMERICA.UTF8
SAPDATA_HOME=/oracle/XXX
NLSPATH=/usr/lib/nls/msg/%L/%N:/usr/lib/nls/msg/%L/%N.cat
LIBPATH=/usr/lib:/lib:/usr/sap/XXX/SYS/exe/run:/oracle/XXX/99_64/lib
> sqlplus orauser
SQL*Plus: Release 10.2.0.1.0 - Production on Sun Sep 25 20:01:15 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Enter password:
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning and Data Mining options
Recent comment