手机网站 php,微信app下载安装官方版2022,网站管理后台地址怎么查询,如何开外贸公司创业介质准备#xff1a; 数据库23ai
https://edelivery.oracle.com
上述网站下载基础版本#xff0c;本次未使用。
本次是安装了带补丁的版本#xff1a;
Database Release Update 23.6.0.24.10 GoldImage表示带补丁用于直接安装的软件包
查找888.1对应Primary Note for …介质准备 数据库23ai
https://edelivery.oracle.com
上述网站下载基础版本本次未使用。
本次是安装了带补丁的版本
Database Release Update 23.6.0.24.10 GoldImage表示带补丁用于直接安装的软件包
查找888.1对应Primary Note for Database Quarterly Release Updates (Doc ID 888.1) 操作系统8以上的版本
Oracle Linux ISOs | Oracle, Software. Hardware. Complete. 基本准备
配置/etc/selinux/config sed -i s/SELINUXenforcing/SELINUXdisabled/g /etc/selinux/config cat /etc/selinux/config
关闭防火墙 systemctl status firewalld.service systemctl stop firewalld.service systemctl disable firewalld.service systemctl status firewalld.service 依赖包安装
https://yum.oracle.com/repo/OracleLinux/OL8/appstream/x86_64/getPackage/oracle-database-preinstall-23ai-1.0-2.el8.x86_64.rpm
[rootora23ai ~]# dnf install wget
[rootora23ai ~]# wget https://yum.oracle.com/repo/OracleLinux/OL8/appstream/x86_64/getPackage/oracle-database-preinstall-23ai-1.0-2.el8.x86_64.rpm
[rootora23ai ~]# rpm -ivh oracle-database-preinstall-23ai-1.0-2.el8.x86_64.rpm [rootora23ai ~]# dnf install -y oracle-database-preinstall-23ai*
以上步骤安装了oracle用户和组
创建目录
[rootora23ai ~]# mkdir -p /u01/app/oracle [rootora23ai ~]# mkdir -p /u01/app/oracle/product/23/db_1 [rootora23ai ~]# chown -R oracle:oinstall /u01/app/oracle
环境变量
[oracleora23ai ~]$ more .bash_profile export ORACLE_SIDora23ai #数据库database.rsp中的SID export ORACLE_BASE/u01/app/oracle #BASE目录 export ORACLE_HOME/u01/app/oracle/product/23/db_1 #oracle安装包的目录 export PATH/u01/app/oracle/product/23/db_1/bin:/u01/app/oracle/product/23/db_1/OPatch:/home/oracle/.local/bin:/home/oracle/bin:/usr/local/bin:/usr/bin:/usr/local/sbin:/usr/sbin export TNS_ADMIN/network/admin export LD_LIBRARY_PATH/lib:/lib32:/lib/usr/lib:/usr/local/lib export TEMP/tmp export TMP/tmp export LC_ALLen_US.UTF-8 export LANGen_US.UTF-8 export NLS_LANGAMERICAN_AMERICA.ZHS16GBK [oracleora23ai ~]$
传文件到$ORACLE_HOME
[oracleora23ai ~]$ cd /u01/app/oracle/product/23/db_1/ [oracleora23ai db_1]$ ll total 0 [oracleora23ai db_1]$ ll total 2178076 -rw-r--r--. 1 root root 2230348508 Dec 18 15:50 p37037908_230000_Linux-x86-64-23.6.0.24.10.zip [oracleora23ai db_1]$ pwd /u01/app/oracle/product/23/db_1
[oracleora23ai db_1]$unzip p37037908_230000_Linux-x86-64-23.6.0.24.10.zip
[rootora23ai ~]# chown -R oracle:oinstall /u01/app/
准备安装db软件脚本
[oracleora23ai db_1]$ cat /home/oracle/db_install.rsp EOF
oracle.install.responseFileVersion/oracle/install/rspfmt_dbinstall_response_schema_v23.0.0
oracle.install.optionINSTALL_DB_SWONLY
UNIX_GROUP_NAMEoinstall
INVENTORY_LOCATION/u01/app/oraInventory
ORACLE_HOME/u01/app/oracle/product/23/db_1
ORACLE_BASE/u01/app/oracle
oracle.install.db.InstallEditionEE
oracle.install.db.OSDBA_GROUPdba
oracle.install.db.OSOPER_GROUPdba
oracle.install.db.OSBACKUPDBA_GROUPdba
oracle.install.db.OSDGDBA_GROUPdba
oracle.install.db.OSKMDBA_GROUPdba
oracle.install.db.OSRACDBA_GROUPdba
oracle.install.db.rootconfig.executeRootScript
oracle.install.db.rootconfig.configMethod
oracle.install.db.rootconfig.sudoPath
oracle.install.db.rootconfig.sudoUserName
oracle.install.db.CLUSTER_NODES
oracle.install.db.config.starterdb.typeGENERAL_PURPOSE
oracle.install.db.config.starterdb.globalDBNameora23ai
oracle.install.db.config.starterdb.SIDora23ai
oracle.install.db.ConfigureAsContainerDB
oracle.install.db.config.PDBName
oracle.install.db.config.starterdb.characterSetZHS16GBK
oracle.install.db.config.starterdb.memoryOption
oracle.install.db.config.starterdb.memoryLimit
oracle.install.db.config.starterdb.installExampleSchemas
oracle.install.db.config.starterdb.password.ALLOra23ai_202412
oracle.install.db.config.starterdb.password.SYSOra23ai_202412
oracle.install.db.config.starterdb.password.SYSTEMOra23ai_202412
oracle.install.db.config.starterdb.password.DBSNMPOra23ai_202412
oracle.install.db.config.starterdb.password.PDBADMINOra23ai_202412
oracle.install.db.config.starterdb.managementOption
oracle.install.db.config.starterdb.omsHost
oracle.install.db.config.starterdb.omsPort
oracle.install.db.config.starterdb.emAdminUser
oracle.install.db.config.starterdb.emAdminPassword
oracle.install.db.config.starterdb.enableRecovery
oracle.install.db.config.starterdb.storageType
oracle.install.db.config.starterdb.fileSystemStorage.dataLocation
oracle.install.db.config.starterdb.fileSystemStorage.recoveryLocation
oracle.install.db.config.asm.diskGroup
oracle.install.db.config.asm.ASMSNMPPassword
EOF
执行安装db软件操作
[oracleora23ai db_1]$ ./runInstaller -silent -responseFile /home/oracle/db_install.rsp -ignorePrereq -J-Doracle.install.db.validate.supportedOSCheckfalse Launching Oracle Database Setup Wizard...
[WARNING] [INS-13014] Target environment does not meet some optional requirements. CAUSE: Some of the optional prerequisites are not met. See logs for details. installActions2024-12-23_04-24-20PM.log. ACTION: Identify the list of failed prerequisite checks from the log: installActions2024-12-23_04-24-20PM.log. Then either from the log file or from installation manual find the appropriate configuration to meet the prerequisites and fix it manually. The response file for this session can be found at: /u01/app/oracle/product/23/db_1/install/response/db_2024-12-23_04-24-20PM.rsp
You can find the log of this install session at: /tmp/InstallActions2024-12-23_04-24-20PM/installActions2024-12-23_04-24-20PM.log As a root user, run the following script(s): 1. /u01/app/oraInventory/orainstRoot.sh 2. /u01/app/oracle/product/23/db_1/root.sh
Run /u01/app/oraInventory/orainstRoot.sh on the following nodes: [ora23ai] Run /u01/app/oracle/product/23/db_1/root.sh on the following nodes: [ora23ai] Successfully Setup Software with warning(s). Moved the install session logs to: /u01/app/oraInventory/logs/InstallActions2024-12-23_04-24-20PM [oracleora23ai db_1]$ [oracleora23ai db_1]$ cd /u01/app/oracle/admin/ora23ai/scripts -bash: cd: /u01/app/oracle/admin/ora23ai/scripts: No such file or directory
生成建库脚本 [oracleora23ai db_1]$ dbca -silent -generateScripts -templateName General_Purpose.dbc \ -gdbname ora23ai -sid ora23ai \ -characterSet AL32UTF8 -datafileDestination /u01/app/oracle/oradata \ -memoryPercentage 50 -emConfiguration LOCAL
Prepare for db operation 10% complete Copying database files 40% complete Creating and starting Oracle instance 42% complete 46% complete 50% complete 54% complete 60% complete Completing Database Creation 64% complete 67% complete 70% complete Executing Post Configuration Actions 100% complete The generation of the script /u01/app/oracle/admin/ora23ai/scripts is successful. Look at the log file /u01/app/oracle/cfgtoollogs/dbca/ora23ai/ora23ai.log for further details. [oracleora23ai db_1]$ [oracleora23ai db_1]$ cd /u01/app/oracle/admin/ora23ai/scripts [oracleora23ai scripts]$ ll total 18364 -rw-r-----. 1 oracle oinstall 3224 Dec 23 16:30 cloneDBCreation.sql -rw-r-----. 1 oracle oinstall 1061 Dec 23 16:30 CloneRmanRestore.sql -rw-r-----. 1 oracle oinstall 2025 Dec 23 16:30 init.ora -rw-r-----. 1 oracle oinstall 2034 Dec 23 16:30 initora23aiTempOMF.ora -rw-r-----. 1 oracle oinstall 2159 Dec 23 16:30 initora23aiTemp.ora -rw-r-----. 1 oracle oinstall 853 Dec 23 16:30 lockAccount.sql -rwxr-x---. 1 oracle oinstall 745 Dec 23 16:30 ora23ai.sh -rw-r-----. 1 oracle oinstall 562 Dec 23 16:30 ora23ai.sql -rw-r-----. 1 oracle oinstall 891 Dec 23 16:30 postDBCreation.sql -rw-r-----. 1 oracle oinstall 1468 Dec 23 16:30 postScripts.sql -rw-r-----. 1 oracle oinstall 897 Dec 23 16:30 rmanRestoreDatafiles.sql -rw-r-----. 1 oracle oinstall 18759680 Dec 23 16:30 tempControl.ctl 修改三个文件init*.ora,增加参数_exadata_feature_ontrue
[oracleora23ai scripts]$ grep exadata *.ora init.ora:_exadata_feature_ontrue initora23aiTempOMF.ora:_exadata_feature_ontrue initora23aiTemp.ora:_exadata_feature_ontrue
执行建库
[oracleora23ai scripts]$ nohup ./ora23ai.sh ./ora23ai.log [1] 31143 [oracleora23ai scripts]$ nohup: ignoring input and redirecting stderr to stdout
[oracleora23ai scripts]$ [oracleora23ai scripts]$ [oracleora23ai scripts]$ [oracleora23ai scripts]$ tail -f ora23ai.log 创建监听
[oracleora23ai ~]$ netca -silent -responsefile /u01/app/oracle/product/23/db_1/assistants/netca/netca.rsp
Parsing command line arguments: Parameter silent true Parameter responsefile /u01/app/oracle/product/23/db_1/assistants/netca/netca.rsp Done parsing command line arguments. Oracle Net Services Configuration: ProfileException: Could not save Profile: TNS-04415: File i/o error caused by: java.io.FileNotFoundException: /network/admin/sqlnet.ora (No such file or directory) Profile configuration complete. ListenerException: Could not save listener: TNS-04415: File i/o error caused by: java.io.FileNotFoundException: /network/admin/listener.ora (No such file or directory) Oracle Net Listener Startup: Running Listener Control: /u01/app/oracle/product/23/db_1/bin/lsnrctl start LISTENER Listener Control complete. Listener started successfully. Listener configuration complete. Oracle Net Services configuration successful. The exit code is 0 [oracleora23ai ~]$ lsnrctl status
LSNRCTL for Linux: Version 23.0.0.0.0 - for Oracle Cloud and Engineered Systems on 24-DEC-2024 10:07:29
Copyright (c) 1991, 2024, Oracle. All rights reserved.
Connecting to (ADDRESS(PROTOCOLtcp)(HOST)(PORT1521)) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 23.0.0.0.0 - for Oracle Cloud and Engineered Systems Start Date 24-DEC-2024 10:06:58 Uptime 0 days 0 hr. 0 min. 30 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Log File /u01/app/oracle/diag/tnslsnr/ora23ai/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION(ADDRESS(PROTOCOLtcp)(HOSTora23ai)(PORT1521))) The listener supports no services The command completed successfully
起库检查
[oracleora23ai scripts]$ sqlplus / as sysdba
SQL*Plus: Release 23.0.0.0.0 - for Oracle Cloud and Engineered Systems on Mon Dec 23 16:45:59 2024 Version 23.6.0.24.10
Copyright (c) 1982, 2024, Oracle. All rights reserved. Connected to: Oracle Database 23ai Enterprise Edition Release 23.0.0.0.0 - for Oracle Cloud and Engineered Systems Version 23.6.0.24.10
SQL show pdbs; CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ WRITE YES SQL select comp_id, status from dba_registry;
COMP_ID ------------------------------------------------------------ STATUS ---------------------- CATALOG VALID
CATPROC VALID
RAC OPTION OFF COMP_ID ------------------------------------------------------------ STATUS ---------------------- JAVAVM VALID
XML VALID
CATJAVA VALID COMP_ID ------------------------------------------------------------ STATUS ---------------------- APS VALID
XDB VALID
OWM VALID COMP_ID ------------------------------------------------------------ STATUS ---------------------- CONTEXT VALID
XOQ VALID
SDO VALID COMP_ID ------------------------------------------------------------ STATUS ---------------------- OLS VALID
DV VALID 14 rows selected.
SQL set line 160 SQL set wrap off SQL r 1* select comp_id, status from dba_registry
COMP_ID STATUS ------------------------------------------------------------ ---------------------- CATALOG VALID CATPROC VALID RAC OPTION OFF JAVAVM VALID XML VALID CATJAVA VALID APS VALID XDB VALID OWM VALID CONTEXT VALID XOQ VALID
COMP_ID STATUS ------------------------------------------------------------ ---------------------- SDO VALID OLS VALID DV VALID
14 rows selected.
SQL show pdbs; CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ WRITE YES
SQL !ls -l /u01/app/oracle/oradata/ORA23AI total 2394956 -rw-r-----. 1 oracle oinstall 18759680 Dec 23 16:48 control01.ctl -rw-r-----. 1 oracle oinstall 18759680 Dec 23 16:48 control02.ctl drwxr-x---. 2 oracle oinstall 85 Dec 23 16:39 pdbseed -rw-r-----. 1 oracle oinstall 209715712 Dec 23 16:48 redo01.log -rw-r-----. 1 oracle oinstall 209715712 Dec 23 16:39 redo02.log -rw-r-----. 1 oracle oinstall 209715712 Dec 23 16:39 redo03.log -rw-r-----. 1 oracle oinstall 639639552 Dec 23 16:45 sysaux01.dbf -rw-r-----. 1 oracle oinstall 1111498752 Dec 23 16:44 system01.dbf -rw-r-----. 1 oracle oinstall 20979712 Dec 23 16:39 temp01.dbf -rw-r-----. 1 oracle oinstall 26222592 Dec 23 16:44 undotbs01.dbf -rw-r-----. 1 oracle oinstall 7348224 Dec 23 16:39 users01.dbf
SQL create pluggable database ora23aipdb01 admin user ora23aipdb01 identified by Ora23ai_202412 file_name_convert(/u01/app/oracle/oradata/ORA23AI/pdbseed,/u01/app/oracle/oradata/ora23aipdb01);
Pluggable database created.
SQL show pdbs; CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ WRITE YES 3 ORA23AIPDB01 MOUNTED SQL alter pluggable database ORA23AIPDB01 open instancesall;
Pluggable database altered.
SQL show pdbs; CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ WRITE YES 3 ORA23AIPDB01 READ WRITE NO SQL alter pluggable database all open save state instancesall; alter pluggable database all open save state instancesall * ERROR at line 1: ORA-03049: SQL keyword SAVE is not syntactically valid following ...pluggable database all open Help: https://docs.oracle.com/error-help/db/ora-03049/ SQL alter pluggable database all save state instancesall;
Pluggable database altered.
SQL shutdown immediate Database closed. Database dismounted. ORACLE instance shut down. SQL startup ORA-01078: failure in processing system parameters LRM-00109: could not open parameter file /u01/app/oracle/product/23/db_1/dbs/initora23ai.ora [oracleora23ai scripts]$ cp init.ora /u01/app/oracle/product/23/db_1/dbs/initora23ai.ora [oracleora23ai scripts]$ sqlplus / as sysdba
SQL*Plus: Release 23.0.0.0.0 - for Oracle Cloud and Engineered Systems on Mon Dec 23 16:53:24 2024 Version 23.6.0.24.10
Copyright (c) 1982, 2024, Oracle. All rights reserved.
Connected to an idle instance.
SQL startup ORACLE instance started.
Total System Global Area 3805934600 bytes Fixed Size 5428232 bytes Variable Size 754974720 bytes Database Buffers 3036676096 bytes Redo Buffers 8855552 bytes Database mounted. Database opened. SQL show parameter name;
NAME TYPE ------------------------------------ ---------------------- VALUE ------------------------------ cdb_cluster_name string
cell_offloadgroup_name string
db_file_name_convert string
db_name string ora23ai db_unique_name string
NAME TYPE ------------------------------------ ---------------------- VALUE ------------------------------ ora23ai global_names boolean FALSE instance_name string ora23ai lock_name_space string
log_file_name_convert string NAME TYPE ------------------------------------ ---------------------- VALUE ------------------------------ pdb_file_name_convert string
processor_group_name string
service_names string ora23ai SQL show pdbs; CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO 3 ORA23AIPDB01 READ WRITE NO SQL select * from v$version;
BANNER -------------------------------------------------------------------------------- BANNER_FULL -------------------------------------------------------------------------------- BANNER_LEGACY -------------------------------------------------------------------------------- CON_ID ---------- Oracle Database 23ai Enterprise Edition Release 23.0.0.0.0 - for Oracle Cloud an d Engineered Systems Oracle Database 23ai Enterprise Edition Release 23.0.0.0.0 - for Oracle Cloud an d Engineered Systems Version 23.6.0.24.10
BANNER -------------------------------------------------------------------------------- BANNER_FULL -------------------------------------------------------------------------------- BANNER_LEGACY -------------------------------------------------------------------------------- CON_ID ---------- Oracle Database 23ai Enterprise Edition Release 23.0.0.0.0 - for Oracle Cloud an d Engineered Systems 0 SQL alter session set containerORA23AIPDB01;
Session altered.
SQL select name from v$tablespace;
NAME ------------------------------------------------------------ SYSTEM SYSAUX UNDOTBS1 TEMP
SQL select name from v$datafile;
NAME -------------------------------------------------------------------------------- /u01/app/oracle/oradata/ora23aipdb01/system01.dbf /u01/app/oracle/oradata/ora23aipdb01/sysaux01.dbf /u01/app/oracle/oradata/ora23aipdb01/undotbs01.dbf
SQL create tablespace jyc datafile /u01/app/oracle/oradata/ora23aipdb01/jyc01.dbf size 10M autoextend on next 1M;
Tablespace created.
SQL set line 160 SQL set wrap off SQL select TABLESPACE_NAME,BIGFILE from dba_tablespaces;
TABLESPACE_NAME BIGFIL ------------------------------------------------------------ ------ SYSTEM YES SYSAUX YES UNDOTBS1 YES TEMP NO JYC YES
SQL conn / as sysdba Connected. SQL select TABLESPACE_NAME,BIGFILE from dba_tablespaces;
TABLESPACE_NAME BIGFIL ------------------------------------------------------------ ------ SYSTEM YES SYSAUX YES UNDOTBS1 YES TEMP NO USERS YES
SQL select userenv(language) from dual;
USERENV(LANGUAGE) -------------------------------------------------------------------------------------------------------- AMERICAN_AMERICA.AL32UTF8
SQL alter session set containerORA23AIPDB01;
Session altered.
SQL select userenv(language) from dual;
USERENV(LANGUAGE) -------------------------------------------------------------------------------------------------------- AMERICAN_AMERICA.AL32UTF8 [oracleora23ai ~]$ sqlplus ora23aipdb01/Ora23ai_202412192.168.207.132:1521/ora23aipdb01
SQL*Plus: Release 23.0.0.0.0 - for Oracle Cloud and Engineered Systems on Tue Dec 24 10:20:27 2024 Version 23.6.0.24.10
Copyright (c) 1982, 2024, Oracle. All rights reserved. Connected to: Oracle Database 23ai Enterprise Edition Release 23.0.0.0.0 - for Oracle Cloud and Engineered Systems Version 23.6.0.24.10
SQL select name from v$datafile; select name from v$datafile * ERROR at line 1: ORA-00942: table or view SYS.V_$DATAFILE does not exist Help: https://docs.oracle.com/error-help/db/ora-00942/ SQL select * from v$datafile; select * from v$datafile * ERROR at line 1: ORA-00942: table or view SYS.V_$DATAFILE does not exist Help: https://docs.oracle.com/error-help/db/ora-00942/ SQL create table test(id int); create table test(id int) * ERROR at line 1: ORA-01031: insufficient privileges Help: https://docs.oracle.com/error-help/db/ora-01031/ SQL select object_name from user_objects;
no rows selected
SQL conn / as sysdba Connected. SQL show pdbs; CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO 3 ORA23AIPDB01 READ WRITE NO SQL alter session set containerORA23AIPDB01;
Session altered.
SQL grant dba to ora23aipdb01;
Grant succeeded.
SQL exit Disconnected from Oracle Database 23ai Enterprise Edition Release 23.0.0.0.0 - for Oracle Cloud and Engineered Systems Version 23.6.0.24.10 [oracleora23ai ~]$ sqlplus ora23aipdb01/Ora23ai_202412192.168.207.132:1521/ora23aipdb01
SQL*Plus: Release 23.0.0.0.0 - for Oracle Cloud and Engineered Systems on Tue Dec 24 10:22:34 2024 Version 23.6.0.24.10
Copyright (c) 1982, 2024, Oracle. All rights reserved.
Last Successful login time: Tue Dec 24 2024 10:20:27 08:00
Connected to: Oracle Database 23ai Enterprise Edition Release 23.0.0.0.0 - for Oracle Cloud and Engineered Systems Version 23.6.0.24.10
SQL select name from v$datafile;
NAME -------------------------------------------------------------------------------- /u01/app/oracle/oradata/ora23aipdb01/system01.dbf /u01/app/oracle/oradata/ora23aipdb01/sysaux01.dbf /u01/app/oracle/oradata/ora23aipdb01/undotbs01.dbf /u01/app/oracle/oradata/ora23aipdb01/jyc01.dbf
SQL create table test(id int);
Table created.
SQL show user; USER is ORA23AIPDB01 SQL show pdbs; SP2-0382: The SHOW PDBS command is not available Help: https://docs.oracle.com/error-help/db/sp2-0382/ SQL 相关参考
exadata介质的Oracle23ai在银河麒麟v10sp3上面的安装过程
oracle11glinux7.x快速静默安装_specify a instance name that starts with an alphab-CSDN博客
CentOS8.5安装Oracle23ai_oracle23ai安装-CSDN博客
oracle 23ai23.5.0.24.07完整功能版安装体验 – 提供7*24专业数据库(Oracle,SQL Server,MySQL,PostgreSQL等)恢复和技术支持Tel:17813235971 - 惜分飞
