安装完成Oracle之后,无法登录,不知道该如何配置,求助大佬

安装完成Oracle之后,无法登录,不知道该如何配置,求助大佬
附上安装图



Oracle Database 11g Express Edition Configuration
-------------------------------------------------
This will configure on-boot properties of Oracle Database 11g Express 
Edition.  The following questions will determine whether the database should 
be starting upon system boot, the ports it will use, and the passwords that 
will be used for database accounts.  Press <Enter> to accept the defaults. 
Ctrl-C will abort.

Specify the HTTP port that will be used for Oracle Application Express [8080]:7070

/etc/init.d/oracle-xe: line 362: netstat: command not found
Specify a port that will be used for the database listener [1521]:

/etc/init.d/oracle-xe: line 405: netstat: command not found
Specify a password to be used for database accounts.  Note that the same
password will be used for SYS and SYSTEM.  Oracle recommends the use of 
different passwords for each database account.  This can be done after 
initial configuration:
Confirm the password:

Do you want Oracle Database 11g Express Edition to be started on boot (y/n) [y]:y

/bin/sed: can't read /u01/app/oracle/product/11.2.0/xe/network/admin/listener.ora: No such file or directory
/bin/sed: can't read /u01/app/oracle/product/11.2.0/xe/network/admin/listener.ora: No such file or directory
/bin/chown: invalid user: 'oracle:dba'
sed: can't read /u01/app/oracle/product/11.2.0/xe/config/scripts/postDBCreation.sql: No such file or directory
/bin/chown: invalid user: 'oracle:dba'
/bin/sed: can't read /u01/app/oracle/product/11.2.0/xe/network/admin/tnsnames.ora: No such file or directory
/bin/sed: can't read /u01/app/oracle/product/11.2.0/xe/network/admin/tnsnames.ora: No such file or directory
/bin/chown: invalid user: 'oracle:dba'
/bin/chown: invalid user: 'oracle:dba'
Starting Oracle Net Listener...Done
Configuring database...Done
/bin/chmod: cannot access '/u01/app/oracle/oradata': No such file or directory
/bin/chmod: cannot access '/u01/app/oracle/diag': No such file or directory
/bin/chown: invalid user: 'oracle:dba'
Starting Oracle Database 11g Express Edition instance...Done
Installation completed successfully.
root@jingsongchan:/home/jingsongchan# sudo service oracle-xe start
Job for oracle-xe.service failed because the control process exited with error code.
See "systemctl status oracle-xe.service" and "journalctl -xe" for details.
root@jingsongchan:/home/jingsongchan# systemctl status oracle-xe.service
● oracle-xe.service - SYSV: This is a program that is responsible for taking car
   Loaded: loaded (/etc/init.d/oracle-xe; generated)
   Active: failed (Result: exit-code) since Thu 2019-09-05 18:43:04 CST; 22s ago
     Docs: man:systemd-sysv-generator(8)
  Process: 3861 ExecStart=/etc/init.d/oracle-xe start (code=exited, status=1/FAI

9月 05 18:43:04 jingsongchan su[3872]: FAILED su for oracle by root
9月 05 18:43:04 jingsongchan su[3872]: - ??? root:oracle
9月 05 18:43:04 jingsongchan oracle-xe[3861]: Starting Oracle Database 11g Expre
9月 05 18:43:04 jingsongchan su[3878]: No passwd entry for user 'oracle'
9月 05 18:43:04 jingsongchan su[3878]: FAILED su for oracle by root
9月 05 18:43:04 jingsongchan su[3878]: - ??? root:oracle
9月 05 18:43:04 jingsongchan oracle-xe[3861]: Failed to start Oracle Net Listene
9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Control process exit
9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Failed with result '
9月 05 18:43:04 jingsongchan systemd[1]: Failed to start SYSV: This is a program
lines 1-16/16 (END)...skipping...
● oracle-xe.service - SYSV: This is a program that is responsible for taking car
   Loaded: loaded (/etc/init.d/oracle-xe; generated)
   Active: failed (Result: exit-code) since Thu 2019-09-05 18:43:04 CST; 22s ago
     Docs: man:systemd-sysv-generator(8)
  Process: 3861 ExecStart=/etc/init.d/oracle-xe start (code=exited, status=1/FAI

9月 05 18:43:04 jingsongchan su[3872]: FAILED su for oracle by root
9月 05 18:43:04 jingsongchan su[3872]: - ??? root:oracle

9月 05 18:43:04 jingsongchan oracle-xe[3861]: Starting Oracle Database 11g Expre
9月 05 18:43:04 jingsongchan su[3878]: No passwd entry for user 'oracle'
9月 05 18:43:04 jingsongchan su[3878]: FAILED su for oracle by root
9月 05 18:43:04 jingsongchan su[3878]: - ??? root:oracle
9月 05 18:43:04 jingsongchan oracle-xe[3861]: Failed to start Oracle Net Listene
9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Control process exit
9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Failed with result '
9月 05 18:43:04 jingsongchan systemd[1]: Failed to start SYSV: This is a program
~
~
~
~
~
~
~
~
lines 1-16/16 (END)...skipping...
● oracle-xe.service - SYSV: This is a program that is responsible for taking car
   Loaded: loaded (/etc/init.d/oracle-xe; generated)
   Active: failed (Result: exit-code) since Thu 2019-09-05 18:43:04 CST; 22s ago
     Docs: man:systemd-sysv-generator(8)
  Process: 3861 ExecStart=/etc/init.d/oracle-xe start (code=exited, status=1/FAI

9月 05 18:43:04 jingsongchan su[3872]: FAILED su for oracle by root
9月 05 18:43:04 jingsongchan su[3872]: - ??? root:oracle
9月 05 18:43:04 jingsongchan oracle-xe[3861]: Starting Oracle Database 11g Expre
9月 05 18:43:04 jingsongchan su[3878]: No passwd entry for user 'oracle'
9月 05 18:43:04 jingsongchan su[3878]: FAILED su for oracle by root
9月 05 18:43:04 jingsongchan su[3878]: - ??? root:oracle
9月 05 18:43:04 jingsongchan oracle-xe[3861]: Failed to start Oracle Net Listene
9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Control process exit
9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Failed with result '
9月 05 18:43:04 jingsongchan systemd[1]: Failed to start SYSV: This is a program
~
~
~
~
~
~
~
~
~
~
~
lines 1-16/16 (END)...skipping...
● oracle-xe.service - SYSV: This is a program that is responsible for taking car
   Loaded: loaded (/etc/init.d/oracle-xe; generated)
   Active: failed (Result: exit-code) since Thu 2019-09-05 18:43:04 CST; 22s ago
     Docs: man:systemd-sysv-generator(8)
  Process: 3861 ExecStart=/etc/init.d/oracle-xe start (code=exited, status=1/FAI

9月 05 18:43:04 jingsongchan su[3872]: FAILED su for oracle by root
9月 05 18:43:04 jingsongchan su[3872]: - ??? root:oracle
9月 05 18:43:04 jingsongchan oracle-xe[3861]: Starting Oracle Database 11g Expre
9月 05 18:43:04 jingsongchan su[3878]: No passwd entry for user 'oracle'
9月 05 18:43:04 jingsongchan su[3878]: FAILED su for oracle by root
9月 05 18:43:04 jingsongchan su[3878]: - ??? root:oracle
9月 05 18:43:04 jingsongchan oracle-xe[3861]: Failed to start Oracle Net Listene
9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Control process exit
9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Failed with result '
9月 05 18:43:04 jingsongchan systemd[1]: Failed to start SYSV: This is a program
~
~
~
~
~
~
~
~
~
~
~
~
~
lines 1-16/16 (END)...skipping...
● oracle-xe.service - SYSV: This is a program that is responsible for taking care 
   Loaded: loaded (/etc/init.d/oracle-xe; generated)
   Active: failed (Result: exit-code) since Thu 2019-09-05 18:43:04 CST; 22s ago
     Docs: man:systemd-sysv-generator(8)
  Process: 3861 ExecStart=/etc/init.d/oracle-xe start (code=exited, status=1/FAILU

9月 05 18:43:04 jingsongchan su[3872]: FAILED su for oracle by root
9月 05 18:43:04 jingsongchan su[3872]: - ??? root:oracle
9月 05 18:43:04 jingsongchan oracle-xe[3861]: Starting Oracle Database 11g Express
9月 05 18:43:04 jingsongchan su[3878]: No passwd entry for user 'oracle'
9月 05 18:43:04 jingsongchan su[3878]: FAILED su for oracle by root
9月 05 18:43:04 jingsongchan su[3878]: - ??? root:oracle
9月 05 18:43:04 jingsongchan oracle-xe[3861]: Failed to start Oracle Net Listener 
9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Control process exited
9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Failed with result 'ex
9月 05 18:43:04 jingsongchan systemd[1]: Failed to start SYSV: This is a program t
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
lines 1-16/16 (END)...skipping...
● oracle-xe.service - SYSV: This is a program that is responsible for taking care of
   Loaded: loaded (/etc/init.d/oracle-xe; generated)
   Active: failed (Result: exit-code) since Thu 2019-09-05 18:43:04 CST; 22s ago
     Docs: man:systemd-sysv-generator(8)
  Process: 3861 ExecStart=/etc/init.d/oracle-xe start (code=exited, status=1/FAILURE)

9月 05 18:43:04 jingsongchan su[3872]: FAILED su for oracle by root
9月 05 18:43:04 jingsongchan su[3872]: - ??? root:oracle
9月 05 18:43:04 jingsongchan oracle-xe[3861]: Starting Oracle Database 11g Express Edi
9月 05 18:43:04 jingsongchan su[3878]: No passwd entry for user 'oracle'
9月 05 18:43:04 jingsongchan su[3878]: FAILED su for oracle by root
9月 05 18:43:04 jingsongchan su[3878]: - ??? root:oracle
9月 05 18:43:04 jingsongchan oracle-xe[3861]: Failed to start Oracle Net Listener usin
9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Control process exited, co
9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Failed with result 'exit-c
9月 05 18:43:04 jingsongchan systemd[1]: Failed to start SYSV: This is a program that 
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
lines 1-16/16 (END)...skipping...
● oracle-xe.service - SYSV: This is a program that is responsible for taking care of
   Loaded: loaded (/etc/init.d/oracle-xe; generated)
   Active: failed (Result: exit-code) since Thu 2019-09-05 18:43:04 CST; 22s ago
     Docs: man:systemd-sysv-generator(8)
  Process: 3861 ExecStart=/etc/init.d/oracle-xe start (code=exited, status=1/FAILURE)

9月 05 18:43:04 jingsongchan su[3872]: FAILED su for oracle by root
9月 05 18:43:04 jingsongchan su[3872]: - ??? root:oracle
9月 05 18:43:04 jingsongchan oracle-xe[3861]: Starting Oracle Database 11g Express Edition
9月 05 18:43:04 jingsongchan su[3878]: No passwd entry for user 'oracle'
9月 05 18:43:04 jingsongchan su[3878]: FAILED su for oracle by root
9月 05 18:43:04 jingsongchan su[3878]: - ??? root:oracle
9月 05 18:43:04 jingsongchan oracle-xe[3861]: Failed to start Oracle Net Listener using /u
9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Control process exited, code=e
9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Failed with result 'exit-code'
9月 05 18:43:04 jingsongchan systemd[1]: Failed to start SYSV: This is a program that is r
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
lines 1-16/16 (END)...skipping...
● oracle-xe.service - SYSV: This is a program that is responsible for taking care of
   Loaded: loaded (/etc/init.d/oracle-xe; generated)
   Active: failed (Result: exit-code) since Thu 2019-09-05 18:43:04 CST; 22s ago
     Docs: man:systemd-sysv-generator(8)
  Process: 3861 ExecStart=/etc/init.d/oracle-xe start (code=exited, status=1/FAILURE)

9月 05 18:43:04 jingsongchan su[3872]: FAILED su for oracle by root
9月 05 18:43:04 jingsongchan su[3872]: - ??? root:oracle
9月 05 18:43:04 jingsongchan oracle-xe[3861]: Starting Oracle Database 11g Express Edition insta
9月 05 18:43:04 jingsongchan su[3878]: No passwd entry for user 'oracle'
9月 05 18:43:04 jingsongchan su[3878]: FAILED su for oracle by root
9月 05 18:43:04 jingsongchan su[3878]: - ??? root:oracle
9月 05 18:43:04 jingsongchan oracle-xe[3861]: Failed to start Oracle Net Listener using /u01/app
9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Control process exited, code=exited 
9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Failed with result 'exit-code'.
9月 05 18:43:04 jingsongchan systemd[1]: Failed to start SYSV: This is a program that is respons
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
lines 1-16/16 (END)...skipping...
● oracle-xe.service - SYSV: This is a program that is responsible for taking care of
   Loaded: loaded (/etc/init.d/oracle-xe; generated)
   Active: failed (Result: exit-code) since Thu 2019-09-05 18:43:04 CST; 22s ago
     Docs: man:systemd-sysv-generator(8)
  Process: 3861 ExecStart=/etc/init.d/oracle-xe start (code=exited, status=1/FAILURE)

9月 05 18:43:04 jingsongchan su[3872]: FAILED su for oracle by root
9月 05 18:43:04 jingsongchan su[3872]: - ??? root:oracle
9月 05 18:43:04 jingsongchan oracle-xe[3861]: Starting Oracle Database 11g Express Edition instance.
9月 05 18:43:04 jingsongchan su[3878]: No passwd entry for user 'oracle'
9月 05 18:43:04 jingsongchan su[3878]: FAILED su for oracle by root
9月 05 18:43:04 jingsongchan su[3878]: - ??? root:oracle
9月 05 18:43:04 jingsongchan oracle-xe[3861]: Failed to start Oracle Net Listener using /u01/app/orac
9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Control process exited, code=exited statu
9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Failed with result 'exit-code'.
9月 05 18:43:04 jingsongchan systemd[1]: Failed to start SYSV: This is a program that is responsible 
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
lines 1-16/16 (END)...skipping...
● oracle-xe.service - SYSV: This is a program that is responsible for taking care of
   Loaded: loaded (/etc/init.d/oracle-xe; generated)
   Active: failed (Result: exit-code) since Thu 2019-09-05 18:43:04 CST; 22s ago
     Docs: man:systemd-sysv-generator(8)
  Process: 3861 ExecStart=/etc/init.d/oracle-xe start (code=exited, status=1/FAILURE)

9月 05 18:43:04 jingsongchan su[3872]: FAILED su for oracle by root
9月 05 18:43:04 jingsongchan su[3872]: - ??? root:oracle
9月 05 18:43:04 jingsongchan oracle-xe[3861]: Starting Oracle Database 11g Express Edition instance.
9月 05 18:43:04 jingsongchan su[3878]: No passwd entry for user 'oracle'
9月 05 18:43:04 jingsongchan su[3878]: FAILED su for oracle by root
9月 05 18:43:04 jingsongchan su[3878]: - ??? root:oracle
9月 05 18:43:04 jingsongchan oracle-xe[3861]: Failed to start Oracle Net Listener using /u01/app/oracle/pro
9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Control process exited, code=exited status=1
9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Failed with result 'exit-code'.
9月 05 18:43:04 jingsongchan systemd[1]: Failed to start SYSV: This is a program that is responsible for ta
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
lines 1-16/16 (END)...skipping...
● oracle-xe.service - SYSV: This is a program that is responsible for taking care of
   Loaded: loaded (/etc/init.d/oracle-xe; generated)
   Active: failed (Result: exit-code) since Thu 2019-09-05 18:43:04 CST; 22s ago
     Docs: man:systemd-sysv-generator(8)
  Process: 3861 ExecStart=/etc/init.d/oracle-xe start (code=exited, status=1/FAILURE)

9月 05 18:43:04 jingsongchan su[3872]: FAILED su for oracle by root
9月 05 18:43:04 jingsongchan su[3872]: - ??? root:oracle
9月 05 18:43:04 jingsongchan oracle-xe[3861]: Starting Oracle Database 11g Express Edition instance.
9月 05 18:43:04 jingsongchan su[3878]: No passwd entry for user 'oracle'
9月 05 18:43:04 jingsongchan su[3878]: FAILED su for oracle by root
9月 05 18:43:04 jingsongchan su[3878]: - ??? root:oracle
9月 05 18:43:04 jingsongchan oracle-xe[3861]: Failed to start Oracle Net Listener using /u01/app/oracle/produc
9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Control process exited, code=exited status=1
9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Failed with result 'exit-code'.
9月 05 18:43:04 jingsongchan systemd[1]: Failed to start SYSV: This is a program that is responsible for takin
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
lines 1-16/16 (END)



















































● oracle-xe.service - SYSV: This is a program that is responsible for taking care of
   Loaded: loaded (/etc/init.d/oracle-xe; generated)
   Active: failed (Result: exit-code) since Thu 2019-09-05 18:43:04 CST; 22s ago
     Docs: man:systemd-sysv-generator(8)
  Process: 3861 ExecStart=/etc/init.d/oracle-xe start (code=exited, status=1/FAILURE)

9月 05 18:43:04 jingsongchan su[3872]: FAILED su for oracle by root
9月 05 18:43:04 jingsongchan su[3872]: - ??? root:oracle
9月 05 18:43:04 jingsongchan oracle-xe[3861]: Starting Oracle Database 11g Express Edition instance.
9月 05 18:43:04 jingsongchan su[3878]: No passwd entry for user 'oracle'
9月 05 18:43:04 jingsongchan su[3878]: FAILED su for oracle by root
9月 05 18:43:04 jingsongchan su[3878]: - ??? root:oracle
9月 05 18:43:04 jingsongchan oracle-xe[3861]: Failed to start Oracle Net Listener using /u01/app/oracle/product/
9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Control process exited, code=exited status=1
9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Failed with result 'exit-code'.
9月 05 18:43:04 jingsongchan systemd[1]: Failed to start SYSV: This is a program that is responsible for taking 
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
lines 1-16/16 (END)



















































● oracle-xe.service - SYSV: This is a program that is responsible for taking care of
   Loaded: loaded (/etc/init.d/oracle-xe; generated)
   Active: failed (Result: exit-code) since Thu 2019-09-05 18:43:04 CST; 22s ago
     Docs: man:systemd-sysv-generator(8)
  Process: 3861 ExecStart=/etc/init.d/oracle-xe start (code=exited, status=1/FAILURE)

9月 05 18:43:04 jingsongchan su[3872]: FAILED su for oracle by root
9月 05 18:43:04 jingsongchan su[3872]: - ??? root:oracle
9月 05 18:43:04 jingsongchan oracle-xe[3861]: Starting Oracle Database 11g Express Edition instance.
9月 05 18:43:04 jingsongchan su[3878]: No passwd entry for user 'oracle'
9月 05 18:43:04 jingsongchan su[3878]: FAILED su for oracle by root
9月 05 18:43:04 jingsongchan su[3878]: - ??? root:oracle
9月 05 18:43:04 jingsongchan oracle-xe[3861]: Failed to start Oracle Net Listener using /u01/app/oracle/product/1
9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Control process exited, code=exited status=1
9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Failed with result 'exit-code'.
9月 05 18:43:04 jingsongchan systemd[1]: Failed to start SYSV: This is a program that is responsible for taking c
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
lines 1-16/16 (END)



















































● oracle-xe.service - SYSV: This is a program that is responsible for taking care of
   Loaded: loaded (/etc/init.d/oracle-xe; generated)
   Active: failed (Result: exit-code) since Thu 2019-09-05 18:43:04 CST; 22s ago
     Docs: man:systemd-sysv-generator(8)
  Process: 3861 ExecStart=/etc/init.d/oracle-xe start (code=exited, status=1/FAILURE)

9月 05 18:43:04 jingsongchan su[3872]: FAILED su for oracle by root
9月 05 18:43:04 jingsongchan su[3872]: - ??? root:oracle
9月 05 18:43:04 jingsongchan oracle-xe[3861]: Starting Oracle Database 11g Express Edition instance.
9月 05 18:43:04 jingsongchan su[3878]: No passwd entry for user 'oracle'
9月 05 18:43:04 jingsongchan su[3878]: FAILED su for oracle by root
9月 05 18:43:04 jingsongchan su[3878]: - ??? root:oracle
9月 05 18:43:04 jingsongchan oracle-xe[3861]: Failed to start Oracle Net Listener using /u01/app/oracle/product/11
9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Control process exited, code=exited status=1
9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Failed with result 'exit-code'.
9月 05 18:43:04 jingsongchan systemd[1]: Failed to start SYSV: This is a program that is responsible for taking ca
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
lines 1-16/16 (END)


















































● oracle-xe.service - SYSV: This is a program that is responsible for taking care of
   Loaded: loaded (/etc/init.d/oracle-xe; generated)
   Active: failed (Result: exit-code) since Thu 2019-09-05 18:43:04 CST; 22s ago
     Docs: man:systemd-sysv-generator(8)
  Process: 3861 ExecStart=/etc/init.d/oracle-xe start (code=exited, status=1/FAILURE)

9月 05 18:43:04 jingsongchan su[3872]: FAILED su for oracle by root
9月 05 18:43:04 jingsongchan su[3872]: - ??? root:oracle
9月 05 18:43:04 jingsongchan oracle-xe[3861]: Starting Oracle Database 11g Express Edition instance.
9月 05 18:43:04 jingsongchan su[3878]: No passwd entry for user 'oracle'
9月 05 18:43:04 jingsongchan su[3878]: FAILED su for oracle by root
9月 05 18:43:04 jingsongchan su[3878]: - ??? root:oracle
9月 05 18:43:04 jingsongchan oracle-xe[3861]: Failed to start Oracle Net Listener using /u01/app/oracle/product/11.
9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Control process exited, code=exited status=1
9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Failed with result 'exit-code'.
9月 05 18:43:04 jingsongchan systemd[1]: Failed to start SYSV: This is a program that is responsible for taking car
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
lines 1-16/16 (END)


















































● oracle-xe.service - SYSV: This is a program that is responsible for taking care of
   Loaded: loaded (/etc/init.d/oracle-xe; generated)
   Active: failed (Result: exit-code) since Thu 2019-09-05 18:43:04 CST; 22s ago
     Docs: man:systemd-sysv-generator(8)
  Process: 3861 ExecStart=/etc/init.d/oracle-xe start (code=exited, status=1/FAILURE)

9月 05 18:43:04 jingsongchan su[3872]: FAILED su for oracle by root
9月 05 18:43:04 jingsongchan su[3872]: - ??? root:oracle
9月 05 18:43:04 jingsongchan oracle-xe[3861]: Starting Oracle Database 11g Express Edition instance.
9月 05 18:43:04 jingsongchan su[3878]: No passwd entry for user 'oracle'
9月 05 18:43:04 jingsongchan su[3878]: FAILED su for oracle by root
9月 05 18:43:04 jingsongchan su[3878]: - ??? root:oracle
9月 05 18:43:04 jingsongchan oracle-xe[3861]: Failed to start Oracle Net Listener using /u01/app/oracle/product/11.2
9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Control process exited, code=exited status=1
9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Failed with result 'exit-code'.
9月 05 18:43:04 jingsongchan systemd[1]: Failed to start SYSV: This is a program that is responsible for taking care
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
lines 1-16/16 (END)


















































● oracle-xe.service - SYSV: This is a program that is responsible for taking care of
   Loaded: loaded (/etc/init.d/oracle-xe; generated)
   Active: failed (Result: exit-code) since Thu 2019-09-05 18:43:04 CST; 22s ago
     Docs: man:systemd-sysv-generator(8)
  Process: 3861 ExecStart=/etc/init.d/oracle-xe start (code=exited, status=1/FAILURE)

9月 05 18:43:04 jingsongchan su[3872]: FAILED su for oracle by root
9月 05 18:43:04 jingsongchan su[3872]: - ??? root:oracle
9月 05 18:43:04 jingsongchan oracle-xe[3861]: Starting Oracle Database 11g Express Edition instance.
9月 05 18:43:04 jingsongchan su[3878]: No passwd entry for user 'oracle'
9月 05 18:43:04 jingsongchan su[3878]: FAILED su for oracle by root
9月 05 18:43:04 jingsongchan su[3878]: - ??? root:oracle
9月 05 18:43:04 jingsongchan oracle-xe[3861]: Failed to start Oracle Net Listener using /u01/app/oracle/product/11.2.
9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Control process exited, code=exited status=1
9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Failed with result 'exit-code'.
9月 05 18:43:04 jingsongchan systemd[1]: Failed to start SYSV: This is a program that is responsible for taking care 
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
lines 1-16/16 (END)


















































● oracle-xe.service - SYSV: This is a program that is responsible for taking care of
   Loaded: loaded (/etc/init.d/oracle-xe; generated)
   Active: failed (Result: exit-code) since Thu 2019-09-05 18:43:04 CST; 22s ago
     Docs: man:systemd-sysv-generator(8)
  Process: 3861 ExecStart=/etc/init.d/oracle-xe start (code=exited, status=1/FAILURE)

9月 05 18:43:04 jingsongchan su[3872]: FAILED su for oracle by root
9月 05 18:43:04 jingsongchan su[3872]: - ??? root:oracle
9月 05 18:43:04 jingsongchan oracle-xe[3861]: Starting Oracle Database 11g Express Edition instance.
9月 05 18:43:04 jingsongchan su[3878]: No passwd entry for user 'oracle'
9月 05 18:43:04 jingsongchan su[3878]: FAILED su for oracle by root
9月 05 18:43:04 jingsongchan su[3878]: - ??? root:oracle
9月 05 18:43:04 jingsongchan oracle-xe[3861]: Failed to start Oracle Net Listener using /u01/app/oracle/product/11.2.0
9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Control process exited, code=exited status=1
9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Failed with result 'exit-code'.
9月 05 18:43:04 jingsongchan systemd[1]: Failed to start SYSV: This is a program that is responsible for taking care o
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
lines 1-16/16 (END)

















































● oracle-xe.service - SYSV: This is a program that is responsible for taking care of
   Loaded: loaded (/etc/init.d/oracle-xe; generated)
   Active: failed (Result: exit-code) since Thu 2019-09-05 18:43:04 CST; 22s ago
     Docs: man:systemd-sysv-generator(8)
  Process: 3861 ExecStart=/etc/init.d/oracle-xe start (code=exited, status=1/FAILURE)

9月 05 18:43:04 jingsongchan su[3872]: FAILED su for oracle by root
9月 05 18:43:04 jingsongchan su[3872]: - ??? root:oracle
9月 05 18:43:04 jingsongchan oracle-xe[3861]: Starting Oracle Database 11g Express Edition instance.
9月 05 18:43:04 jingsongchan su[3878]: No passwd entry for user 'oracle'
9月 05 18:43:04 jingsongchan su[3878]: FAILED su for oracle by root
9月 05 18:43:04 jingsongchan su[3878]: - ??? root:oracle
9月 05 18:43:04 jingsongchan oracle-xe[3861]: Failed to start Oracle Net Listener using /u01/app/oracle/product/11.2.0
9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Control process exited, code=exited status=1
9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Failed with result 'exit-code'.
9月 05 18:43:04 jingsongchan systemd[1]: Failed to start SYSV: This is a program that is responsible for taking care o
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
lines 1-16/16 (END)
















































● oracle-xe.service - SYSV: This is a program that is responsible for taking care of
   Loaded: loaded (/etc/init.d/oracle-xe; generated)
   Active: failed (Result: exit-code) since Thu 2019-09-05 18:43:04 CST; 22s ago
     Docs: man:systemd-sysv-generator(8)
  Process: 3861 ExecStart=/etc/init.d/oracle-xe start (code=exited, status=1/FAILURE)

9月 05 18:43:04 jingsongchan su[3872]: FAILED su for oracle by root
9月 05 18:43:04 jingsongchan su[3872]: - ??? root:oracle
9月 05 18:43:04 jingsongchan oracle-xe[3861]: Starting Oracle Database 11g Express Edition instance.
9月 05 18:43:04 jingsongchan su[3878]: No passwd entry for user 'oracle'
9月 05 18:43:04 jingsongchan su[3878]: FAILED su for oracle by root
9月 05 18:43:04 jingsongchan su[3878]: - ??? root:oracle
9月 05 18:43:04 jingsongchan oracle-xe[3861]: Failed to start Oracle Net Listener using /u01/app/oracle/product/11.2.0/x
9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Control process exited, code=exited status=1
9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Failed with result 'exit-code'.
9月 05 18:43:04 jingsongchan systemd[1]: Failed to start SYSV: This is a program that is responsible for taking care of.
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
lines 1-16/16 (END)















































● oracle-xe.service - SYSV: This is a program that is responsible for taking care of
   Loaded: loaded (/etc/init.d/oracle-xe; generated)
   Active: failed (Result: exit-code) since Thu 2019-09-05 18:43:04 CST; 22s ago
     Docs: man:systemd-sysv-generator(8)
  Process: 3861 ExecStart=/etc/init.d/oracle-xe start (code=exited, status=1/FAILURE)

9月 05 18:43:04 jingsongchan su[3872]: FAILED su for oracle by root
9月 05 18:43:04 jingsongchan su[3872]: - ??? root:oracle
9月 05 18:43:04 jingsongchan oracle-xe[3861]: Starting Oracle Database 11g Express Edition instance.
9月 05 18:43:04 jingsongchan su[3878]: No passwd entry for user 'oracle'
9月 05 18:43:04 jingsongchan su[3878]: FAILED su for oracle by root
9月 05 18:43:04 jingsongchan su[3878]: - ??? root:oracle
9月 05 18:43:04 jingsongchan oracle-xe[3861]: Failed to start Oracle Net Listener using /u01/app/oracle/product/11.2.0/xe
9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Control process exited, code=exited status=1
9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Failed with result 'exit-code'.
9月 05 18:43:04 jingsongchan systemd[1]: Failed to start SYSV: This is a program that is responsible for taking care of.
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
lines 1-16/16 (END)














































● oracle-xe.service - SYSV: This is a program that is responsible for taking care of
   Loaded: loaded (/etc/init.d/oracle-xe; generated)
   Active: failed (Result: exit-code) since Thu 2019-09-05 18:43:04 CST; 22s ago
     Docs: man:systemd-sysv-generator(8)
  Process: 3861 ExecStart=/etc/init.d/oracle-xe start (code=exited, status=1/FAILURE)

9月 05 18:43:04 jingsongchan su[3872]: FAILED su for oracle by root
9月 05 18:43:04 jingsongchan su[3872]: - ??? root:oracle
9月 05 18:43:04 jingsongchan oracle-xe[3861]: Starting Oracle Database 11g Express Edition instance.
9月 05 18:43:04 jingsongchan su[3878]: No passwd entry for user 'oracle'
9月 05 18:43:04 jingsongchan su[3878]: FAILED su for oracle by root
9月 05 18:43:04 jingsongchan su[3878]: - ??? root:oracle
9月 05 18:43:04 jingsongchan oracle-xe[3861]: Failed to start Oracle Net Listener using /u01/app/oracle/product/11.2.0/xe/b
9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Control process exited, code=exited status=1
9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Failed with result 'exit-code'.
9月 05 18:43:04 jingsongchan systemd[1]: Failed to start SYSV: This is a program that is responsible for taking care of.
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
lines 1-16/16 (END)













































● oracle-xe.service - SYSV: This is a program that is responsible for taking care of
   Loaded: loaded (/etc/init.d/oracle-xe; generated)
   Active: failed (Result: exit-code) since Thu 2019-09-05 18:43:04 CST; 22s ago
     Docs: man:systemd-sysv-generator(8)
  Process: 3861 ExecStart=/etc/init.d/oracle-xe start (code=exited, status=1/FAILURE)

9月 05 18:43:04 jingsongchan su[3872]: FAILED su for oracle by root
9月 05 18:43:04 jingsongchan su[3872]: - ??? root:oracle
9月 05 18:43:04 jingsongchan oracle-xe[3861]: Starting Oracle Database 11g Express Edition instance.
9月 05 18:43:04 jingsongchan su[3878]: No passwd entry for user 'oracle'
9月 05 18:43:04 jingsongchan su[3878]: FAILED su for oracle by root
9月 05 18:43:04 jingsongchan su[3878]: - ??? root:oracle
9月 05 18:43:04 jingsongchan oracle-xe[3861]: Failed to start Oracle Net Listener using /u01/app/oracle/product/11.2.0/xe/bin
9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Control process exited, code=exited status=1
9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Failed with result 'exit-code'.
9月 05 18:43:04 jingsongchan systemd[1]: Failed to start SYSV: This is a program that is responsible for taking care of.
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
lines 1-16/16 (END)












































● oracle-xe.service - SYSV: This is a program that is responsible for taking care of
   Loaded: loaded (/etc/init.d/oracle-xe; generated)
   Active: failed (Result: exit-code) since Thu 2019-09-05 18:43:04 CST; 22s ago
     Docs: man:systemd-sysv-generator(8)
  Process: 3861 ExecStart=/etc/init.d/oracle-xe start (code=exited, status=1/FAILURE)

9月 05 18:43:04 jingsongchan su[3872]: FAILED su for oracle by root
9月 05 18:43:04 jingsongchan su[3872]: - ??? root:oracle
9月 05 18:43:04 jingsongchan oracle-xe[3861]: Starting Oracle Database 11g Express Edition instance.
9月 05 18:43:04 jingsongchan su[3878]: No passwd entry for user 'oracle'
9月 05 18:43:04 jingsongchan su[3878]: FAILED su for oracle by root
9月 05 18:43:04 jingsongchan su[3878]: - ??? root:oracle
9月 05 18:43:04 jingsongchan oracle-xe[3861]: Failed to start Oracle Net Listener using /u01/app/oracle/product/11.2.0/xe/bin/
9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Control process exited, code=exited status=1
9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Failed with result 'exit-code'.
9月 05 18:43:04 jingsongchan systemd[1]: Failed to start SYSV: This is a program that is responsible for taking care of.
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
lines 1-16/16 (END)












































● oracle-xe.service - SYSV: This is a program that is responsible for taking care of
   Loaded: loaded (/etc/init.d/oracle-xe; generated)
   Active: failed (Result: exit-code) since Thu 2019-09-05 18:43:04 CST; 22s ago
     Docs: man:systemd-sysv-generator(8)
  Process: 3861 ExecStart=/etc/init.d/oracle-xe start (code=exited, status=1/FAILURE)

9月 05 18:43:04 jingsongchan su[3872]: FAILED su for oracle by root
9月 05 18:43:04 jingsongchan su[3872]: - ??? root:oracle
9月 05 18:43:04 jingsongchan oracle-xe[3861]: Starting Oracle Database 11g Express Edition instance.
9月 05 18:43:04 jingsongchan su[3878]: No passwd entry for user 'oracle'
9月 05 18:43:04 jingsongchan su[3878]: FAILED su for oracle by root
9月 05 18:43:04 jingsongchan su[3878]: - ??? root:oracle
9月 05 18:43:04 jingsongchan oracle-xe[3861]: Failed to start Oracle Net Listener using /u01/app/oracle/product/11.2.0/xe/bin/t
9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Control process exited, code=exited status=1
9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Failed with result 'exit-code'.
9月 05 18:43:04 jingsongchan systemd[1]: Failed to start SYSV: This is a program that is responsible for taking care of.
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
lines 1-16/16 (END)











































● oracle-xe.service - SYSV: This is a program that is responsible for taking care of
   Loaded: loaded (/etc/init.d/oracle-xe; generated)
   Active: failed (Result: exit-code) since Thu 2019-09-05 18:43:04 CST; 22s ago
     Docs: man:systemd-sysv-generator(8)
  Process: 3861 ExecStart=/etc/init.d/oracle-xe start (code=exited, status=1/FAILURE)

9月 05 18:43:04 jingsongchan su[3872]: FAILED su for oracle by root
9月 05 18:43:04 jingsongchan su[3872]: - ??? root:oracle
9月 05 18:43:04 jingsongchan oracle-xe[3861]: Starting Oracle Database 11g Express Edition instance.
9月 05 18:43:04 jingsongchan su[3878]: No passwd entry for user 'oracle'
9月 05 18:43:04 jingsongchan su[3878]: FAILED su for oracle by root
9月 05 18:43:04 jingsongchan su[3878]: - ??? root:oracle
9月 05 18:43:04 jingsongchan oracle-xe[3861]: Failed to start Oracle Net Listener using /u01/app/oracle/product/11.2.0/xe/bin/tn
9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Control process exited, code=exited status=1
9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Failed with result 'exit-code'.
9月 05 18:43:04 jingsongchan systemd[1]: Failed to start SYSV: This is a program that is responsible for taking care of.
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
lines 1-16/16 (END)











































● oracle-xe.service - SYSV: This is a program that is responsible for taking care of
   Loaded: loaded (/etc/init.d/oracle-xe; generated)
   Active: failed (Result: exit-code) since Thu 2019-09-05 18:43:04 CST; 22s ago
     Docs: man:systemd-sysv-generator(8)
  Process: 3861 ExecStart=/etc/init.d/oracle-xe start (code=exited, status=1/FAILURE)

9月 05 18:43:04 jingsongchan su[3872]: FAILED su for oracle by root
9月 05 18:43:04 jingsongchan su[3872]: - ??? root:oracle
9月 05 18:43:04 jingsongchan oracle-xe[3861]: Starting Oracle Database 11g Express Edition instance.
9月 05 18:43:04 jingsongchan su[3878]: No passwd entry for user 'oracle'
9月 05 18:43:04 jingsongchan su[3878]: FAILED su for oracle by root
9月 05 18:43:04 jingsongchan su[3878]: - ??? root:oracle
9月 05 18:43:04 jingsongchan oracle-xe[3861]: Failed to start Oracle Net Listener using /u01/app/oracle/product/11.2.0/xe/bin/tns
9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Control process exited, code=exited status=1
9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Failed with result 'exit-code'.
9月 05 18:43:04 jingsongchan systemd[1]: Failed to start SYSV: This is a program that is responsible for taking care of.
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
lines 1-16/16 (END)











































● oracle-xe.service - SYSV: This is a program that is responsible for taking care of
   Loaded: loaded (/etc/init.d/oracle-xe; generated)
   Active: failed (Result: exit-code) since Thu 2019-09-05 18:43:04 CST; 22s ago
     Docs: man:systemd-sysv-generator(8)
  Process: 3861 ExecStart=/etc/init.d/oracle-xe start (code=exited, status=1/FAILURE)

9月 05 18:43:04 jingsongchan su[3872]: FAILED su for oracle by root
9月 05 18:43:04 jingsongchan su[3872]: - ??? root:oracle
9月 05 18:43:04 jingsongchan oracle-xe[3861]: Starting Oracle Database 11g Express Edition instance.
9月 05 18:43:04 jingsongchan su[3878]: No passwd entry for user 'oracle'
9月 05 18:43:04 jingsongchan su[3878]: FAILED su for oracle by root
9月 05 18:43:04 jingsongchan su[3878]: - ??? root:oracle
9月 05 18:43:04 jingsongchan oracle-xe[3861]: Failed to start Oracle Net Listener using /u01/app/oracle/product/11.2.0/xe/bin/tnsl
9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Control process exited, code=exited status=1
9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Failed with result 'exit-code'.
9月 05 18:43:04 jingsongchan systemd[1]: Failed to start SYSV: This is a program that is responsible for taking care of.
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
lines 1-16/16 (END)












































● oracle-xe.service - SYSV: This is a program that is responsible for taking care of
   Loaded: loaded (/etc/init.d/oracle-xe; generated)
   Active: failed (Result: exit-code) since Thu 2019-09-05 18:43:04 CST; 22s ago
     Docs: man:systemd-sysv-generator(8)
  Process: 3861 ExecStart=/etc/init.d/oracle-xe start (code=exited, status=1/FAILURE)

9月 05 18:43:04 jingsongchan su[3872]: FAILED su for oracle by root
9月 05 18:43:04 jingsongchan su[3872]: - ??? root:oracle
9月 05 18:43:04 jingsongchan oracle-xe[3861]: Starting Oracle Database 11g Express Edition instance.
9月 05 18:43:04 jingsongchan su[3878]: No passwd entry for user 'oracle'
9月 05 18:43:04 jingsongchan su[3878]: FAILED su for oracle by root
9月 05 18:43:04 jingsongchan su[3878]: - ??? root:oracle
9月 05 18:43:04 jingsongchan oracle-xe[3861]: Failed to start Oracle Net Listener using /u01/app/oracle/product/11.2.0/xe/bin/tnsls
9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Control process exited, code=exited status=1
9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Failed with result 'exit-code'.
9月 05 18:43:04 jingsongchan systemd[1]: Failed to start SYSV: This is a program that is responsible for taking care of.
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
lines 1-16/16 (END)












































● oracle-xe.service - SYSV: This is a program that is responsible for taking care of
   Loaded: loaded (/etc/init.d/oracle-xe; generated)
   Active: failed (Result: exit-code) since Thu 2019-09-05 18:43:04 CST; 22s ago
     Docs: man:systemd-sysv-generator(8)
  Process: 3861 ExecStart=/etc/init.d/oracle-xe start (code=exited, status=1/FAILURE)

9月 05 18:43:04 jingsongchan su[3872]: FAILED su for oracle by root
9月 05 18:43:04 jingsongchan su[3872]: - ??? root:oracle
9月 05 18:43:04 jingsongchan oracle-xe[3861]: Starting Oracle Database 11g Express Edition instance.
9月 05 18:43:04 jingsongchan su[3878]: No passwd entry for user 'oracle'
9月 05 18:43:04 jingsongchan su[3878]: FAILED su for oracle by root
9月 05 18:43:04 jingsongchan su[3878]: - ??? root:oracle
9月 05 18:43:04 jingsongchan oracle-xe[3861]: Failed to start Oracle Net Listener using /u01/app/oracle/product/11.2.0/xe/bin/tnslsn
9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Control process exited, code=exited status=1
9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Failed with result 'exit-code'.
9月 05 18:43:04 jingsongchan systemd[1]: Failed to start SYSV: This is a program that is responsible for taking care of.
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
lines 1-16/16 (END)












































● oracle-xe.service - SYSV: This is a program that is responsible for taking care of
   Loaded: loaded (/etc/init.d/oracle-xe; generated)
   Active: failed (Result: exit-code) since Thu 2019-09-05 18:43:04 CST; 22s ago
     Docs: man:systemd-sysv-generator(8)
  Process: 3861 ExecStart=/etc/init.d/oracle-xe start (code=exited, status=1/FAILURE)

9月 05 18:43:04 jingsongchan su[3872]: FAILED su for oracle by root
9月 05 18:43:04 jingsongchan su[3872]: - ??? root:oracle
9月 05 18:43:04 jingsongchan oracle-xe[3861]: Starting Oracle Database 11g Express Edition instance.
9月 05 18:43:04 jingsongchan su[3878]: No passwd entry for user 'oracle'
9月 05 18:43:04 jingsongchan su[3878]: FAILED su for oracle by root
9月 05 18:43:04 jingsongchan su[3878]: - ??? root:oracle
9月 05 18:43:04 jingsongchan oracle-xe[3861]: Failed to start Oracle Net Listener using /u01/app/oracle/product/11.2.0/xe/bin/tnslsnr
9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Control process exited, code=exited status=1
9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Failed with result 'exit-code'.
9月 05 18:43:04 jingsongchan systemd[1]: Failed to start SYSV: This is a program that is responsible for taking care of.
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
lines 1-16/16 (END)












































● oracle-xe.service - SYSV: This is a program that is responsible for taking care of
   Loaded: loaded (/etc/init.d/oracle-xe; generated)
   Active: failed (Result: exit-code) since Thu 2019-09-05 18:43:04 CST; 22s ago
     Docs: man:systemd-sysv-generator(8)
  Process: 3861 ExecStart=/etc/init.d/oracle-xe start (code=exited, status=1/FAILURE)

9月 05 18:43:04 jingsongchan su[3872]: FAILED su for oracle by root
9月 05 18:43:04 jingsongchan su[3872]: - ??? root:oracle
9月 05 18:43:04 jingsongchan oracle-xe[3861]: Starting Oracle Database 11g Express Edition instance.
9月 05 18:43:04 jingsongchan su[3878]: No passwd entry for user 'oracle'
9月 05 18:43:04 jingsongchan su[3878]: FAILED su for oracle by root
9月 05 18:43:04 jingsongchan su[3878]: - ??? root:oracle
9月 05 18:43:04 jingsongchan oracle-xe[3861]: Failed to start Oracle Net Listener using /u01/app/oracle/product/11.2.0/xe/bin/tnslsnr 
9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Control process exited, code=exited status=1
9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Failed with result 'exit-code'.
9月 05 18:43:04 jingsongchan systemd[1]: Failed to start SYSV: This is a program that is responsible for taking care of.
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
lines 1-16/16 (END)












































● oracle-xe.service - SYSV: This is a program that is responsible for taking care of
   Loaded: loaded (/etc/init.d/oracle-xe; generated)
   Active: failed (Result: exit-code) since Thu 2019-09-05 18:43:04 CST; 22s ago
     Docs: man:systemd-sysv-generator(8)
  Process: 3861 ExecStart=/etc/init.d/oracle-xe start (code=exited, status=1/FAILURE)

9月 05 18:43:04 jingsongchan su[3872]: FAILED su for oracle by root
9月 05 18:43:04 jingsongchan su[3872]: - ??? root:oracle
9月 05 18:43:04 jingsongchan oracle-xe[3861]: Starting Oracle Database 11g Express Edition instance.
9月 05 18:43:04 jingsongchan su[3878]: No passwd entry for user 'oracle'
9月 05 18:43:04 jingsongchan su[3878]: FAILED su for oracle by root
9月 05 18:43:04 jingsongchan su[3878]: - ??? root:oracle
9月 05 18:43:04 jingsongchan oracle-xe[3861]: Failed to start Oracle Net Listener using /u01/app/oracle/product/11.2.0/xe/bin/tnslsnr a
9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Control process exited, code=exited status=1
9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Failed with result 'exit-code'.
9月 05 18:43:04 jingsongchan systemd[1]: Failed to start SYSV: This is a program that is responsible for taking care of.
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
lines 1-16/16 (END)












































● oracle-xe.service - SYSV: This is a program that is responsible for taking care of
   Loaded: loaded (/etc/init.d/oracle-xe; generated)
   Active: failed (Result: exit-code) since Thu 2019-09-05 18:43:04 CST; 22s ago
     Docs: man:systemd-sysv-generator(8)
  Process: 3861 ExecStart=/etc/init.d/oracle-xe start (code=exited, status=1/FAILURE)

9月 05 18:43:04 jingsongchan su[3872]: FAILED su for oracle by root
9月 05 18:43:04 jingsongchan su[3872]: - ??? root:oracle
9月 05 18:43:04 jingsongchan oracle-xe[3861]: Starting Oracle Database 11g Express Edition instance.
9月 05 18:43:04 jingsongchan su[3878]: No passwd entry for user 'oracle'
9月 05 18:43:04 jingsongchan su[3878]: FAILED su for oracle by root
9月 05 18:43:04 jingsongchan su[3878]: - ??? root:oracle
9月 05 18:43:04 jingsongchan oracle-xe[3861]: Failed to start Oracle Net Listener using /u01/app/oracle/product/11.2.0/xe/bin/tnslsnr and
9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Control process exited, code=exited status=1
9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Failed with result 'exit-code'.
9月 05 18:43:04 jingsongchan systemd[1]: Failed to start SYSV: This is a program that is responsible for taking care of.
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
lines 1-16/16 (END)












































● oracle-xe.service - SYSV: This is a program that is responsible for taking care of
   Loaded: loaded (/etc/init.d/oracle-xe; generated)
   Active: failed (Result: exit-code) since Thu 2019-09-05 18:43:04 CST; 22s ago
     Docs: man:systemd-sysv-generator(8)
  Process: 3861 ExecStart=/etc/init.d/oracle-xe start (code=exited, status=1/FAILURE)

9月 05 18:43:04 jingsongchan su[3872]: FAILED su for oracle by root
9月 05 18:43:04 jingsongchan su[3872]: - ??? root:oracle
9月 05 18:43:04 jingsongchan oracle-xe[3861]: Starting Oracle Database 11g Express Edition instance.
9月 05 18:43:04 jingsongchan su[3878]: No passwd entry for user 'oracle'
9月 05 18:43:04 jingsongchan su[3878]: FAILED su for oracle by root
9月 05 18:43:04 jingsongchan su[3878]: - ??? root:oracle
9月 05 18:43:04 jingsongchan oracle-xe[3861]: Failed to start Oracle Net Listener using /u01/app/oracle/product/11.2.0/xe/bin/tnslsnr and Or
9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Control process exited, code=exited status=1
9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Failed with result 'exit-code'.
9月 05 18:43:04 jingsongchan systemd[1]: Failed to start SYSV: This is a program that is responsible for taking care of.
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
lines 1-16/16 (END)












































● oracle-xe.service - SYSV: This is a program that is responsible for taking care of
   Loaded: loaded (/etc/init.d/oracle-xe; generated)
   Active: failed (Result: exit-code) since Thu 2019-09-05 18:43:04 CST; 22s ago
     Docs: man:systemd-sysv-generator(8)
  Process: 3861 ExecStart=/etc/init.d/oracle-xe start (code=exited, status=1/FAILURE)

9月 05 18:43:04 jingsongchan su[3872]: FAILED su for oracle by root
9月 05 18:43:04 jingsongchan su[3872]: - ??? root:oracle
9月 05 18:43:04 jingsongchan oracle-xe[3861]: Starting Oracle Database 11g Express Edition instance.
9月 05 18:43:04 jingsongchan su[3878]: No passwd entry for user 'oracle'
9月 05 18:43:04 jingsongchan su[3878]: FAILED su for oracle by root
9月 05 18:43:04 jingsongchan su[3878]: - ??? root:oracle
9月 05 18:43:04 jingsongchan oracle-xe[3861]: Failed to start Oracle Net Listener using /u01/app/oracle/product/11.2.0/xe/bin/tnslsnr and Orac
9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Control process exited, code=exited status=1
9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Failed with result 'exit-code'.
9月 05 18:43:04 jingsongchan systemd[1]: Failed to start SYSV: This is a program that is responsible for taking care of.
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
lines 1-16/16 (END)











































● oracle-xe.service - SYSV: This is a program that is responsible for taking care of
   Loaded: loaded (/etc/init.d/oracle-xe; generated)
   Active: failed (Result: exit-code) since Thu 2019-09-05 18:43:04 CST; 22s ago
     Docs: man:systemd-sysv-generator(8)
  Process: 3861 ExecStart=/etc/init.d/oracle-xe start (code=exited, status=1/FAILURE)

9月 05 18:43:04 jingsongchan su[3872]: FAILED su for oracle by root
9月 05 18:43:04 jingsongchan su[3872]: - ??? root:oracle
9月 05 18:43:04 jingsongchan oracle-xe[3861]: Starting Oracle Database 11g Express Edition instance.
9月 05 18:43:04 jingsongchan su[3878]: No passwd entry for user 'oracle'
9月 05 18:43:04 jingsongchan su[3878]: FAILED su for oracle by root
9月 05 18:43:04 jingsongchan su[3878]: - ??? root:oracle
9月 05 18:43:04 jingsongchan oracle-xe[3861]: Failed to start Oracle Net Listener using /u01/app/oracle/product/11.2.0/xe/bin/tnslsnr and Oracle
9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Control process exited, code=exited status=1
9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Failed with result 'exit-code'.
9月 05 18:43:04 jingsongchan systemd[1]: Failed to start SYSV: This is a program that is responsible for taking care of.
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
lines 1-16/16 (END)










































● oracle-xe.service - SYSV: This is a program that is responsible for taking care of
   Loaded: loaded (/etc/init.d/oracle-xe; generated)
   Active: failed (Result: exit-code) since Thu 2019-09-05 18:43:04 CST; 22s ago
     Docs: man:systemd-sysv-generator(8)
  Process: 3861 ExecStart=/etc/init.d/oracle-xe start (code=exited, status=1/FAILURE)

9月 05 18:43:04 jingsongchan su[3872]: FAILED su for oracle by root
9月 05 18:43:04 jingsongchan su[3872]: - ??? root:oracle
9月 05 18:43:04 jingsongchan oracle-xe[3861]: Starting Oracle Database 11g Express Edition instance.
9月 05 18:43:04 jingsongchan su[3878]: No passwd entry for user 'oracle'
9月 05 18:43:04 jingsongchan su[3878]: FAILED su for oracle by root
9月 05 18:43:04 jingsongchan su[3878]: - ??? root:oracle
9月 05 18:43:04 jingsongchan oracle-xe[3861]: Failed to start Oracle Net Listener using /u01/app/oracle/product/11.2.0/xe/bin/tnslsnr and Oracle 
9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Control process exited, code=exited status=1
9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Failed with result 'exit-code'.
9月 05 18:43:04 jingsongchan systemd[1]: Failed to start SYSV: This is a program that is responsible for taking care of.
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
lines 1-16/16 (END)










































● oracle-xe.service - SYSV: This is a program that is responsible for taking care of
   Loaded: loaded (/etc/init.d/oracle-xe; generated)
   Active: failed (Result: exit-code) since Thu 2019-09-05 18:43:04 CST; 22s ago
     Docs: man:systemd-sysv-generator(8)
  Process: 3861 ExecStart=/etc/init.d/oracle-xe start (code=exited, status=1/FAILURE)

9月 05 18:43:04 jingsongchan su[3872]: FAILED su for oracle by root
9月 05 18:43:04 jingsongchan su[3872]: - ??? root:oracle
9月 05 18:43:04 jingsongchan oracle-xe[3861]: Starting Oracle Database 11g Express Edition instance.
9月 05 18:43:04 jingsongchan su[3878]: No passwd entry for user 'oracle'
9月 05 18:43:04 jingsongchan su[3878]: FAILED su for oracle by root
9月 05 18:43:04 jingsongchan su[3878]: - ??? root:oracle
9月 05 18:43:04 jingsongchan oracle-xe[3861]: Failed to start Oracle Net Listener using /u01/app/oracle/product/11.2.0/xe/bin/tnslsnr and Oracle E
9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Control process exited, code=exited status=1
9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Failed with result 'exit-code'.
9月 05 18:43:04 jingsongchan systemd[1]: Failed to start SYSV: This is a program that is responsible for taking care of.
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
lines 1-16/16 (END)









































● oracle-xe.service - SYSV: This is a program that is responsible for taking care of
   Loaded: loaded (/etc/init.d/oracle-xe; generated)
   Active: failed (Result: exit-code) since Thu 2019-09-05 18:43:04 CST; 22s ago
     Docs: man:systemd-sysv-generator(8)
  Process: 3861 ExecStart=/etc/init.d/oracle-xe start (code=exited, status=1/FAILURE)

9月 05 18:43:04 jingsongchan su[3872]: FAILED su for oracle by root
9月 05 18:43:04 jingsongchan su[3872]: - ??? root:oracle
9月 05 18:43:04 jingsongchan oracle-xe[3861]: Starting Oracle Database 11g Express Edition instance.
9月 05 18:43:04 jingsongchan su[3878]: No passwd entry for user 'oracle'
9月 05 18:43:04 jingsongchan su[3878]: FAILED su for oracle by root
9月 05 18:43:04 jingsongchan su[3878]: - ??? root:oracle
9月 05 18:43:04 jingsongchan oracle-xe[3861]: Failed to start Oracle Net Listener using /u01/app/oracle/product/11.2.0/xe/bin/tnslsnr and Oracle Ex
9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Control process exited, code=exited status=1
9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Failed with result 'exit-code'.
9月 05 18:43:04 jingsongchan systemd[1]: Failed to start SYSV: This is a program that is responsible for taking care of.
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
lines 1-16/16 (END)








































● oracle-xe.service - SYSV: This is a program that is responsible for taking care of
   Loaded: loaded (/etc/init.d/oracle-xe; generated)
   Active: failed (Result: exit-code) since Thu 2019-09-05 18:43:04 CST; 22s ago
     Docs: man:systemd-sysv-generator(8)
  Process: 3861 ExecStart=/etc/init.d/oracle-xe start (code=exited, status=1/FAILURE)

9月 05 18:43:04 jingsongchan su[3872]: FAILED su for oracle by root
9月 05 18:43:04 jingsongchan su[3872]: - ??? root:oracle
9月 05 18:43:04 jingsongchan oracle-xe[3861]: Starting Oracle Database 11g Express Edition instance.
9月 05 18:43:04 jingsongchan su[3878]: No passwd entry for user 'oracle'
9月 05 18:43:04 jingsongchan su[3878]: FAILED su for oracle by root
9月 05 18:43:04 jingsongchan su[3878]: - ??? root:oracle
9月 05 18:43:04 jingsongchan oracle-xe[3861]: Failed to start Oracle Net Listener using /u01/app/oracle/product/11.2.0/xe/bin/tnslsnr and Oracle Exp
9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Control process exited, code=exited status=1
9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Failed with result 'exit-code'.
9月 05 18:43:04 jingsongchan systemd[1]: Failed to start SYSV: This is a program that is responsible for taking care of.
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
lines 1-16/16 (END)







































● oracle-xe.service - SYSV: This is a program that is responsible for taking care of
   Loaded: loaded (/etc/init.d/oracle-xe; generated)
   Active: failed (Result: exit-code) since Thu 2019-09-05 18:43:04 CST; 22s ago
     Docs: man:systemd-sysv-generator(8)
  Process: 3861 ExecStart=/etc/init.d/oracle-xe start (code=exited, status=1/FAILURE)

9月 05 18:43:04 jingsongchan su[3872]: FAILED su for oracle by root
9月 05 18:43:04 jingsongchan su[3872]: - ??? root:oracle
9月 05 18:43:04 jingsongchan oracle-xe[3861]: Starting Oracle Database 11g Express Edition instance.
9月 05 18:43:04 jingsongchan su[3878]: No passwd entry for user 'oracle'
9月 05 18:43:04 jingsongchan su[3878]: FAILED su for oracle by root
9月 05 18:43:04 jingsongchan su[3878]: - ??? root:oracle
9月 05 18:43:04 jingsongchan oracle-xe[3861]: Failed to start Oracle Net Listener using /u01/app/oracle/product/11.2.0/xe/bin/tnslsnr and Oracle Exp
9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Control process exited, code=exited status=1
9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Failed with result 'exit-code'.
9月 05 18:43:04 jingsongchan systemd[1]: Failed to start SYSV: This is a program that is responsible for taking care of.
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
lines 1-16/16 (END)






































● oracle-xe.service - SYSV: This is a program that is responsible for taking care of
   Loaded: loaded (/etc/init.d/oracle-xe; generated)
   Active: failed (Result: exit-code) since Thu 2019-09-05 18:43:04 CST; 22s ago
     Docs: man:systemd-sysv-generator(8)
  Process: 3861 ExecStart=/etc/init.d/oracle-xe start (code=exited, status=1/FAILURE)

9月 05 18:43:04 jingsongchan su[3872]: FAILED su for oracle by root
9月 05 18:43:04 jingsongchan su[3872]: - ??? root:oracle
9月 05 18:43:04 jingsongchan oracle-xe[3861]: Starting Oracle Database 11g Express Edition instance.
9月 05 18:43:04 jingsongchan su[3878]: No passwd entry for user 'oracle'
9月 05 18:43:04 jingsongchan su[3878]: FAILED su for oracle by root
9月 05 18:43:04 jingsongchan su[3878]: - ??? root:oracle
9月 05 18:43:04 jingsongchan oracle-xe[3861]: Failed to start Oracle Net Listener using /u01/app/oracle/product/11.2.0/xe/bin/tnslsnr and Oracle Exp
9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Control process exited, code=exited status=1
9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Failed with result 'exit-code'.
9月 05 18:43:04 jingsongchan systemd[1]: Failed to start SYSV: This is a program that is responsible for taking care of.
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~

1个回答

你这看得好头疼啊,可以参考下这篇提问的智慧

《“提问的智慧”之墨天轮版——如何提问才能让我的问题得到更快速的解答?》

比如直接贴出无法登录的报错或者截图。

Csdn user default icon
上传中...
上传图片
插入图片
抄袭、复制答案,以达到刷声望分或其他目的的行为,在CSDN问答是严格禁止的,一经发现立刻封号。是时候展现真正的技术了!
其他相关推荐
不能成功安装Oracle11g ODAC
在安装的过程中, 无错误提示,就是当完成90%以后,就挂起没反应了。![图片说明](https://img-ask.csdn.net/upload/201510/12/1444643334_879003.png)
linux下Oracle安装之后重启监听失败。具体情况见下 、还往大家帮忙
我的操作是安装oracle之后、尝试连接 [oracle@linux64 ~]$ sqlplus / as sysdba Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> SQL> SQL> SQL> set linesize 2000; SQL> select * from v$instance; INSTANCE_NUMBER INSTANCE_NAME HOST_NAME VERSION STARTUP_TIME STATUS PAR THREAD# ARCHIVE LOG_SWITCH_WAIT LOGINS SHU DATABASE_STATUS INSTANCE_ROLE ACTIVE_ST BLO --------------- ---------------- ---------------------------------------------------------------- ----------------- ------------ ------------ --- ---------- ------- ------------------------------ ---------- --- ----------------- ------------------ --------- --- 1 trade linux64 11.2.0.1.0 05-SEP-15 OPEN NO 1 STOPPED ALLOWED NO ACTIVE PRIMARY_INSTANCE NORMAL NO 通过这个查询 应该说明我库应该是配置了,监听也起来了、我想试着重启一下监听。就先查看了下监听的状态、然后stop监听、再start 监听就起不来了 ORACLE安装完成后直接查看监听状态 [oracle@linux64 ~]$ lsnrctl status LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 05-SEP-2015 19:27:02 Copyright (c) 1991, 2009, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production Start Date 05-SEP-2015 18:58:31 Uptime 0 days 0 hr. 28 min. 31 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /home/oracle/oracle/product/11R2/network/admin/listener.ora Listener Log File /home/oracle/oracle/diag/tnslsnr/linux64/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=linux64)(PORT=1521))) Services Summary... Service "trade" has 1 instance(s). Instance "trade", status READY, has 1 handler(s) for this service... Service "tradeXDB" has 1 instance(s). Instance "trade", status READY, has 1 handler(s) for this service... The command completed successfully 关闭监听 [oracle@linux64 ~]$ lsnrctl stop LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 05-SEP-2015 19:27:35 Copyright (c) 1991, 2009, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521))) The command completed successfully 再次打开监听 [oracle@linux64 ~]$ lsnrctl start LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 05-SEP-2015 19:27:40 Copyright (c) 1991, 2009, Oracle. All rights reserved. Starting /home/oracle/oracle/product/11R2/bin/tnslsnr: please wait... TNSLSNR for Linux: Version 11.2.0.1.0 - Production System parameter file is /home/oracle/oracle/product/11R2/network/admin/listener.ora Log messages written to /home/oracle/oracle/diag/tnslsnr/linux64/listener/alert/log.xml Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=linux64)(PORT=1521))) Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production Start Date 05-SEP-2015 19:27:40 Uptime 0 days 0 hr. 0 min. 0 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /home/oracle/oracle/product/11R2/network/admin/listener.ora Listener Log File /home/oracle/oracle/diag/tnslsnr/linux64/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=linux64)(PORT=1521))) The listener supports no services The command completed successfully ----再次查看监听状态 [oracle@linux64 ~]$ lsnrctl status LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 05-SEP-2015 19:27:44 Copyright (c) 1991, 2009, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production Start Date 05-SEP-2015 19:27:40 Uptime 0 days 0 hr. 0 min. 4 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /home/oracle/oracle/product/11R2/network/admin/listener.ora Listener Log File /home/oracle/oracle/diag/tnslsnr/linux64/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=linux64)(PORT=1521))) The listener supports no services The command completed successfully [oracle@linux64 ~]$ lsnrctl status LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 05-SEP-2015 19:27:47 Copyright (c) 1991, 2009, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production Start Date 05-SEP-2015 19:27:40 Uptime 0 days 0 hr. 0 min. 7 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /home/oracle/oracle/product/11R2/network/admin/listener.ora Listener Log File /home/oracle/oracle/diag/tnslsnr/linux64/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=linux64)(PORT=1521))) The listener supports no services The command completed successfully
Oracle数据库恢复演习
有一个使用Oracle数据库的系统需要做一次系统恢复演习,本人做过SQLServer、MySQL等数据库,但对于Oracle可以算是零基础人 员,求大神帮助该如何实施? 基本情况如下: 版本:Oracle11g 系统环境:64位Redhat5 已知的备份文件有两个dump文件,user1@oracle_yymmdd.dump,user2@oracle_yymmdd.dump。 恢复实施方向:新搭建一台DB服务器导入数据进行测试。(基于该服务器搭建完成之后会给其他系统使用想要用Windows2008进行安装) 问题:求稍微具体的恢复步骤,比如: 1、事前确认事项(具体的需要确认哪些事情,比如数据库名称?表?还是其他?) 2、新服务器中如何恢复?(比如先安装数据库软件,再创建数据库再导入数据文件等希望能稍微详细列出) 3、恢复之后如何确认是正确恢复成功?(比如,是否需要比较某一个时间的查询数据结果?或者需要确认恢复回来的数据库的什么内容) PS:如果需要哪些更详细的信息,可提出,我尽可能的提供(只能工作日提供) 另,请问下Oracle是否有 学习用、开发测试用、以及商用等的区别?如果有可否提供下学习版本的下载地址? 求大神救命,感激不尽!
如何部署tomcat+jsp+oracle的项目
# 对比来说,部署tomcat+jsp+mysql的项目,有以下几步: 在这些软件安好之后,并且localhost:8080能进入tomcat主页, 1.只用将jsp程序包的psc数据备份文件还原或其他格式的数据备份文件还原; 2.配置apache-tomcat\conf下的XML文件或者apache-tomcat\conf\Catalina\localhost的xml文件,修改其虚拟目录及指向路径(至于端口其他另说) 3.配置 项目\WEB-INF\classes\下的datasource.properties文件,修改其数据库账号密码及连接的数据库名。 以上流程就可以部署好tomcat+jsp+mysql的项目。 ## 那么tomcat+jsp+oracle的项目该怎么部署? 部署这样的项目流程是怎样的?如果与上面的部署相似,那么在1、 2完成之后,应该修改项目的什么文件与oracle数据库连接?
Linux(RHEL_5.4 x86_64)安装Oracle_11g乱码问题
Linux(RHEL_5.4 x86_64)安装Oracle_11g完成之后运行sqlplus出现乱码问题。例如: SP2-???等等。
ORACLE ORA-01489: 字符串连接的结果过长 错误的原因
我现在本地有一个项目,是从服务器上复制下来的,与服务器的代码一模一样。 又从服务器上通过expdp的方式备份了数据库,在本地还原。 项目部署完成,启动之后有几个重要的页面报 ORA-01489: 字符串连接的结果过长 这个错误。 不知道是什么原因引起的,刚开始以为是本地数据库实例与服务器的数据库实例编码字符集不同, 但是将编码字符集同步之后也还是报这个错误。 求大佬指点!已经快给我憋疯了!
oracle 自定义聚合函数处理clob时间过长的问题如何解决
大神们,现有一问题,我自定义了一个类型和函数,用来聚合处理一个表中的某个字段的所有值,如下是类型![图片说明](https://img-ask.csdn.net/upload/201709/20/1505871910_379838.png)![图片说明](https://img-ask.csdn.net/upload/201709/20/1505871930_361029.png) 然后我又写了个存储过程用来执行这个函数,存储过程如下:![图片说明](https://img-ask.csdn.net/upload/201709/20/1505872026_568998.png)其中我把TEST_TABLE_ORDER表中的position字段和strain字段的所有值都使用自定义的类型函数聚合存到了两个clob里面,进而存入了Test_Table_Info表中,这个过程和原理都没什么问题,存储过程可以正常执行,但是执行一次需要2分30秒的时间才能完成一次聚合,聚合的原数据存储形式为如下: ![图片说明](https://img-ask.csdn.net/upload/201709/20/1505873170_651951.png) 聚合之后的数据存储形式为如下:![图片说明](https://img-ask.csdn.net/upload/201709/20/1505873261_908765.png)其中position_clob和strain_clob字段都是clob数据类型,存储聚合之后的数据 目前我经过网上查资料,暂时这么解决字符串聚合问题的,但是用时太长了,无法满足项目要求,最好是把聚合存储和截取读取的时间控制在60秒或60秒之内,这样就可以了,所以再次想请教各位大神们这个该怎么优化啊?要是我这个无法优化的话,该换个啥方法呀?
Linux服务器访问特别慢
linux 服务器访问特别慢 1.首先内存没有爆(内存64个G,用了8个G) 2.各种重启服务器也不行 3.进程各种kill -9还是不行 4.ping www.baidu.com 延迟7毫秒,ping自己的网址延迟50毫秒 5.加载网站首页的时候从访问到加载完成用了15秒 6.服务器配置顶配 7.用的oracle数据库 上述这些都是遇到的问题, 怎么试都不行,最后实在不行安装了一个oracle客户端,安装完之后重新启动就可以了,这是什么原因,求大神破解
java.sql.SQLRecoverableException: Closed Connection
各位大佬,求教,我使用DBCP连接池时出现 java.sql.SQLRecoverableException: Closed Connection 报错。经过百度后知道,该错误是连接长时间不用,自动断开了。再次使用该连接时就会出现这个错误。 目前我修改了DBCP的配置文件,如下。请问这样配置之后能不能解决该问题,我使用的是oracle数据库 ``` driverClassName= url= username= password= # 连接池启动时创建的初始化连接数量 initialSize=20 # 连接池中可同时连接的最大连接数量 maxActive=20 # 连接池中最大的空闲连接数量,超过的空闲连接将被释放,设置为负数表示不限制 maxIdle=8 # 连接池中最小的空闲连接数量,低于这个数量将创建新的连接 minIdle=5 # 最大等待时间,当没有可用连接时,连接池等待连接释放的最大时间 maxWait=10000 # 是否在归还到池中进行检验 testOnReturn=false # 校验语句,必须是查询语句,至少查询一列,设置了它onBorrow才会生效 validationQuery=select 1 from dual # 连接是否被空闲连接回收器(如果有)进行检验.如果检测失败, # 则连接将被从池中去除.设置为true后如果要生效,validationQuery参数必须设置为非空字符串 testWhileIdle=true # 从池中取出连接时完成校验 ,验证不通过销毁这个connection,默认为true, testOnBorrow=false # 每30秒运行一次空闲连接回收器 timeBetweenEvictionRunsMillis=30000 # 连接在池中保持空闲而不被空闲连接回收器线程 # (如果有)回收的最小时间值,单位毫秒 minEvictableIdleTimeMillis=1800000 #在每次空闲连接回收器线程(如果有)运行时检查的连接数量 numTestsPerEvictionRun=3 # 校验查询时长,如果超过,认为校验失败 validationQueryTimeout=1 # 设置是否自动提交 defaultAutoCommit=flase ```
如何修改表中某种分类的数据量级
现在有一张表是由三张表合并而成的,三张表分别对应于不同类型的设备,合并完成之后发现其中某一种设备的一个数据的量级和其他两张表的量级不同,需要进行量级的统一,请问如何在原列进行量级的修改
数据库备份完成后,隔了2个小时后数据库崩溃或发生灾难,备份之后的这2个小时之间,新插入了6000条记录
我就打个比方描述一下我的问题: 每天凌晨1点自动备份数据库,假如凌晨3点钟备份完成了 凌晨3点钟到凌晨4点钟这一个小时之间有6000条记录插入到数据库中的某几张表中 凌晨4点02分钟的时候,数据库突然崩溃了,或者说损坏了,反正就是数据库出了问题,发生了灾难,大概就是这么个意思 那么问题来了,我把凌晨3点钟备份的数据库还原回去,那么就意味着凌晨3点钟到凌晨4点钟这一个小时之间的6000条记录丢失了,如果遇到这种情况该怎么办,是不是意味着这6000条记录永远找不回来了 比如说:银行的交易系统会不会遇到我上面描述的这种情况,如果遇到了该怎么找回丢失了的数据? 数据库备份完成后,隔了2个小时后数据库崩溃或发生灾难,备份之后的这2个小时之间,新插入了6000条记录,新插入的这6000条记录能否找回来
关于多服务器上数据库架构后需要统计分析里面相关数据
现在问题是这样的 1、现在我们公司的数据库架构是sqlserver数据库,分了三台服务器,每台服务器上面有一组主从的数据库。 2、其中一台上面记录了所有用户的信息、项目配置、业务相关数据(不包括流水数据),一台是记录线上所有用户的操作日志流水(不包括充值),一台是记录用户订单流水和项目后台操作配置相关数据。 3、上述条件下我这边是需要统计出根据用户信息筛选出来的信息做统计,比如根据用户注册时间来查询充值数据或者用户注册的渠道来统计操作日志流水,按照现在的数据库结构我是每个服务器每个数据库都放了一张用户表方便为了进行关联查询,这种用户数据是通过脚本进行同步的,但是其中用户表中有一些可变动的字段比如 最后登录时间,登录渠道,VIP等级等数据而其他数据库里面复制的用户表只存放了固定不变的字段。这样就会导致可能有一些数据统计分析会处理不了。 4、以上的数据库的量级都是有千万级,比如用户操作日志流水有多个,每个表至少也是千万级。所以才会分成了不同的服务器上面架不同的数据库。 以上就是描述的现在的情况,那么请问一下,有没有什么想法只需要一个用户表就可以完成上面的统计数据分析数据的操作,而且统计分析效率不会太慢的情况下完成。跨服务器查询数据库应该是不现实的,如果以后增加到更多的服务器放日志,不可能每他服务器上数据库都去同步一次用户信息吧?麻烦道友给一些方向或者意见。。
无法启动IBM WebSphere Application server
安装完成之后还可以进入 管理控制台 配置,但是现在却不能启动服务了,启动就报错。 线程 "main" 中发生异常java.lang.NoClassDefFoundError: Duser.language=Zh?-Duser.region=CN Caused by: java.lang.ClassNotFoundException: Duser.language=Zh?-Duser.region=CN at java.net.URLClassLoader.findClass(URLClassLoader.java:434) at java.lang.ClassLoader.loadClassHelper(ClassLoader.java:688) at java.lang.ClassLoader.loadClass(ClassLoader.java:667) at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:358) at java.lang.ClassLoader.loadClass(ClassLoader.java:650) Could not find the main class: Duser.language=Zh?-Duser.region=CN. Program will exit. [13-7-19 13:55:00:668 CST] 00000001 ManagerAdmin I TRAS0018I: 跟踪状态已更改。新的跟踪状态是 *=info。 [13-7-19 13:55:00:998 CST] 00000001 ManagerAdmin I TRAS0040I: 所配置的跟踪状态包括以下与当前注册在服务器中的记录器不匹配的配置:"" [13-7-19 13:55:01:029 CST] 00000001 ManagerAdmin A TRAS0007I: 禁用记录到服务日志 [13-7-19 13:55:01:107 CST] 00000001 ProviderTrack I com.ibm.ffdc.osgi.ProviderTracker AddingService FFDC1007I: FFDC 提供程序安装:com.ibm.ffdc.util.provider.FfdcOnDirProvider@5aeca244 ************ Start Display Current Environment ************ WebSphere Platform 8.5.5.0 [BASE 8.5.5.0 gm1319.01] running with process name dsyNode01Cell\dsyNode01\server1 and process id 4108 Host Operating System is Windows 8, version 6.2 Java version = 1.6.0, Java Compiler = j9jit26, Java VM name = IBM J9 VM was.install.root = D:\Program Files\Server\IBM\WebSphere\AppServer user.install.root = D:\Program Files\Server\IBM\WebSphere\AppServer\profiles\AppSrv01 Java Home = D:\Program Files\Server\IBM\WebSphere\AppServer\java\jre ws.ext.dirs = D:\Program Files\Server\IBM\WebSphere\AppServer/java/lib;D:\Program Files\Server\IBM\WebSphere\AppServer\profiles\AppSrv01/classes;D:\Program Files\Server\IBM\WebSphere\AppServer/classes;D:\Program Files\Server\IBM\WebSphere\AppServer/lib;D:\Program Files\Server\IBM\WebSphere\AppServer/installedChannels;D:\Program Files\Server\IBM\WebSphere\AppServer/lib/ext;D:\Program Files\Server\IBM\WebSphere\AppServer/web/help;D:\Program Files\Server\IBM\WebSphere\AppServer/deploytool/itp/plugins/com.ibm.etools.ejbdeploy/runtime Classpath = D:\Program Files\Server\IBM\WebSphere\AppServer\profiles\AppSrv01/properties;D:\Program Files\Server\IBM\WebSphere\AppServer/properties;D:\Program Files\Server\IBM\WebSphere\AppServer/lib/startup.jar;D:\Program Files\Server\IBM\WebSphere\AppServer/lib/bootstrap.jar;D:\Program Files\Server\IBM\WebSphere\AppServer/lib/jsf-nls.jar;D:\Program Files\Server\IBM\WebSphere\AppServer/lib/lmproxy.jar;D:\Program Files\Server\IBM\WebSphere\AppServer/lib/urlprotocols.jar;D:\Program Files\Server\IBM\WebSphere\AppServer/deploytool/itp/batchboot.jar;D:\Program Files\Server\IBM\WebSphere\AppServer/deploytool/itp/batch2.jar;D:\Program Files\Server\IBM\WebSphere\AppServer/java/lib/tools.jar Java Library path = D:\Program Files\Server\IBM\WebSphere\AppServer/lib/native/win/x86_32/;D:\Program Files\Server\IBM\WebSphere\AppServer\java\jre\bin\default;D:\Program Files\Server\IBM\WebSphere\AppServer\java\jre\bin;C:\Windows\system32;C:\Windows;D:\Program Files\Server\IBM\WebSphere\AppServer\lib\native\win\x86_32;D:\Program Files\Server\IBM\WebSphere\AppServer\bin;D:\Program Files\Server\IBM\WebSphere\AppServer\java\bin;D:\Program Files\Server\IBM\WebSphere\AppServer\java\jre\bin;D:\oracle\product\11.2.0\dbhome_1\bin;D:\Program Files\Database\oracle\product\10.2.0\client_1\bin;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;D:\Program Files\Java\jdk1.7.0_10\bin;D:\Program Files\Database\SQL Server 2012\110\DTS\Binn\;D:\Program Files\Database\SQL Server 2012\110\Tools\Binn\;D:\Program Files\Database\SQL Server 2012\110\Tools\Binn\ManagementStudio\;C:\Program Files\Microsoft Visual Studio 10.0\Common7\IDE\PrivateAssemblies\;.; Orb Version = IBM Java ORB build orb626-20130112.01 ************* End Display Current Environment ************* [13-7-19 14:03:49:152 CST] 00000001 ManagerAdmin I TRAS0018I: 跟踪状态已更改。新的跟踪状态是 *=info。 [13-7-19 14:03:49:339 CST] 00000001 ManagerAdmin I TRAS0040I: 所配置的跟踪状态包括以下与当前注册在服务器中的记录器不匹配的配置:"" [13-7-19 14:03:49:355 CST] 00000001 ManagerAdmin A TRAS0007I: 禁用记录到服务日志 [13-7-19 14:03:49:386 CST] 00000001 ProviderTrack I com.ibm.ffdc.osgi.ProviderTracker AddingService FFDC1007I: FFDC 提供程序安装:com.ibm.ffdc.util.provider.FfdcOnDirProvider@c512f0f9 刚刚接触 webshpere!
PreparedStatement 预编译原理
<p><strong><span>preparedStatement 有三大优点:</span></strong></p> <p><span><span>一.代码的可读性和可维护性. </span></span></p> <p><span><span>二.PreparedStatement尽最大可能提高性能. </span></span></p> <p><span><span>三.最重要的一点是极大地提高了安全性. </span></span></p> <p> </p> <p><span><span>其中一和三的确很易理解。 关于性能的提高也是最有价值的这点, 我对其原理还有些质疑。 </span></span></p> <p> </p> <p> </p> <div class="quote_title">网上一:</div> <div class="quote_div">SQL 语句被预编译并且存储在 PreparedStatement 对象中,其后可以使用该对象高效地多次执行该语句。 <br> </div> <p><span style="color: #ff0000;">问题:</span>预编译在JDBC中完成的?还是数据库中?即便存在preparedStatement中,如果这个preparedStatement 对象不被缓存起来,其后又如何重复使用,多次执行? (一些webserver会缓存preparedStatement)</p> <p>我想关于其性能的提高主要得需要数据库的支持。 </p> <div class="quote_title">oracle 性能优化 写道</div> <div class="quote_div">共享SQL语句 <br>  为了不重复解析相同的SQL语句,在第一次解析之后, ORACLE将SQL语句存放在内存中。 <br>可惜的是ORACLE只对简单的表提供高速缓冲(cache buffering) ,这个功能并不适用于多表连接查询。 <br> </div> <p><span><span><span><span><span><span style="font-size: x-small;"><span style="color: #008000;">个人理解:</span>预编译是利用数据库的SQL共享来实现的,因为当使用preparedStatement 的时候,尽管参数不同,但是在语句中用?来替代。 因此很多语句就完全相同。(这个道理和J2EE的server缓存preparedStatement 的道理应该是一样的)</span></span></span></span></span></span></p> <p> </p> <p><span><span><span><span><span><span><span style="font-size: x-small;"><span style="color: #ff0000;">问题:</span>但是如果是这样的话,那么oracle的多表查询岂不是并无预编译效果?</span></span></span></span></span></span></span></p> <p> </p> <p><span><span><span><span><span><span style="font-size: x-small;"><span><span><span><span><span><span><span style="color: #ff0000;">问题:</span></span></span></span></span></span></span>关于缓存:是否根据创建preparedStatement的语句来做为Key来map的?例如以下:是否检查匹配insert into tb_name (col1,col2,col2,col4) values (?,?,?,?)来确定是否用已经有的执行路径来执行? </span></span></span></span></span></span></p> <p><span><span><span><span style="font-size: x-small;"><span>perstmt = con.prepareStatement("insert into tb_name (col1,col2,col2,col4) values (?,?,?,?)"); </span></span></span></span></span></p> <p><span> </span></p> <p><span><strong>以下几篇从网络上搜索到的三篇文章:</strong></span></p> <p><span> </span></p> <div class="quote_title"><span>CSDN 写道</span></div> <div class="quote_div"><span>一.代码的可读性和可维护性. <br>虽然用PreparedStatement来代替Statement会使代码多出几行,但这样的代码无论从可读性还是可维护性上来说.都比直接用Statement的代码高很多档次: <br><br>stmt.executeUpdate("insert into tb_name (col1,col2,col2,col4) values ('"+var1+"','"+var2+"',"+var3+",'"+var4+"')"); <br><br>perstmt = con.prepareStatement("insert into tb_name (col1,col2,col2,col4) values (?,?,?,?)"); <br>perstmt.setString(1,var1); <br>perstmt.setString(2,var2); <br>perstmt.setString(3,var3); <br>perstmt.setString(4,var4); <br>perstmt.executeUpdate(); <br><br>不用我多说,对于第一种方法.别说其他人去读你的代码,就是你自己过一段时间再去读,都会觉得伤心. <br><br>二.PreparedStatement尽最大可能提高性能. <br>每一种数据库都会尽最大努力对预编译语句提供最大的性能优化.因为预编译语句有可能被重复调用.所以语句在被DB的编译器编译后的执行代码被缓存下来,那么下次调用时只要是相同的预编译语句就不需要编译,只要将参数直接传入编译过的语句执行代码中(相当于一个涵数)就会得到执行.这并不是说只有一个Connection中多次执行的预编译语句被缓存,而是<span style="color: #0000ff;">对于整个DB中,只要预编译的语句语法和缓存中匹配.那么在任何时候就可以不需要再次编译而可以直接执行.而statement的语句中,即使是相同一操作,而由于每次操作的数据不同所以使整个语句相匹配的机会极小,几乎不太可能匹配.</span>比如: <br>insert into tb_name (col1,col2) values ('11','22'); <br>insert into tb_name (col1,col2) values ('11','23'); <br>即使是相同操作但因为数据内容不一样,所以整个个语句本身不能匹配,没有缓存语句的意义.事实是没有数据库会对普通语句编译后的执行代码缓存.这样每执行一次都要对传入的语句编译一次. <br><br>当然并不是所以预编译语句都一定会被缓存,数据库本身会用一种策略,比如使用频度等因素来决定什么时候不再缓存已有的预编译结果.以保存有更多的空间存储新的预编译语句. <br><br>三.最重要的一点是极大地提高了安全性. <br><br>即使到目前为止,仍有一些人连基本的恶义SQL语法都不知道. <br>String sql = "select * from tb_name where name= '"+varname+"' and passwd='"+varpasswd+"'"; <br>如果我们把[' or '1' = '1]作为varpasswd传入进来.用户名随意,看看会成为什么? <br><br>select * from tb_name = '随意' and passwd = '' or '1' = '1'; <br>因为'1'='1'肯定成立,所以可以任何通过验证.更有甚者: <br>把[';drop table tb_name;]作为varpasswd传入进来,则: <br>select * from tb_name = '随意' and passwd = '';drop table tb_name;有些数据库是不会让你成功的,但也有很多数据库就可以使这些语句得到执行. <br><br>而如果你使用预编译语句.你传入的任何内容就不会和原来的语句发生任何匹配的关系.(前提是数据库本身支持预编译,但上前可能没有什么服务端数据库不支持编译了,只有少数的桌面数据库,就是直接文件访问的那些)只要全使用预编译语句,你就用不着对传入的数据做任何过虑.而如果使用普通的statement,有可能要对drop,;等做费尽心机的判断和过虑. </span></div> <p><span> </span></p> <p> </p> <div class="quote_title"><span>论坛 写道</span></div> <div class="quote_div"> <span><span style="font-size: x-small;">1,执行效率:Statement 采取直接编译 SQL 语句的方式,扔给数据库去执行,而 </span></span><span><span><span style="font-size: x-small;"><span style="color: #0000ff;">PreparedStatement 则先将 SQL 语句预编译</span>一遍,再填充参数,这样效率会高一些。JDK 文档说:SQL 语句被预编译并且存储在 PreparedStatement 对象中,其后可以使用该对象高效地多次执行该语句。 <br><br>2,代码可读性:Statement 中 SQL 语句中需要 Java 中的变量,加就得进行字符串的运算,还需要考虑一些引号、单引号的问题,参数变量越多,代码就越难看,而且会被单引号、双引号搞疯掉;而 PreparedStatement,则不需要这样,参数可以采用“?”占位符代替,接下来再进行参数的填充,这样利于代码的可读性,并且符合面向对象的思想。 <br><br>3,安全性:Statement 由于可能需要采取字符串与变量的拼接,很容易进行 SQL 注入攻击,而 PreparedStatement 由于是预 <br>编译,再填充参数的,不存在 SQL 注入问题。 <br></span></span></span> </div> <p><span> </span></p> <div class="quote_title"><span>Oracle 优化 写道</span></div> <div class="quote_div"><span>3. 共享SQL语句 <br>  为了不重复解析相同的SQL语句,在第一次解析之后, ORACLE将SQL语句存放在内存中。这块位于系统全局区域SGA(system global area)的共享池(shared buffer pool)中的内存可以被所有的数据库用户共享。 因此,当你执行一个SQL语句(有时被称为一个游标)时,如果它和之前的执行过的语句完全相同, ORACLE就能很快获得已经被解析的语句以及最好的执行路径。 ORACLE的这个功能大大地提高了SQL的执行性能并节省了内存的使用。 <br><br>  可惜的是ORACLE只对简单的表提供高速缓冲(cache buffering) ,这个功能并不适用于多表连接查询。 </span></div><br /><strong>问题补充:</strong><br />感谢geeksun的回答,我的理解是: <br />问题1, PreparedStatement是jdbc 驱动包里的一个类,并不是说存储在jdbc中。 <br />问题2, 我认为多表查询不支持预编这是不可能的。 <br />问题3, 我想这样提问可能更好一些。 <br />java 方法如下: <br />protected boolean updateSalary(Connection conn,BigDecimal x,String ID) throws SQLException{ <br /> PreparedStatement pstmt = null; <br /> try { <br /> pstmt = conn.prepareStatement("UPDATE EMPLOYEES SET SALARY = ? WHERE ID = ?"); <br /> pstmt.setBigDecimal(1, x); <br /> pstmt.setString(2, ID); <br /> return true; <br /> } finally{ <br /> if (pstmt!=null){ <br /> pstmt.close(); <br /> } <br /> } <br /> <br /> } <br /> <br /> <br />第一次调用以后,是否会缓存PreparedStatement, 这个在用weblogic这种server的时候是可以肯定的。因为从数据源的来connection是一个包装类,不是jdbc驱动的connection,而用connection来创建的PreparedStatement也是封装类。因此尽管pstmt.close().但是实际被封装的PreparedStatement并未关闭。 <br />但是是第二次调用这个方法,会重新conn.prepareStatement, 这个时候我想应该是根据语句来作为key来寻找缓存的preparedStatement,但是尽管取到缓存。 如果没有Database的配合,效率也很难提高多少。 <br /><strong>问题补充:</strong><br />谢谢geeksun的帮忙,Sql的共享我想肯定是支持多表的。 至于高速缓存应该讲的是结果的缓存。 <br />但是你对PreparedStatement的观点我认为是不对的。 因为这个对象肯定是在WebServer端的, 不可能跑到数据库那端。K-V对应的K值应该就是创建这个对象的那条语句,只是需要一个精通人士的肯定。
MyBatis 出现参数绑定异常 Parameter 'start' not found.
MyBatis 出现参数绑定异常 Parameter 'start' not found. Available parameters are [0, param1, param2, state] 下面是部分代码 bean(提供了get set方法): ``` private Integer start;//起始记录 private Integer end;//结束记录 private Integer pageNumber;//当前页号 private Integer pageSize;//每页显示记录数 private Integer count;//总记录数 private Integer totalPage;//总页数 private List<E> data=new ArrayList<E>();//存储数据 public Integer getStart() { start=((pageNumber-1)*pageSize)+1; return start; } public void setStart(Integer start) { this.start = start; } ``` dao接口 ``` public void getWorksByStatePage(PageBean<Work> pageBean,@Param("state")String state); ``` XML映射文件 这里是调用Oracle存储过程完成的分页 ``` <select id="getWorksByStateAndUserIDPage" statementType="CALLABLE" > {call getWorksByStatePageAndUserId( #{start,mode=IN,jdbcType=INTEGER}, #{end,mode=IN,jdbcType=INTEGER}, #{state,mode=IN,jdbcType=VARCHAR}, #{userID,mode=IN,jdbcType=INTEGER}, #{count,mode=OUT,jdbcType=INTEGER}, #{data,mode=OUT,jdbcType=CURSOR,javaType=ResultSet,resultMap=pageWork} )} </select> <!-- data指定封装规则(WORK表) --> <resultMap type="cn.myapp.qcs.work.po.Work" id="pageWork"> <!-- 数据库 类变量 --> <id column="WORKID" property="workId"/> <result column="ISREAD" property="isRead"/> <result column="ACATIVITY" property="acativity"/> <result column="CUSID" property="cusId"/> <result column="DES" property="des"/> <result column="USERID" property="userID"/> <result column="STATE" property="state"/> <result column="CREATEDATE" property="creatDate"/> <result column="RECEIVEDATE" property="receiveDate"/> <result column="COMPLETEDATE" property="completeDate"/> </resultMap> ``` 我在想是不是接口那里同时传入对象和String造成取不到值的问题,但是@Param("pageBean")加上以后XML用#{pageBean.start}的形式会有406错误 已经改好了 对象和普通参数一起使用要用@Param("pageBean") XML使用#{pageBean.start} 或者XML直接用#{0.start}的形式取值 后来报的406是因为springmvc的问题 参考http://blog.csdn.net/aosica321/article/details/73471320解决的
爬虫福利二 之 妹子图网MM批量下载
爬虫福利一:27报网MM批量下载    点击 看了本文,相信大家对爬虫一定会产生强烈的兴趣,激励自己去学习爬虫,在这里提前祝:大家学有所成! 目标网站:妹子图网 环境:Python3.x 相关第三方模块:requests、beautifulsoup4 Re:各位在测试时只需要将代码里的变量 path 指定为你当前系统要保存的路径,使用 python xxx.py 或IDE运行即可。
Java学习的正确打开方式
在博主认为,对于入门级学习java的最佳学习方法莫过于视频+博客+书籍+总结,前三者博主将淋漓尽致地挥毫于这篇博客文章中,至于总结在于个人,实际上越到后面你会发现学习的最好方式就是阅读参考官方文档其次就是国内的书籍,博客次之,这又是一个层次了,这里暂时不提后面再谈。博主将为各位入门java保驾护航,各位只管冲鸭!!!上天是公平的,只要不辜负时间,时间自然不会辜负你。 何谓学习?博主所理解的学习,它
程序员必须掌握的核心算法有哪些?
由于我之前一直强调数据结构以及算法学习的重要性,所以就有一些读者经常问我,数据结构与算法应该要学习到哪个程度呢?,说实话,这个问题我不知道要怎么回答你,主要取决于你想学习到哪些程度,不过针对这个问题,我稍微总结一下我学过的算法知识点,以及我觉得值得学习的算法。这些算法与数据结构的学习大多数是零散的,并没有一本把他们全部覆盖的书籍。下面是我觉得值得学习的一些算法以及数据结构,当然,我也会整理一些看过
大学四年自学走来,这些私藏的实用工具/学习网站我贡献出来了
大学四年,看课本是不可能一直看课本的了,对于学习,特别是自学,善于搜索网上的一些资源来辅助,还是非常有必要的,下面我就把这几年私藏的各种资源,网站贡献出来给你们。主要有:电子书搜索、实用工具、在线视频学习网站、非视频学习网站、软件下载、面试/求职必备网站。 注意:文中提到的所有资源,文末我都给你整理好了,你们只管拿去,如果觉得不错,转发、分享就是最大的支持了。 一、PDF搜索网站推荐 对于大部
linux系列之常用运维命令整理笔录
本博客记录工作中需要的linux运维命令,大学时候开始接触linux,会一些基本操作,可是都没有整理起来,加上是做开发,不做运维,有些命令忘记了,所以现在整理成博客,当然vi,文件操作等就不介绍了,慢慢积累一些其它拓展的命令,博客不定时更新 顺便拉下票,我在参加csdn博客之星竞选,欢迎投票支持,每个QQ或者微信每天都可以投5票,扫二维码即可,http://m234140.nofollow.ax.
Vue + Spring Boot 项目实战(十四):用户认证方案与完善的访问拦截
本篇文章主要讲解 token、session 等用户认证方案的区别并分析常见误区,以及如何通过前后端的配合实现完善的访问拦截,为下一步权限控制的实现打下基础。
比特币原理详解
一、什么是比特币 比特币是一种电子货币,是一种基于密码学的货币,在2008年11月1日由中本聪发表比特币白皮书,文中提出了一种去中心化的电子记账系统,我们平时的电子现金是银行来记账,因为银行的背后是国家信用。去中心化电子记账系统是参与者共同记账。比特币可以防止主权危机、信用风险。其好处不多做赘述,这一层面介绍的文章很多,本文主要从更深层的技术原理角度进行介绍。 二、问题引入  假设现有4个人
程序员接私活怎样防止做完了不给钱?
首先跟大家说明一点,我们做 IT 类的外包开发,是非标品开发,所以很有可能在开发过程中会有这样那样的需求修改,而这种需求修改很容易造成扯皮,进而影响到费用支付,甚至出现做完了项目收不到钱的情况。 那么,怎么保证自己的薪酬安全呢? 我们在开工前,一定要做好一些证据方面的准备(也就是“讨薪”的理论依据),这其中最重要的就是需求文档和验收标准。一定要让需求方提供这两个文档资料作为开发的基础。之后开发
网页实现一个简单的音乐播放器(大佬别看。(⊙﹏⊙))
今天闲着无事,就想写点东西。然后听了下歌,就打算写个播放器。 于是乎用h5 audio的加上js简单的播放器完工了。 欢迎 改进 留言。 演示地点跳到演示地点 html代码如下`&lt;!DOCTYPE html&gt; &lt;html&gt; &lt;head&gt; &lt;title&gt;music&lt;/title&gt; &lt;meta charset="utf-8"&gt
Python十大装B语法
Python 是一种代表简单思想的语言,其语法相对简单,很容易上手。不过,如果就此小视 Python 语法的精妙和深邃,那就大错特错了。本文精心筛选了最能展现 Python 语法之精妙的十个知识点,并附上详细的实例代码。如能在实战中融会贯通、灵活使用,必将使代码更为精炼、高效,同时也会极大提升代码B格,使之看上去更老练,读起来更优雅。 1. for - else 什么?不是 if 和 else 才
数据库优化 - SQL优化
前面一篇文章从实例的角度进行数据库优化,通过配置一些参数让数据库性能达到最优。但是一些“不好”的SQL也会导致数据库查询变慢,影响业务流程。本文从SQL角度进行数据库优化,提升SQL运行效率。 判断问题SQL 判断SQL是否有问题时可以通过两个表象进行判断: 系统级别表象 CPU消耗严重 IO等待严重 页面响应时间过长
2019年11月中国大陆编程语言排行榜
2019年11月2日,我统计了某招聘网站,获得有效程序员招聘数据9万条。针对招聘信息,提取编程语言关键字,并统计如下: 编程语言比例 rank pl_ percentage 1 java 33.62% 2 c/c++ 16.42% 3 c_sharp 12.82% 4 javascript 12.31% 5 python 7.93% 6 go 7.25% 7
通俗易懂地给女朋友讲:线程池的内部原理
餐厅的约会 餐盘在灯光的照耀下格外晶莹洁白,女朋友拿起红酒杯轻轻地抿了一小口,对我说:“经常听你说线程池,到底线程池到底是个什么原理?”我楞了一下,心里想女朋友今天是怎么了,怎么突然问出这么专业的问题,但做为一个专业人士在女朋友面前也不能露怯啊,想了一下便说:“我先给你讲讲我前同事老王的故事吧!” 大龄程序员老王 老王是一个已经北漂十多年的程序员,岁数大了,加班加不动了,升迁也无望,于是拿着手里
经典算法(5)杨辉三角
写在前面: 我是 扬帆向海,这个昵称来源于我的名字以及女朋友的名字。我热爱技术、热爱开源、热爱编程。技术是开源的、知识是共享的。 这博客是对自己学习的一点点总结及记录,如果您对 Java、算法 感兴趣,可以关注我的动态,我们一起学习。 用知识改变命运,让我们的家人过上更好的生活。 目录一、杨辉三角的介绍二、杨辉三角的算法思想三、代码实现1.第一种写法2.第二种写法 一、杨辉三角的介绍 百度
腾讯算法面试题:64匹马8个跑道需要多少轮才能选出最快的四匹?
昨天,有网友私信我,说去阿里面试,彻底的被打击到了。问了为什么网上大量使用ThreadLocal的源码都会加上private static?他被难住了,因为他从来都没有考虑过这个问题。无独有偶,今天笔者又发现有网友吐槽了一道腾讯的面试题,我们一起来看看。 腾讯算法面试题:64匹马8个跑道需要多少轮才能选出最快的四匹? 在互联网职场论坛,一名程序员发帖求助到。二面腾讯,其中一个算法题:64匹
面试官:你连RESTful都不知道我怎么敢要你?
面试官:了解RESTful吗? 我:听说过。 面试官:那什么是RESTful? 我:就是用起来很规范,挺好的 面试官:是RESTful挺好的,还是自我感觉挺好的 我:都挺好的。 面试官:… 把门关上。 我:… 要干嘛?先关上再说。 面试官:我说出去把门关上。 我:what ?,夺门而去 文章目录01 前言02 RESTful的来源03 RESTful6大原则1. C-S架构2. 无状态3.统一的接
为啥国人偏爱Mybatis,而老外喜欢Hibernate/JPA呢?
关于SQL和ORM的争论,永远都不会终止,我也一直在思考这个问题。昨天又跟群里的小伙伴进行了一番讨论,感触还是有一些,于是就有了今天这篇文。 声明:本文不会下关于Mybatis和JPA两个持久层框架哪个更好这样的结论。只是摆事实,讲道理,所以,请各位看官勿喷。 一、事件起因 关于Mybatis和JPA孰优孰劣的问题,争论已经很多年了。一直也没有结论,毕竟每个人的喜好和习惯是大不相同的。我也看
SQL-小白最佳入门sql查询一
一 说明 如果是初学者,建议去网上寻找安装Mysql的文章安装,以及使用navicat连接数据库,以后的示例基本是使用mysql数据库管理系统; 二 准备前提 需要建立一张学生表,列分别是id,名称,年龄,学生信息;本示例中文章篇幅原因SQL注释略; 建表语句: CREATE TABLE `student` ( `id` int(11) NOT NULL AUTO_INCREMENT, `
项目中的if else太多了,该怎么重构?
介绍 最近跟着公司的大佬开发了一款IM系统,类似QQ和微信哈,就是聊天软件。我们有一部分业务逻辑是这样的 if (msgType = "文本") { // dosomething } else if(msgType = "图片") { // doshomething } else if(msgType = "视频") { // doshomething } else { // dosho
“狗屁不通文章生成器”登顶GitHub热榜,分分钟写出万字形式主义大作
一、垃圾文字生成器介绍 最近在浏览GitHub的时候,发现了这样一个骨骼清奇的雷人项目,而且热度还特别高。 项目中文名:狗屁不通文章生成器 项目英文名:BullshitGenerator 根据作者的介绍,他是偶尔需要一些中文文字用于GUI开发时测试文本渲染,因此开发了这个废话生成器。但由于生成的废话实在是太过富于哲理,所以最近已经被小伙伴们给玩坏了。 他的文风可能是这样的: 你发现,
程序员:我终于知道post和get的区别
IT界知名的程序员曾说:对于那些月薪三万以下,自称IT工程师的码农们,其实我们从来没有把他们归为我们IT工程师的队伍。他们虽然总是以IT工程师自居,但只是他们一厢情愿罢了。 此话一出,不知激起了多少(码农)程序员的愤怒,却又无可奈何,于是码农问程序员。 码农:你知道get和post请求到底有什么区别? 程序员:你看这篇就知道了。 码农:你月薪三万了? 程序员:嗯。 码农:你是怎么做到的? 程序员:
《程序人生》系列-这个程序员只用了20行代码就拿了冠军
你知道的越多,你不知道的越多 点赞再看,养成习惯GitHub上已经开源https://github.com/JavaFamily,有一线大厂面试点脑图,欢迎Star和完善 前言 这一期不算《吊打面试官》系列的,所有没前言我直接开始。 絮叨 本来应该是没有这期的,看过我上期的小伙伴应该是知道的嘛,双十一比较忙嘛,要值班又要去帮忙拍摄年会的视频素材,还得搞个程序员一天的Vlog,还要写BU
加快推动区块链技术和产业创新发展,2019可信区块链峰会在京召开
      11月8日,由中国信息通信研究院、中国通信标准化协会、中国互联网协会、可信区块链推进计划联合主办,科技行者协办的2019可信区块链峰会将在北京悠唐皇冠假日酒店开幕。   区块链技术被认为是继蒸汽机、电力、互联网之后,下一代颠覆性的核心技术。如果说蒸汽机释放了人类的生产力,电力解决了人类基本的生活需求,互联网彻底改变了信息传递的方式,区块链作为构造信任的技术有重要的价值。   1
程序员把地府后台管理系统做出来了,还有3.0版本!12月7号最新消息:已在开发中有github地址
第一幕:缘起 听说阎王爷要做个生死簿后台管理系统,我们派去了一个程序员…… 996程序员做的梦: 第一场:团队招募 为了应对地府管理危机,阎王打算找“人”开发一套地府后台管理系统,于是就在地府总经办群中发了项目需求。 话说还是中国电信的信号好,地府都是满格,哈哈!!! 经常会有外行朋友问:看某网站做的不错,功能也简单,你帮忙做一下? 而这次,面对这样的需求,这个程序员
Android 9.0系统新特性,对刘海屏设备进行适配
其实Android 9.0系统已经是去年推出的“老”系统了,这个系统中新增了一个比较重要的特性,就是对刘海屏设备进行了支持。一直以来我也都有打算针对这个新特性好好地写一篇文章,但是为什么直到拖到了Android 10.0系统都发布了才开始写这篇文章呢?当然,一是因为我这段时间确实比较忙,今年几乎绝大部分的业余时间都放到写新书上了。但是最主要的原因并不是这个,而是因为刘海屏设备的适配存在一定的特殊性
网易云6亿用户音乐推荐算法
网易云音乐是音乐爱好者的集聚地,云音乐推荐系统致力于通过 AI 算法的落地,实现用户千人千面的个性化推荐,为用户带来不一样的听歌体验。 本次分享重点介绍 AI 算法在音乐推荐中的应用实践,以及在算法落地过程中遇到的挑战和解决方案。 将从如下两个部分展开: AI 算法在音乐推荐中的应用 音乐场景下的 AI 思考 从 2013 年 4 月正式上线至今,网易云音乐平台持续提供着:乐屏社区、UGC
【技巧总结】位运算装逼指南
位算法的效率有多快我就不说,不信你可以去用 10 亿个数据模拟一下,今天给大家讲一讲位运算的一些经典例子。不过,最重要的不是看懂了这些例子就好,而是要在以后多去运用位运算这些技巧,当然,采用位运算,也是可以装逼的,不信,你往下看。我会从最简单的讲起,一道比一道难度递增,不过居然是讲技巧,那么也不会太难,相信你分分钟看懂。 判断奇偶数 判断一个数是基于还是偶数,相信很多人都做过,一般的做法的代码如下
日均350000亿接入量,腾讯TubeMQ性能超过Kafka
整理 | 夕颜出品 | AI科技大本营(ID:rgznai100) 【导读】近日,腾讯开源动作不断,相继开源了分布式消息中间件TubeMQ,基于最主流的 OpenJDK8开发的
8年经验面试官详解 Java 面试秘诀
    作者 | 胡书敏 责编 | 刘静 出品 | CSDN(ID:CSDNnews) 本人目前在一家知名外企担任架构师,而且最近八年来,在多家外企和互联网公司担任Java技术面试官,前后累计面试了有两三百位候选人。在本文里,就将结合本人的面试经验,针对Java初学者、Java初级开发和Java开发,给出若干准备简历和准备面试的建议。   Java程序员准备和投递简历的实
面试官如何考察你的思维方式?
1.两种思维方式在求职面试中,经常会考察这种问题:北京有多少量特斯拉汽车? 某胡同口的煎饼摊一年能卖出多少个煎饼? 深圳有多少个产品经理? 一辆公交车里能装下多少个乒乓球? 一
碎片化的时代,如何学习
今天周末,和大家聊聊学习这件事情。 在如今这个社会,我们的时间被各类 APP 撕的粉碎。 刷知乎、刷微博、刷朋友圈; 看论坛、看博客、看公号; 等等形形色色的信息和知识获取方式一个都不错过。 貌似学了很多,但是却感觉没什么用。 要解决上面这些问题,首先要分清楚一点,什么是信息,什么是知识。 那什么是信息呢? 你一切听到的、看到的,都是信息,比如微博上的明星出轨、微信中的表情大战、抖音上的...
so easy! 10行代码写个"狗屁不通"文章生成器
前几天,GitHub 有个开源项目特别火,只要输入标题就可以生成一篇长长的文章。背后实现代码一定很复杂吧,里面一定有很多高深莫测的机器学习等复杂算法不过,当我看了源代码之后这程序不到50
知乎高赞:中国有什么拿得出手的开源软件产品?(整理自本人原创回答)
知乎高赞:中国有什么拿得出手的开源软件产品? 在知乎上,有个问题问“中国有什么拿得出手的开源软件产品(在 GitHub 等社区受欢迎度较好的)?” 事实上,还不少呢~ 本人于2019.7.6进行了较为全面的 回答 - Bravo Yeung,获得该问题下回答中得最高赞(236赞和1枚专业勋章),对这些受欢迎的 Github 开源项目分类整理如下: 分布式计算、云平台相关工具类 1.SkyWalk
MySQL数据库总结
文章目录一、数据库简介二、MySQL数据类型(5.5版本)三、Sql语句(1)Sql语句简介(2)数据定义语言DDLcreate,alter,drop(3)数据操纵语言DMLupdate,insert,delete(4)数据控制语言DCLgrant,revoke(5)数据查询语言DQLselect(6)分组查询与分页查询group by,limit四、完整性约束(单表)五、多表查询六、MySQL数
相关热词 c# 二进制截断字符串 c#实现窗体设计器 c#检测是否为微信 c# plc s1200 c#里氏转换原则 c# 主界面 c# do loop c#存为组套 模板 c# 停掉协程 c# rgb 读取图片
立即提问