Microsoft Windows [版本 10.0.17763.379]
(c) 2018 Microsoft Corporation。保留所有权利。
C:\Users\Administrator>ssh root@188.1.1.18
root@188.1.1.18's password:
Welcome to Ubuntu 14.04.6 LTS (GNU/Linux 4.4.0-142-generic i686)
* Documentation: https://help.ubuntu.com/
System information as of Mon Jan 22 09:47:44 CST 2024
System load: 0.01 IP address for eth0: 173.1.16.88
Usage of /: 49.8% of 2.72GB IP address for eth1: 192.168.2.177
Memory usage: 3% IP address for eth2: 192.168.3.177
Swap usage: 0% IP address for eth3: 192.168.4.177
Processes: 108 IP address for eth4: 192.168.5.177
Users logged in: 1 IP address for eth5: 188.1.1.18
Graph this data and manage this system at:
https://landscape.canonical.com/
Your Hardware Enablement Stack (HWE) is supported until April 2019.
Last login: Mon Jan 22 09:46:31 2024 from 181.11.10.41
root@ubuntu:~# ssh root@173.1.16.87
root@173.1.16.87's password:
Permission denied, please try again.
root@173.1.16.87's password:
Last login: Mon Jan 22 09:52:48 2024 from 173.1.16.88
User Failures Last failure Host
[root@JXZ-PCS ~]#
[root@JXZ-PCS ~]#
[root@JXZ-PCS ~]#
[root@JXZ-PCS ~]# cd /home/gbasedbt/
Display all 281 possibilities? (y or n)
[root@JXZ-PCS ~]# cd /home/gbasedbt/
[root@JXZ-PCS gbasedbt]# ls
alter_scada_quality_bigint free_dbs_rows020230627_010002.sql free_dbs_rows020230821_010001.sql free_dbs_rows020231016_010001.sql free_dbs_rows020231210_010001.sql
backup free_dbs_rows020230628_010001.sql free_dbs_rows020230822_010001.sql free_dbs_rows020231017_010001.sql free_dbs_rows020231211_010001.sql
dbs2023.sh free_dbs_rows020230629_010001.sql free_dbs_rows020230823_010001.sql free_dbs_rows020231018_010001.sql free_dbs_rows020231212_010001.sql
debug free_dbs_rows020230630_010002.sql free_dbs_rows020230824_010002.sql free_dbs_rows020231019_010001.sql free_dbs_rows020231213_010001.sql
debug_insert_1707_pro free_dbs_rows020230701_010001.sql free_dbs_rows020230825_010001.sql free_dbs_rows020231020_010001.sql free_dbs_rows020231214_010001.sql
debug.update_1703_pro free_dbs_rows020230702_010001.sql free_dbs_rows020230826_010001.sql free_dbs_rows020231021_010002.sql free_dbs_rows020231215_010001.sql
delete_10401_pro free_dbs_rows020230703_010001.sql free_dbs_rows020230827_010002.sql free_dbs_rows020231022_010001.sql free_dbs_rows020231216_010001.sql
excel_sql free_dbs_rows020230704_010002.sql free_dbs_rows020230828_010002.sql free_dbs_rows020231023_010001.sql free_dbs_rows020231217_010002.sql
excel_sql.tar free_dbs_rows020230705_010002.sql free_dbs_rows020230829_010001.sql free_dbs_rows020231024_010001.sql free_dbs_rows020231218_010001.sql
fragments.unl free_dbs_rows020230706_010001.sql free_dbs_rows020230830_010001.sql free_dbs_rows020231025_010001.sql free_dbs_rows020231219_010001.sql
free_dbs.log free_dbs_rows020230707_010001.sql free_dbs_rows020230831_010002.sql free_dbs_rows020231026_010001.sql free_dbs_rows020231220_010001.sql
free_dbs_rows020230505_054949.sql free_dbs_rows020230708_010001.sql free_dbs_rows020230901_010002.sql free_dbs_rows020231027_010002.sql free_dbs_rows020231221_010002.sql
free_dbs_rows020230509_065556.sql free_dbs_rows020230709_010001.sql free_dbs_rows020230902_010001.sql free_dbs_rows020231028_010001.sql free_dbs_rows020231222_010001.sql
free_dbs_rows020230510_010001.sql free_dbs_rows020230710_010001.sql free_dbs_rows020230903_010001.sql free_dbs_rows020231029_010001.sql free_dbs_rows020231223_010001.sql
free_dbs_rows020230517_010002.sql free_dbs_rows020230711_010002.sql free_dbs_rows020230904_010001.sql free_dbs_rows020231030_010002.sql free_dbs_rows020231224_010002.sql
free_dbs_rows020230518_010001.sql free_dbs_rows020230712_010002.sql free_dbs_rows020230905_010002.sql free_dbs_rows020231031_010001.sql free_dbs_rows020231225_010001.sql
free_dbs_rows020230519_010001.sql free_dbs_rows020230713_010002.sql free_dbs_rows020230906_010001.sql free_dbs_rows020231101_010001.sql free_dbs_rows020231226_010001.sql
free_dbs_rows020230520_010002.sql free_dbs_rows020230714_010001.sql free_dbs_rows020230907_010001.sql free_dbs_rows020231102_010002.sql free_dbs_rows020231227_010001.sql
free_dbs_rows020230521_010001.sql free_dbs_rows020230715_010001.sql free_dbs_rows020230908_010001.sql free_dbs_rows020231103_010001.sql free_dbs_rows020231228_010002.sql
free_dbs_rows020230522_010001.sql free_dbs_rows020230716_010001.sql free_dbs_rows020230909_010002.sql free_dbs_rows020231104_010001.sql free_dbs_rows020231229_010001.sql
free_dbs_rows020230523_010002.sql free_dbs_rows020230717_010001.sql free_dbs_rows020230910_010001.sql free_dbs_rows020231105_010002.sql free_dbs_rows020231230_010002.sql
free_dbs_rows020230524_010001.sql free_dbs_rows020230718_010001.sql free_dbs_rows020230911_010002.sql free_dbs_rows020231106_010001.sql free_dbs_rows020231231_010001.sql
free_dbs_rows020230525_010001.sql free_dbs_rows020230719_010001.sql free_dbs_rows020230912_010001.sql free_dbs_rows020231107_010001.sql free_dbs_rows020240101_010001.sql
free_dbs_rows020230526_010002.sql free_dbs_rows020230720_010001.sql free_dbs_rows020230913_010001.sql free_dbs_rows020231108_010001.sql free_dbs_rows020240102_010001.sql
free_dbs_rows020230527_010001.sql free_dbs_rows020230721_010001.sql free_dbs_rows020230914_010001.sql free_dbs_rows020231109_010001.sql free_dbs_rows020240103_010002.sql
free_dbs_rows020230528_010001.sql free_dbs_rows020230722_010001.sql free_dbs_rows020230915_010001.sql free_dbs_rows020231110_010001.sql free_dbs_rows020240104_010001.sql
free_dbs_rows020230529_010001.sql free_dbs_rows020230723_010001.sql free_dbs_rows020230916_010001.sql free_dbs_rows020231111_010001.sql free_dbs_rows020240105_010001.sql
free_dbs_rows020230530_010001.sql free_dbs_rows020230724_010001.sql free_dbs_rows020230917_010001.sql free_dbs_rows020231112_010001.sql free_dbs_rows020240106_010001.sql
free_dbs_rows020230531_010001.sql free_dbs_rows020230725_010001.sql free_dbs_rows020230918_010001.sql free_dbs_rows020231113_010001.sql free_dbs_rows020240107_010001.sql
free_dbs_rows020230601_010001.sql free_dbs_rows020230726_010001.sql free_dbs_rows020230919_010002.sql free_dbs_rows020231114_010001.sql free_dbs_rows020240108_010001.sql
free_dbs_rows020230602_010001.sql free_dbs_rows020230727_010001.sql free_dbs_rows020230920_010001.sql free_dbs_rows020231115_010001.sql free_dbs_rows020240109_010001.sql
free_dbs_rows020230603_010001.sql free_dbs_rows020230728_010001.sql free_dbs_rows020230921_010001.sql free_dbs_rows020231116_010002.sql free_dbs_rows020240110_010001.sql
free_dbs_rows020230604_010001.sql free_dbs_rows020230729_010001.sql free_dbs_rows020230922_010001.sql free_dbs_rows020231117_010001.sql free_dbs_rows020240111_010001.sql
free_dbs_rows020230605_010001.sql free_dbs_rows020230730_010001.sql free_dbs_rows020230923_010002.sql free_dbs_rows020231118_010001.sql free_dbs_rows020240112_010001.sql
free_dbs_rows020230606_010002.sql free_dbs_rows020230731_010001.sql free_dbs_rows020230925_010001.sql free_dbs_rows020231119_010001.sql free_dbs_rows020240113_010002.sql
free_dbs_rows020230607_010001.sql free_dbs_rows020230801_010002.sql free_dbs_rows020230926_010001.sql free_dbs_rows020231120_010002.sql free_dbs_rows020240114_010001.sql
free_dbs_rows020230608_010001.sql free_dbs_rows020230802_010002.sql free_dbs_rows020230927_010002.sql free_dbs_rows020231121_010001.sql free_dbs_rows020240115_010002.sql
free_dbs_rows020230609_010002.sql free_dbs_rows020230803_010002.sql free_dbs_rows020230928_010002.sql free_dbs_rows020231122_010002.sql free_dbs_rows020240116_010001.sql
free_dbs_rows020230610_010001.sql free_dbs_rows020230804_010002.sql free_dbs_rows020230929_010001.sql free_dbs_rows020231123_010002.sql free_dbs_rows020240117_010001.sql
free_dbs_rows020230611_010002.sql free_dbs_rows020230805_010001.sql free_dbs_rows020230930_010001.sql free_dbs_rows020231124_010002.sql free_dbs_rows020240118_010001.sql
free_dbs_rows020230612_010001.sql free_dbs_rows020230806_010001.sql free_dbs_rows020231001_010001.sql free_dbs_rows020231125_010001.sql free_dbs_rows020240119_010002.sql
free_dbs_rows020230613_010001.sql free_dbs_rows020230807_010001.sql free_dbs_rows020231002_010001.sql free_dbs_rows020231126_010001.sql free_dbs_rows020240120_010001.sql
free_dbs_rows020230614_010002.sql free_dbs_rows020230808_010001.sql free_dbs_rows020231003_010002.sql free_dbs_rows020231127_010001.sql free_dbs_rows020240121_010001.sql
free_dbs_rows020230615_010001.sql free_dbs_rows020230809_010001.sql free_dbs_rows020231004_010001.sql free_dbs_rows020231128_010001.sql free_dbs_rows020240122_010002.sql
free_dbs_rows020230616_010001.sql free_dbs_rows020230810_010001.sql free_dbs_rows020231005_010001.sql free_dbs_rows020231129_010001.sql hdr35
free_dbs_rows020230617_010002.sql free_dbs_rows020230811_010001.sql free_dbs_rows020231006_010002.sql free_dbs_rows020231130_010001.sql load_fragments.cron
free_dbs_rows020230618_010001.sql free_dbs_rows020230812_010001.sql free_dbs_rows020231007_010001.sql free_dbs_rows020231201_010001.sql load_fragments.log
free_dbs_rows020230619_010001.sql free_dbs_rows020230813_010002.sql free_dbs_rows020231008_010001.sql free_dbs_rows020231202_010001.sql load_fragments.sh
free_dbs_rows020230620_010002.sql free_dbs_rows020230814_010002.sql free_dbs_rows020231009_010001.sql free_dbs_rows020231203_010001.sql ontape_sec.sh
free_dbs_rows020230621_010001.sql free_dbs_rows020230815_010001.sql free_dbs_rows020231010_010001.sql free_dbs_rows020231204_010001.sql profile.jxz1
free_dbs_rows020230622_010001.sql free_dbs_rows020230816_010001.sql free_dbs_rows020231011_010001.sql free_dbs_rows020231205_010002.sql rebuild_area_table20230505_054949.sql
free_dbs_rows020230623_010002.sql free_dbs_rows020230817_010001.sql free_dbs_rows020231012_010001.sql free_dbs_rows020231206_010001.sql rebuild_area_table20230509_065556.sql
free_dbs_rows020230624_010001.sql free_dbs_rows020230818_010001.sql free_dbs_rows020231013_010001.sql free_dbs_rows020231207_010001.sql soft
free_dbs_rows020230625_010001.sql free_dbs_rows020230819_010001.sql free_dbs_rows020231014_010002.sql free_dbs_rows020231208_010002.sql
free_dbs_rows020230626_010001.sql free_dbs_rows020230820_010002.sql free_dbs_rows020231015_010002.sql free_dbs_rows020231209_010001.sql
[root@JXZ-PCS gbasedbt]# cd excel_sql
[root@JXZ-PCS excel_sql]# lss
-bash: lss: command not found
[root@JXZ-PCS excel_sql]# ls
alalog1.sql alalog2.sql point1.sql point2.sql
[root@JXZ-PCS excel_sql]# pwd
/home/gbasedbt/excel_sql
[root@JXZ-PCS excel_sql]# cd ~
[root@JXZ-PCS ~]# source
-bash: source: filename argument required
source: usage: source filename [arguments]
[root@JXZ-PCS ~]#
[root@JXZ-PCS ~]# source .bash
-bash: .bash: 没有那个文件或目录
[root@JXZ-PCS ~]#
[root@JXZ-PCS ~]#
[root@JXZ-PCS ~]#
[root@JXZ-PCS ~]# dbaccess scadadb -
-bash: dbaccess: command not found
[root@JXZ-PCS ~]# source .bash
.bash_logout .bash_profile .bashrc
[root@JXZ-PCS ~]# source .bashrc
-bash: PROMPT_COMMAND: readonly variable
[root@JXZ-PCS ~]# dbaccess scadadb -
-bash: dbaccess: command not found
[root@JXZ-PCS ~]# source .bash_profile
-bash: PROMPT_COMMAND: readonly variable
[root@JXZ-PCS ~]# dbaccess scadadb -
-bash: dbaccess: command not found
[root@JXZ-PCS ~]# su - gbasedbt
User Failures Last failure Host
[gbasedbt@JXZ-PCS ~]$ dbaccess scadadb -
bash: dbaccess: command not found
[gbasedbt@JXZ-PCS ~]$ source .bash
.bash_logout .bash_profile .bashrc
[gbasedbt@JXZ-PCS ~]$ source .
./ ../ .bash_logout .bash_profile .bashrc .emacs .gnome2/ .mozilla/ .rhosts .viminfo
[gbasedbt@JXZ-PCS ~]$ source .bashrc
bash: PROMPT_COMMAND: readonly variable
[gbasedbt@JXZ-PCS ~]$ source .bash_profile
bash: PROMPT_COMMAND: readonly variable
[gbasedbt@JXZ-PCS ~]$
[gbasedbt@JXZ-PCS ~]$ dbaccess --
[gbasedbt@JXZ-PCS ~]$
[gbasedbt@JXZ-PCS ~]$
[gbasedbt@JXZ-PCS ~]$
[gbasedbt@JXZ-PCS ~]$
[gbasedbt@JXZ-PCS ~]$
[gbasedbt@JXZ-PCS ~]$
[gbasedbt@JXZ-PCS ~]$ dbaccess scadadb -
???á
> dbaccess scadadb /home/gbasedbt/excel_sql/alalog2.sql
> dbaccess scadadb /home/gbasedbt/excel_sql/point2.sql
> select * from ANALOG_FES_FAT_CHECK_EXPORT1 into outfile '/home/gbasedbt/excel_sql/1.txt'
> select * from POINT_FES_FAT_CHECK_EXPORT1 into outfile '/home/gbasedbt/excel_sql/2.txt'
> ^C[gbasedbt@JXZ-PCS ~]$
[gbasedbt@JXZ-PCS ~]$
[gbasedbt@JXZ-PCS ~]$ cd excel_sql
[gbasedbt@JXZ-PCS excel_sql]$ ls
alalog1.sql alalog2.sql point1.sql point2.sql
[gbasedbt@JXZ-PCS excel_sql]$ dbaccess scadadb -
???á
> select * from ANALOG_FES_FAT_CHECK_EXPORT1
> ^C[gbasedbt@JXZ-PCS excel_sql]$
[gbasedbt@JXZ-PCS excel_sql]$
[gbasedbt@JXZ-PCS excel_sql]$
[gbasedbt@JXZ-PCS excel_sql]$
[gbasedbt@JXZ-PCS excel_sql]$
[gbasedbt@JXZ-PCS excel_sql]$
[gbasedbt@JXZ-PCS excel_sql]$ onstat -
GBase Database Server Version 12.10.FC4G1AEE -- On-Line -- Up 93 days 16:49:35 -- 15263004 Kbytes
[gbasedbt@JXZ-PCS excel_sql]$
[gbasedbt@JXZ-PCS excel_sql]$
[gbasedbt@JXZ-PCS excel_sql]$
[gbasedbt@JXZ-PCS excel_sql]$
[gbasedbt@JXZ-PCS excel_sql]$ dbassecc --
bash: dbassecc: command not found
[gbasedbt@JXZ-PCS excel_sql]$ dbassecc - -
bash: dbassecc: command not found
[gbasedbt@JXZ-PCS excel_sql]$ dbaccess scadadb -
???á
> select * from sysmaster
> ^C[gbasedbt@JXZ-PCS excel_sql]$ ^C
[gbasedbt@JXZ-PCS excel_sql]$
[gbasedbt@JXZ-PCS excel_sql]$
[gbasedbt@JXZ-PCS excel_sql]$
[gbasedbt@JXZ-PCS excel_sql]$
[gbasedbt@JXZ-PCS excel_sql]$
[gbasedbt@JXZ-PCS excel_sql]$
[gbasedbt@JXZ-PCS excel_sql]$
[gbasedbt@JXZ-PCS excel_sql]$ dbaccess scadadb -
???á
>
>
> ^C[gbasedbt@JXZ-PCS excel_sql]$ exit
exit
[root@JXZ-PCS ~]# su - gbasedbt
User Failures Last failure Host
[gbasedbt@JXZ-PCS ~]$ dbaccess scadadb -
bash: dbaccess: command not found
[gbasedbt@JXZ-PCS ~]$
[gbasedbt@JXZ-PCS ~]$
[gbasedbt@JXZ-PCS ~]$ onstat -
bash: onstat: command not found
[gbasedbt@JXZ-PCS ~]$ onstat -
bash: onstat: command not found
[gbasedbt@JXZ-PCS ~]$
[gbasedbt@JXZ-PCS ~]$
[gbasedbt@JXZ-PCS ~]$ source .bash_profile
bash: PROMPT_COMMAND: readonly variable
[gbasedbt@JXZ-PCS ~]$ onstat -
GBase Database Server Version 12.10.FC4G1AEE -- On-Line -- Up 93 days 17:00:02 -- 15263004 Kbytes
[gbasedbt@JXZ-PCS ~]$
[gbasedbt@JXZ-PCS ~]$
[gbasedbt@JXZ-PCS ~]$
[gbasedbt@JXZ-PCS ~]$
[gbasedbt@JXZ-PCS ~]$
[gbasedbt@JXZ-PCS ~]$
[gbasedbt@JXZ-PCS ~]$
[gbasedbt@JXZ-PCS ~]$
[gbasedbt@JXZ-PCS ~]$
[gbasedbt@JXZ-PCS ~]$
[gbasedbt@JXZ-PCS ~]$
[gbasedbt@JXZ-PCS ~]$
[gbasedbt@JXZ-PCS ~]$
[gbasedbt@JXZ-PCS ~]$
[gbasedbt@JXZ-PCS ~]$ exit
exit
[root@JXZ-PCS ~]# su - gbasedbt
User Failures Last failure Host
[gbasedbt@JXZ-PCS ~]$ onstat -
bash: onstat: command not found
[gbasedbt@JXZ-PCS ~]$ source .bash_profile
bash: PROMPT_COMMAND: readonly variable
[gbasedbt@JXZ-PCS ~]$ onstat -
GBase Database Server Version 12.10.FC4G1AEE -- On-Line -- Up 93 days 17:21:01 -- 15263004 Kbytes
[gbasedbt@JXZ-PCS ~]$
[gbasedbt@JXZ-PCS ~]$
[gbasedbt@JXZ-PCS ~]$
[gbasedbt@JXZ-PCS ~]$
[gbasedbt@JXZ-PCS ~]$ cd excel_sql
[gbasedbt@JXZ-PCS excel_sql]$ ls
alalog1.sql alalog2.sql point1.sql point2.sql
[gbasedbt@JXZ-PCS excel_sql]$ dbaccess scadadb alalog2.sql
???á
??
34389: Illegal character has been found in the input string.
????
[gbasedbt@JXZ-PCS excel_sql]$ echo "select * from ANALOG_FES_FAT_CHECK_EXPORT1 into outfile '/home/gbasedbt/excel_sql/1.txt'" | dbaccess scadadb
???á
201: ?
1
57 ?
????
[gbasedbt@JXZ-PCS excel_sql]$ ls
alalog1.sql alalog2.sql point1.sql point2.sql
[gbasedbt@JXZ-PCS excel_sql]$ echo "select * from ANALOG_FES_FAT_CHECK_EXPORT1 " | dbaccess scadadb
???á
206: ?? "analog_fes_fat_check_export1" ?С
111: ISAM ?κμ?
1
44 ?
????
[gbasedbt@JXZ-PCS excel_sql]$ echo "select * from ANALOG_FES_FAT_CHECK_EXPORT1 into outfile '/home/gbasedbt/excel_sql/1.txt'" >> 1.sql
[gbasedbt@JXZ-PCS excel_sql]$ cat 1.sql
select * from ANALOG_FES_FAT_CHECK_EXPORT1 into outfile '/home/gbasedbt/excel_sql/1.txt'
[gbasedbt@JXZ-PCS excel_sql]$
[gbasedbt@JXZ-PCS excel_sql]$
[gbasedbt@JXZ-PCS excel_sql]$
[gbasedbt@JXZ-PCS excel_sql]$ dbaccess scadadb 1.sql
???á
201: ?
1
57 ?
????
[gbasedbt@JXZ-PCS excel_sql]$ echo "unload to '/home/gbasedbt/1.dat' delimiter','select * from area;" | dbaccess scadadb
???á
809: SQL ?
1
34 ?
????
[gbasedbt@JXZ-PCS excel_sql]$
[gbasedbt@JXZ-PCS excel_sql]$
[gbasedbt@JXZ-PCS excel_sql]$
[gbasedbt@JXZ-PCS excel_sql]$
[gbasedbt@JXZ-PCS excel_sql]$
[gbasedbt@JXZ-PCS excel_sql]$
[gbasedbt@JXZ-PCS excel_sql]$
[gbasedbt@JXZ-PCS excel_sql]$
[gbasedbt@JXZ-PCS excel_sql]$
[gbasedbt@JXZ-PCS excel_sql]$
[gbasedbt@JXZ-PCS excel_sql]$
[gbasedbt@JXZ-PCS excel_sql]$ echo "unload to '/home/gbasedbt/excel_sql/l.txt' delimiter ',' select * from ANALOG_FES_FAT_CHECK_EXPORT1 " | dbaccess scadadb
???á
206: ?? "analog_fes_fat_check_export1" ?С
111: ISAM ?κμ?
2
0 ?
????
[gbasedbt@JXZ-PCS excel_sql]$ echo "unload to '/home/gbasedbt/jb/l.txt' delimiter ',' select * from area " | dbaccess scadadb
???á
ж 12 С
????
[gbasedbt@JXZ-PCS excel_sql]$ ls
1.sql alalog1.sql alalog2.sql l.txt point1.sql point2.sql
[gbasedbt@JXZ-PCS excel_sql]$ cat 1.txt
cat: 1.txt: 没有那个文件或目录
[gbasedbt@JXZ-PCS excel_sql]$
[gbasedbt@JXZ-PCS excel_sql]$ cat
1.sql alalog1.sql alalog2.sql l.txt point1.sql point2.sql
[gbasedbt@JXZ-PCS excel_sql]$ cat 1.sql
1.sql alalog1.sql alalog2.sql l.txt point1.sql point2.sql
[gbasedbt@JXZ-PCS excel_sql]$ cat 1.sql
1.sql alalog1.sql alalog2.sql l.txt point1.sql point2.sql
[gbasedbt@JXZ-PCS excel_sql]$ cat 1.sql
select * from ANALOG_FES_FAT_CHECK_EXPORT1 into outfile '/home/gbasedbt/excel_sql/1.txt'
[gbasedbt@JXZ-PCS excel_sql]$ cat l.txt
9,
2,
456,
1,
56,
11,
0,
6,
111,
11,
51,
99,
[gbasedbt@JXZ-PCS excel_sql]$ dbaccess scadadb alalog2.sql
1.sql alalog1.sql alalog2.sql l.txt point1.sql point2.sql
[gbasedbt@JXZ-PCS excel_sql]$ dbaccess scadadb alalog2.sql
???á
??
34389: Illegal character has been found in the input string.
????
[gbasedbt@JXZ-PCS excel_sql]$ dbaccess scadadb alalog1.sql
???á
??
34389: Illegal character has been found in the input string.
????
[gbasedbt@JXZ-PCS excel_sql]$
[gbasedbt@JXZ-PCS excel_sql]$
[gbasedbt@JXZ-PCS excel_sql]$
[gbasedbt@JXZ-PCS excel_sql]$ exit
exit
[root@JXZ-PCS ~]# exit
logout
Connection to 173.1.16.87 closed.
root@ubuntu:~# cd /home/
root@ubuntu:/home# ls
excel_sql.tar jb.tar ubuntu
root@ubuntu:/home# scp jb.tar root@173.1.16.87:/home/gbasedbt
root@173.1.16.87's password:
jb.tar 100% 28KB 27.5KB/s 00:00
root@ubuntu:/home# ssh root@173.1.16.87
root@173.1.16.87's password:
Last login: Mon Jan 22 10:16:02 2024 from 173.1.16.88
User Failures Last failure Host
[root@JXZ-PCS ~]# cd /home/gbasedbt/
[root@JXZ-PCS gbasedbt]# tar xvf jb.tar
jb/
jb/1.sql
jb/1A.sql
jb/2.sql
jb/2A.sql
[root@JXZ-PCS gbasedbt]# cd jb
[root@JXZ-PCS jb]# cd ~
[root@JXZ-PCS ~]# source .bash
.bash_logout .bash_profile .bashrc
[root@JXZ-PCS ~]# source .bash
.bash_logout .bash_profile .bashrc
[root@JXZ-PCS ~]# source .bash
.bash_logout .bash_profile .bashrc
[root@JXZ-PCS ~]# source .bash_profile
-bash: PROMPT_COMMAND: readonly variable
[root@JXZ-PCS ~]# cd jb
-bash: cd: jb: 没有那个文件或目录
[root@JXZ-PCS ~]# su - gbasedbt
User Failures Last failure Host
[gbasedbt@JXZ-PCS ~]$
[gbasedbt@JXZ-PCS ~]$ source .bash_profile
bash: PROMPT_COMMAND: readonly variable
[gbasedbt@JXZ-PCS ~]$ cd jb
[gbasedbt@JXZ-PCS jb]$ ls
1A.sql 1.sql 2A.sql 2.sql
[gbasedbt@JXZ-PCS jb]$ dbaccess scadadb 1A.sql
???á
??
???
????
[gbasedbt@JXZ-PCS jb]$
[gbasedbt@JXZ-PCS jb]$
[gbasedbt@JXZ-PCS jb]$
[gbasedbt@JXZ-PCS jb]$ dbaccess scadadb 2A.sql
???á
??
???
????
[gbasedbt@JXZ-PCS jb]$ echo "unload to '/home/gbasedbt/jb/1A.txt' delimiter ',' select * from ANALOG_FES_FAT_CHECK_EXPORT1 " | dbaccess scadadb
???á
ж 826 С
????
[gbasedbt@JXZ-PCS jb]$ echo "unload to '/home/gbasedbt/jb/2A.txt' delimiter ',' select * from POINT_FES_FAT_CHECK_EXPORT1 " | dbaccess scadadb
???á
ж 812 С
????
[gbasedbt@JXZ-PCS jb]$
[gbasedbt@JXZ-PCS jb]$
[gbasedbt@JXZ-PCS jb]$
[gbasedbt@JXZ-PCS jb]$ LS
bash: LS: command not found
[gbasedbt@JXZ-PCS jb]$ ls
1A.sql 1.sql 2A.sql 2.sql
[gbasedbt@JXZ-PCS jb]$ cd /home/gbasedbt/excel_sql/
[gbasedbt@JXZ-PCS excel_sql]$ ls
1.sql 2A.txt alalog1.sql alalog2.sql lA.txt l.txt point1.sql point2.sql
[gbasedbt@JXZ-PCS excel_sql]$ ls -athl
总用量 256K
-rw-rw-r-- 1 gbasedbt gbasedbt 89K 1月 22 11:54 2A.txt
drwxrwxrwx 2 root root 4.0K 1月 22 11:54 .
-rw-rw-r-- 1 gbasedbt gbasedbt 97K 1月 22 11:52 lA.txt
drwxr-xr-x 9 gbasedbt gbasedbt 20K 1月 22 11:48 ..
-rw-rw-r-- 1 gbasedbt gbasedbt 45 1月 22 11:38 l.txt
-rw-rw-r-- 1 gbasedbt gbasedbt 89 1月 22 11:07 1.sql
-rwxrwxrwx 1 root root 4.5K 1月 22 09:37 point2.sql
-rwxrwxrwx 1 root root 4.5K 1月 22 09:37 point1.sql
-rwxrwxrwx 1 root root 7.8K 1月 22 09:37 alalog2.sql
-rwxrwxrwx 1 root root 7.8K 1月 22 09:37 alalog1.sql
[gbasedbt@JXZ-PCS excel_sql]$ tar czvf NB.tar.gz 2A.txt lA.txt
2A.txt
lA.txt
[gbasedbt@JXZ-PCS excel_sql]$ ls -athl
总用量 280K
-rw-rw-r-- 1 gbasedbt gbasedbt 24K 1月 22 11:56 NB.tar.gz
drwxrwxrwx 2 root root 4.0K 1月 22 11:56 .
-rw-rw-r-- 1 gbasedbt gbasedbt 89K 1月 22 11:54 2A.txt
-rw-rw-r-- 1 gbasedbt gbasedbt 97K 1月 22 11:52 lA.txt
drwxr-xr-x 9 gbasedbt gbasedbt 20K 1月 22 11:48 ..
-rw-rw-r-- 1 gbasedbt gbasedbt 45 1月 22 11:38 l.txt
-rw-rw-r-- 1 gbasedbt gbasedbt 89 1月 22 11:07 1.sql
-rwxrwxrwx 1 root root 4.5K 1月 22 09:37 point2.sql
-rwxrwxrwx 1 root root 4.5K 1月 22 09:37 point1.sql
-rwxrwxrwx 1 root root 7.8K 1月 22 09:37 alalog2.sql
-rwxrwxrwx 1 root root 7.8K 1月 22 09:37 alalog1.sql
[gbasedbt@JXZ-PCS excel_sql]$ pwd
/home/gbasedbt/excel_sql
[gbasedbt@JXZ-PCS excel_sql]$ exit
exit
[root@JXZ-PCS ~]# exit
logout
Connection to 173.1.16.87 closed.
root@ubuntu:/home# scp root@173.1.16.88:/home/gbasedbt/excel_sql/NB.tar.gz .
The authenticity of host '173.1.16.88 (173.1.16.88)' can't be established.
ECDSA key fingerprint is 8c:ea:23:21:dc:72:93:2d:29:f1:f5:0c:30:50:05:24.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added '173.1.16.88' (ECDSA) to the list of known hosts.
root@173.1.16.88's password:
Permission denied, please try again.
root@173.1.16.88's password:
Permission denied, please try again.
root@173.1.16.88's password:
root@ubuntu:/home# scp root@173.1.16.87:/home/gbasedbt/excel_sql/NB.tar.gz .
root@173.1.16.87's password:
NB.tar.gz 100% 24KB 23.8KB/s 00:00
root@ubuntu:/home#
root@ubuntu:/home#
root@ubuntu:/home#
root@ubuntu:/home#
root@ubuntu:/home#
root@ubuntu:/home# NB.tar.gz