主页 / user-77485

Melih's questions

Martin Hope
Melih
Asked: 2017-03-11 03:23:43 +0800 CST
  • 0

当我尝试将字符串更改为最新时出现错误。

mysql> select STR_TO_DATE('03.05.2010 00:00','%d.%m.%Y %h:%i');
+--------------------------------------------------+
| STR_TO_DATE('03.05.2010 00:00','%d.%m.%Y %h:%i') |
+--------------------------------------------------+
| NULL                                             |
+--------------------------------------------------+
1 row in set, 2 warnings (0,00 sec)

我怎样才能转换为日期'03.05.2010 00:00'？谢谢

mysql date-format
Martin Hope
Melih
Asked: 2015-11-14 01:12:06 +0800 CST
  • 5

我使用oracle 12c。我尝试将所有表的所有权限授予用户。将来我不需要为该用户添加任何权限。我需要这样做。我不想将系统表授予该用户。我写了 pl/sql 命令。但它给出了错误。

BEGIN
  2  FOR t IN (select * from dba_tables where owner not like '%SYS%' AND owner not like '%ADMIN%' AND iot_type IS NULL)
  3  LOOP
  4  EXECUTE IMMEDIATE 'GRANT ALL PRIVILEGES ON '|| t.owner ||'.' || t.table_name ||' TO GGSTEST';
  5  END LOOP;
  6  END;
  7  /
BEGIN
*
ERROR at line 1:
ORA-00905: missing keyword
ORA-06512: at line 4

错误是什么？谢谢。

我使用 dbms_print

GRANT ALL ON OUTLN.OL$ TO GGSTEST
GRANT ALL ON OUTLN.OL$HINTS TO GGSTEST
GRANT ALL ON OUTLN.OL$NODES TO GGSTEST
GRANT ALL ON DBSNMP.BSLN_BASELINES TO GGSTEST
GRANT ALL ON APEX_040200.WWV_FLOW_LOG_HISTORY TO GGSTEST
GRANT ALL ON DBSNMP.BSLN_METRIC_DEFAULTS TO GGSTEST
GRANT ALL ON XDB.XDB$ROOT_INFO TO GGSTEST
GRANT ALL ON XDB.XDB$XDB_READY TO GGSTEST
GRANT ALL ON XDB.XDB$CDBPORTS TO GGSTEST
GRANT ALL ON XDB.XDB$IMPORT_TT_INFO TO GGSTEST
GRANT ALL ON XDB.XDB$TTSET TO GGSTEST
GRANT ALL ON XDB.XDB$H_INDEX TO GGSTEST
GRANT ALL ON XDB.XDB$D_LINK TO GGSTEST
GRANT ALL ON XDB.XDB$COLUMN_INFO TO GGSTEST
GRANT ALL ON XDB.XDB$PATH_INDEX_PARAMS TO GGSTEST
GRANT ALL ON XDB.X$NM7UJB7VOLFE92KV0GUML7K0LVSF TO GGSTEST
GRANT ALL ON XDB.X$QN7UJB7VOLFE92KV0GUML7K0LVSF TO GGSTEST
GRANT ALL ON XDB.X$PT7UJB7VOLFE92KV0GUML7K0LVSF TO GGSTEST
GRANT ALL ON XDB.APP_USERS_AND_ROLES TO GGSTEST
GRANT ALL ON XDB.APP_ROLE_MEMBERSHIP TO GGSTEST
GRANT ALL ON XDB.XDB$DBFS_VIRTUAL_FOLDER TO GGSTEST
BEGIN
*
ERROR at line 1:
ORA-00905: missing keyword
ORA-06512: at line 4
oracle plsql
Martin Hope
Melih
Asked: 2015-11-03 04:46:53 +0800 CST
  • 0

我尝试清除 oracle 中的一些文件。我用adrci。我想清除侦听器文件中的跟踪文件。但这是行不通的。我不知道为什么。

[grid@orcl1 app]$ adrci

adrci> set homepath diag/tnslsnr/orcl1/listener
adrci> purge -age 360 -type alert
adrci> purge -age 60 -type trace
adrci> purge -age 1 -type trace
adrci> exit

Tracefile 仍然充满 4.9 GB。

[root@orcl1 trace]# ls -alh
total 4.9G
drwxr-xr-x  2 grid oinstall 4.0K Nov  2 12:43 .
drwxr-xr-x 14 grid oinstall 4.0K May  7 14:48 ..
-rw-r-----  1 grid oinstall  43M Aug 28  2014 listener_backup_20140828.log.bz2
-rw-r-----  1 grid oinstall 4.8G Nov  2 12:43 listener.log
[root@orcl1 trace]# pwd
/u01/app/grid/diag/tnslsnr/orcl1/listener/trace
oracle listener
Martin Hope
Melih
Asked: 2015-11-03 00:40:50 +0800 CST
  • 0

我们升级了rac系统，我想问一下，我可以删除旧的网格和数据库版本吗？

[oracle@orcl1 app]$ cd

11.2.0.3/     12.1.0.2/     Middleware/   oraInventory/

11.2.0.4/     grid/         oracle/       swlib/

