Devops Engineer

When you want to use 16k for db_block_size, you need to use "Custom Database" option. Otherwise it will not allow you to create 16k database.

默认OEM 连接： https://主机名:1158/em 启动：emctl start dbconsole 停止：emctl stop dbconsole check: emctl status dbconsole 启动时报错： TZ set to America/New_york OC4J Configuration issue ./u01/app/oracle/product/10.1.0/db_1/oc4j/j2ee/OC4J_DBConsole_orcl.us.oracle.com not found 原因：环境变量ORACLE_SID / ORACLE_HOME没有配置 错误二：因为修改操作系统的时区 解决方案： emctl stop agent emctl status agent emctl resetTZ agent Login via sqlplus as sysman exec mgmt_target.set_agent_tzrg n( oracle- ga:39382, Europe/Lju bljana ) commit; restart EM Pasted from: < http://www.experts-exchange.com/Database/Oracle/Q_24364706.html > 重新配置dbconsole的步骤 1. restart server; 2. unlock account sysman sql>alter user sysman account unlock; 3. delete the setting emca -deconfig dbcontrol db  -repos drop 4. rebuild the setting  emca -config dbcon trol db -repos create Check the log file during the rebuild:  C:\oracle\cfgtoollogs\emca\<sid> 如果过程中报错： 1. ORA-20001: SYSMAN already exists.. 需先...

1. 安装 oracle 服务器 端； 2. 可选装oracle客户端； 3. 创建 数据库 ； 4. 使用net manager配置listener； 注意：修改HOSTS文件，将系统\计算机名中的计算机名称。例如: 计算机名称：abc-def HOSTS中写入： 127.0.0.1   abc-def 然后配置服务名称，监听程序时主机名称用abc-def 5. 在环境变量中设置ORACLE_HOME=D:\oracle\product\10.2.0\db_1 6. 编辑sqlnet.ora文件，增加：SQLNET.AUTHENTICATION_SERVICES= (NTS) 7. 停止所有oracle服务， 安装 补丁10.2.0.4 8. 调整系统参数PATH配置

ORACLE 11g R2 WINDOWS 1. 在ORACLE安装路径：D:\app\Administrator\product\11.2.0\dbhome_1\deinstall 2. 双击deinstall.bat文件，ORACLE会自动卸载； 3. 重启服务器，再删除剩余文件夹即可。 相关说明： http://www.oracle.com/pls/db112/portal.portal_db?selected=11&frame = ORACLE 10g Linux 删除$ORACLE_BASE所在文件夹 删除/etc下两个以"ora"开头的文件

Oracle9i Database Release 2 Enterprise/Standard/Personal Edition for Windows NT/2000/XP http://download.oracle.com/otn/nt/oracle9i/9201/92010NT_Disk1.zip http://download.oracle.com/otn/nt/oracle9i/9201/92010NT_Disk2.zip http://download.oracle.com/otn/nt/oracle9i/9201/92010NT_Disk3.zip Oracle9i Database Release 2 Enterprise/Standard/Personal/Client Edition for Windows XP 2003/Windows Server 2003 (64-bit) http://download.oracle.com/otn/nt/oracle9i/9202/92021Win64_Disk1.zip http://download.oracle.com/otn/nt/oracle9i/9202/92021Win64_Disk2.zip Oracle9i Database Release 2 Enterprise/Standard Edition for Intel Linux http://download.oracle.com/otn/linux/oracle9i/9204/ship_9204_linux_disk1.cpio.gz http://download.oracle.com/otn/linux/oracle9i/9204/ship_9204_linux_disk2.cpio.gz http://download.oracle.com/otn/linux/oracle9i/9204/ship_9204_linux_disk3.cpio.gz Oracle9i Database Release 2 (9.2.0.4) Enterprise/Standard Edition for Linux x86-64 http://download.oracle.com/otn/linux/oracle9i...

windows服务器 64位服务器安装客户端，需要安装ORACLE 32位客户端

