1.只有承认无知，才能装下新的东西； 2.进步来自一点点滴滴的积累； 3.广博让你更优秀，而专业让你无法替代； 4.挫折和失败能够转换为一种财富。
访问量(1038096) 积分(1523) 等级(核心会员) 排名(6)
oracle@ORACLE ~]$ sqlplus /nolog SQL> conn /as sysdba; SQL>select userenv(‘language’) from dual; --查看服务端字符集 SQL>SHUTDOWN IMMEDIATE --关闭数据库 SQL>STARTUP MOUNT --启动到 Mount SQL>ALTER SYSTEM ENABLE RESTRICTED SESSION; SQL>ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0; SQL>ALTER SYSTE
2024-04-24 09:55 580 2
oracle ORA-12514错误 su - oracle sqlplus / as sysdba show parameter local_listener; alter system set local_listener='(ADDRESS = (PROTOCOL = TCP)(HOST = xx.xxx.xxx.xxx)(PORT = 1521))';
2023-10-25 13:40 636 0
安装完数据库后自动启动EM，也可通过如下命令启停和查看 --启动 SQL> exec DBMS_XDB_CONFIG.SETHTTPSPORT(5500); PL/SQL procedure successfully completed. --停止 exec DBMS_XDB_CONFIG.SETHTTPSPORT(0); --检查 SQL> select dbms_xdb_config.gethttpsport FROM DUAL; GETHTTPSPORT ------------ 5500 访问地...
2023-09-01 10:49 929 0
[root@was01 ~]# su - oracle Last login: Tue Aug 8 17:06:37 CST 2023 on pts/0 [oracle@was01 ~]$ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Wed Aug 9 03:22:05 2023 Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle. All rights reserved. Connected to an idle instanc
2023-08-09 14:11 699 0
If manually executing "sqlplus / as sysdba", then sqlpus will not return any message and hung. From ps command result, there are no background processes generated. The user id/group settings and permission for $ORACLE_HOME/bin/oracle at the issue node are same with the normal node. strac
2023-07-21 09:00 869 0
Shutdown immediate hung and then shut abort was issues to kill the instance.Later, database “startup nomount” statement got hung. strace -aeftT -o /tmp/strace_startup.txt sqlplus /nolog SQL> conn / as sysdba SQL> startup nomount Kill crsd.bin on the problematic node and this will respawn t
2023-07-14 09:14 790 0
因为误操作， 节点1 chown -R oracle:oinstall /u01 这个目录下包含了grid 集群软件。 在node02节点 chmod 755 permission.pl cd /tmp ./permission.pl /u01 会在node02节点生成restore-perm- .cmd文件 在node01节点 chmod 755 restore-perm-<timestamp>.cmd vi restore-perm-<timestamp>.cmd :%s#xxx2#xxx1#g :%s#+ASM2...
2023-07-14 09:01 771 0
select a.file#,a.name,a.bytes/1024/1024 CurrentMB, ceil(HWM * a.block_size)/1024/1024 ResizeTo, (a.bytes - HWM * a.block_size)/1024/1024 ReleaseMB, 'alter database datafile '''||a.name||''' resize '|| ceil(HWM * a.block_size/1024/1024) || 'M;' ResizeCMD
2023-05-18 09:22 904 0
ORACLE 19C DG 由于DG备机宕机，导致DG无法启动 备机: SQL> startup ORACLE instance started. Total System Global Area 2.1475E+10 bytes Fixed Size 19524680 bytes Variable Size 2550136832 bytes Database Buffers 1.8858E+10 bytes Redo Buffers 47583232 bytes
2023-05-10 11:02 900 1
oracle查看正在执行的SQL_ID SELECT sql_id, hash_value, SUBSTR(sql_text,1,40) Text FROM v$sql WHERE sql_text LIKE '%&An_Identifiable_String%'; select a.sid, a.serial#, a.paddr, a.machine, nvl(a.sql_id, a.prev_sql_id) sql_id, b.sql_text, b.sql_fulltext,
2023-04-21 18:42 979 0
#!/bin/bash ############################################################################################################### # Script name: truncate_data_365.sh # Script description: truncation partition table remain 365 day. # Current Release Version: 1.0.0 # Script Owner: hbhe0316 # Latest ed
2023-04-21 08:31 822 0
create table ash0420 as select * from dba_hist_active_sess_history a where a.SAMPLE_TIME between to_date('2023-04-19 07:00:00', 'yyyy-mm-dd hh24:mi:ss') and to_date('2023-04-19 07:30:00', 'yyyy-mm-dd hh24:mi:ss'); export ORACLE_PDB_SID=PDB01 expdp /'/ as sysdba/' directory=ORADATA dumpfile=as
2023-04-20 14:21 921 0
set linesize 260 pagesize 1000; col h0 for 999 col h1 for 999; col h2 for 999; col h3 for 999; col h4 for 999; col h5 for 999; col h6 for 999; col h7 for 999; col h8 for 999; col h9 for 999; col h10 for 999; col h11 for 999; col h12 for 999; col h13 for 999; col h14 for 9
2023-04-19 13:14 761 0
[oracle@rac01 ~]$ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Mon Apr 17 08:11:46 2023 Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle. All rights reserved. Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.3.0.0.0
2023-04-17 08:12 798 0
1.查看该表是否可以做在线重定义 SQL> exec dbms_redefinition.can_redef_table('HBHE', 'FUNCTION_LOG'); PL/SQL procedure successfully completed. 2.创建分区结构的中间分区表 -- Create table create table HBHE.FUNCTION_LOG_1 ( id NVARCHAR2(36) not null, controller NVARCHAR2(100) not null, actio...
2023-04-14 08:09 809 0
CNDBA社区