我想问我可以手动删除“rm 命令行命令”11.2.0.3/ 和 11.2.0.4 网格文件... oracle/product/11.2.0.3 数据库 ...

那是我的 inventory.xml

<?xml version="1.0" standalone="yes" ?>

<!-- Copyright (c) 1999, 2014, Oracle and/or its affiliates.

All rights reserved. -->

<!-- Do not modify the contents of this file by hand. -->

<INVENTORY>

<VERSION_INFO>

   <SAVED_WITH>12.1.0.2.0</SAVED_WITH>

   <MINIMUM_VER>2.1.0.6.0</MINIMUM_VER>

</VERSION_INFO>

<HOME_LIST>

<HOME NAME="OraDb11203_home1" LOC="/u01/app/oracle/product/11.2.0.3/dbhome_1" TYPE="O" IDX="2">

   <NODE_LIST>

      <NODE NAME="orcl1"/>

      <NODE NAME="orcl2"/>

   </NODE_LIST>

</HOME>

<HOME NAME="OraDb12102_home1" LOC="/u01/app/oracle/product/12.1.0.2/dbhome_1" TYPE="O" IDX="5">

   <NODE_LIST>

      <NODE NAME="orcl1"/>

      <NODE NAME="orcl2"/>

   </NODE_LIST>

</HOME>

<HOME NAME="OraGrid12102" LOC="/u01/app/12.1.0.2/grid" TYPE="O" IDX="4" CRS="true"/>

<HOME NAME="OraGrid11gR3" LOC="/u01/app/11.2.0.3/grid" TYPE="O" IDX="1" REMOVED="T"/>

<HOME NAME="OraGrid11gR204" LOC="/u01/app/11.2.0.4/grid" TYPE="O" IDX="3" REMOVED="T"/>

</HOME_LIST>

<COMPOSITEHOME_LIST>

</COMPOSITEHOME_LIST>

</INVENTORY>

编辑：我在 11.2.0.3 开始卸载工具。我不想删除网格 12.1.0.2，但我认为它可以删除 12.1.0.2 的网格。正确的？

######################### CHECK OPERATION START #########################
## [START] Install check configuration ##


Checking for existence of the Oracle home location /u01/app/oracle/product/11.2.0.3/dbhome_1
Oracle Home type selected for deinstall is: Oracle Real Application Cluster Database
Oracle Base selected for deinstall is: /u01/app/oracle
Checking for existence of central inventory location /u01/app/oraInventory
Checking for existence of the Oracle Grid Infrastructure home /u01/app/12.1.0.2/grid
The following nodes are part of this cluster: orcl1,orcl2
Checking for sufficient temp space availability on node(s) : 'orcl1,orcl2'

## [END] Install check configuration ##


Network Configuration check config START

Network de-configuration trace file location: /u01/app/oraInventory/logs/netdc_check2015-11-02_08-53-27-AM.log

Network Configuration check config END

Database Check Configuration START

Database de-configuration trace file location: /u01/app/oraInventory/logs/databasedc_check2015-11-02_08-53-29-AM.log

Use comma as separator when specifying list of values as input

Specify the list of database names that are configured in this Oracle home []:
oracle oracle-11g-r2
Martin Hope
Melih
Asked: 2015-10-29 01:03:51 +0800 CST
  • 0

我尝试在 ubuntu 14.04 系统上安装 galera。它已经有了 mariadb 并且正在运行。我该如何安装它？

我的命令：

sudo apt-get install -y rsync galera-3 mariadb-galera-server

它给出了错误

Reading package lists... Done
Building dependency tree       
Reading state information... Done
rsync is already the newest version.
Some packages could not be installed. This may mean that you have
requested an impossible situation or if you are using the unstable
distribution that some required packages have not yet been created
or been moved out of Incoming.
The following information may help to resolve the situation:

The following packages have unmet dependencies:
 mariadb-galera-server : Depends: mariadb-galera-server-5.5 (= 5.5.46+maria-1~trusty) but it is not going to be installed
E: Unable to correct problems, you have held broken packages.
mysql mariadb
Martin Hope
Melih
Asked: 2015-10-23 23:08:04 +0800 CST
  • 1

我尝试导入作业，但我的 nohup 命令似乎不起作用。

devinim@koha-db57:~/kohaaktarim$ nohup mysql -u root -p kohadata < kohaaktarim.sql &
[1] 9619
devinim@koha-db57:~/kohaaktarim$ nohup: appending output to ‘nohup.out’


[1]+  Stopped                 nohup mysql -u root -p kohadata < kohaaktarim.sql
devinim@koha-db57:~/kohaaktarim$ jobs
[1]+  Stopped                 nohup mysql -u root -p kohadata < kohaaktarim.sql
devinim@koha-db57:~/kohaaktarim$ gf
gf: command not found
devinim@koha-db57:~/kohaaktarim$ fg
nohup mysql -u root -p kohadata < kohaaktarim.sql
Enter password:

我输入了密码，但它没有响应。我打开另一个终端并连接到那里。我搜索时看不到任何 nohup ps -ef|grep nohup。我应该怎么办？谢谢。

mysql mariadb