Recommondation: 1. Since the first fixpack (11.2.0.2) of ORACLE 11gR2, ORACLE fixpack is a complete ORACLE version. Install it in new path. After it use Database Upgrade Assistant to update database. Resaon: If the update failed, the orginal folder or database will not impact. 2. The time of upgrade is slow. Therefore if the database is prod region, please prepare carefully.  

Moving From Standard Edition to Enterprise Edition If you have a Standard Edition database at a release earlier than the new Oracle  Database 11g release, then you can change it to an Enterprise Edition database by  installing Enterprise Edition and following the normal upgrade procedures, as  described in this guide. To change your existing Standard Edition database to an Enterprise Edition database 1. Ensure that the release number of your Standard Edition server software is the  same release as Enterprise Edition server software. For example, if your Standard Edition server software is release 11.1.0.6, then you  must upgrade to release 11.1.0.6 of Enterprise Edition. 2. Shut down your database. 3. If your operating system is Windows, then stop all Oracle services, including the  OracleServiceSID Oracle service, where SID is the instance name. 4. Deinstall Standard Edition server software.  Run the deinstall tool from the Oracle ...

Oracle Version: Oracle  12.1.0.1.0 x86-64 OS Version: RHEL 5.5 x86-64 Download install media from  www.oracle.com upload to RHEL system /tmp unzip the media set hostname as 12C (/etc/hosts; /etc/sysconfig/network) Install packages binutils-2.17.50.0.6 compat-libstdc++-33-3.2.3 compat-libstdc++-33-3.2.3 (32 bit) gcc-4.1.2 gcc-c++-4.1.2 glibc-2.5-58 glibc-2.5-58 (32 bit) glibc-devel-2.5-58 glibc-devel-2.5-58 (32 bit) ksh libaio-0.3.106 libaio-0.3.106 (32 bit) libaio-devel-0.3.106 libaio-devel-0.3.106 (32 bit) libgcc-4.1.2 libgcc-4.1.2 (32 bit) libstdc++-4.1.2 libstdc++-4.1.2 (32 bit) libstdc++-devel 4.1.2 libXext-1.0.1 libXext-1.0.1 (32 bit) libXtst-1.0.1 libXtst-1.0.1 (32 bit) libX11-1.0.3 libX11-1.0.3 (32 bit) libXau-1.0.1 libXau-1.0.1 (32 bit) libXi-1.0.1 libXi-1.0.1 (32 bit) make-3.81 sysstat-7.0.2 unixODBC unixODBC-devel Change configuration files 1. /etc/sysctl.conf Add following...

1. 下载额外的安装包和补丁： http://oss.oracle.com/projects/compat-oracle/files/RedHat/ compat-libcwait-2.1-1.i386.rpm http://www.opennet.ru/soft/ora_inst/ p2617419_220_GENERIC.zip p3006854_9204_LINUX.zip p3238244_9204_LINUX.zip 2. 安装准备： a. 修改文件/etc/sysctl.conf 添加内容如下： # Oracle kernel.shmmax = 1073741824 kernel.shmmni = 4096 kernel.shmall = 1048576 # semaphores: semmsl, semmns, semopm, semmni kernel.sem = 250 32000 100 128 fs.file-max = 65536 net.ipv4.ip_local_port_range = 1024 65000 使修改生效：/sbin/sysctl -p b. 修改文件/etc/security/limits.conf 添加内容如下： oracle soft nofile 65536 oracle hard nofile 65536 oracle soft nproc 16384 oracle hard nproc 16384 c. 安装Linux自带的RPM包 compat-db compat-gcc* compat-libcwait compat-libgcc* compat-libstdc++* gcc gcc-c++ libaio libaio-devel make libXp libXp-devel giflib glib openmotif openmotif-devel xorg-x11-deprecated-libs-devel xorg-x11-deprecated-libs libpng gtk+ d. 安装额外的补丁： 打p3006854_9204_LINUX.zip #...