Início / user-77485

Melih's questions

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

Eu recebi um erro quando tento alterar a string até a data.

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)

como posso converter para data de '03.05.2010 00:00'? Obrigado

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

Eu uso o oráculo 12c. Eu tento conceder todos os privilégios de todas as tabelas para um usuário. E no futuro não preciso adicionar nenhum privilégio a esse usuário. Eu tenho que fazer isso. Não quero conceder tabelas do sistema a esse usuário. Eu escrevi o comando pl/sql. mas dá erro.

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

Qual é o erro? obrigado.

Eu uso 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

Eu tento limpar alguns arquivos no oracle. Eu uso adrc. Desejo limpar os arquivos de rastreamento no arquivo do ouvinte. Mas não é trabalho. Eu não sei por quê.

[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 ainda cheio com 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

Atualizamos o sistema rac e gostaria de perguntar, posso excluir a grade antiga e a versão do banco de dados?

[oracle@orcl1 app]$ cd

11.2.0.3/     12.1.0.2/     Middleware/   oraInventory/

11.2.0.4/     grid/         oracle/       swlib/

Eu quero perguntar se posso deletar manualmente "rm command line command"11.2.0.3/ e 11.2.0.4 grid files... oracle/product/11.2.0.3 database...

Esse é o meu inventário.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>

EDIT: Comecei a ferramenta de desinstalação em 11.2.0.3 .. Não quero excluir a grade 12.1.0.2, mas acho que pode excluir a grade de 12.1.0.2. certo?

######################### 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

Eu tento instalar o galera no sistema ubuntu 14.04. Já tem mariadb e está funcionando. Como posso instalá-lo?

meu comando:

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

dá erro

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

Tentei importar o trabalho, mas meu comando nohup parece não funcionar.

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:

Eu digitei a senha, mas não está respondendo. Abro outro terminal e conecto lá. Não consigo ver nenhum nohup quando procuro arquivos ps -ef|grep nohup. O que devo fazer? obrigado.

mysql mariadb