Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

installing 19c database

Tony007Mar 2 2021

hi am having this issue when installing 19c database in solaris
installing 19c database
root@username:/u01/soft# sudo pkg install oracle-database-preinstall-19c

pkg install: The following pattern(s) did not match any allowable packages. Try
using a different matching pattern, or refreshing publisher information:

oracle-database-preinstall-19c  

pkg info entire
Name: entire
Summary: Incorporation to lock all system packages to the same build
Description: This package constrains system package versions to the same
build. WARNING: Proper system update and correct package
selection depend on the presence of this incorporation.
Removing this package will result in an unsupported system.
Category: Meta Packages/Incorporations
State: Installed
Publisher: solaris
Version: 11.4 (Oracle Solaris 11.4.0.0.1.15.0)
Branch: 11.4.0.0.1.15.0
Packaging Date: Fri Aug 17 00:42:03 2018
Size: 2.53 kB
FMRI: pkg://solaris/entire@11.4-11.4.0.0.1.15.0:20180817T004203Z
sudo pkg set-publisher \
> -k pkg.oracle.com.key.pem \
> -c pkg.oracle.com.certificate.pem \
> -G "*" -g https://pkg.oracle.com/ha-cluster/release ha-cluster
root@username:/u01/soft# pkg publisher ha-cluster | grep Mirror
root@username:/u01/soft# pkg list -a 'pkg://ha-cluster/*'
NAME (PUBLISHER) VERSION IFO
ha-cluster/data-service/apache (ha-cluster) 4.4-0.21.0 ---
ha-cluster/data-service/dhcp (ha-cluster) 4.4-0.1.0 --o
ha-cluster/data-service/dns (ha-cluster) 4.4-0.21.0 ---
ha-cluster/data-service/glassfish-message-queue (ha-cluster) 4.4-0.21.0 ---
ha-cluster/data-service/goldengate (ha-cluster) 4.4-0.21.0 ---
ha-cluster/data-service/ha-zones (ha-cluster) 4.4-0.21.0 ---
ha-cluster/data-service/iplanet-web-server (ha-cluster) 4.4-0.21.0 ---
ha-cluster/data-service/mysql (ha-cluster) 4.4-0.21.0 ---
ha-cluster/data-service/nfs (ha-cluster) 4.4-0.21.0 ---
ha-cluster/data-service/oracle-database (ha-cluster) 4.4-0.21.0 ---
ha-cluster/data-service/oracle-external-proxy (ha-cluster) 4.4-0.21.0 ---
ha-cluster/data-service/oracle-fmw (ha-cluster) 4.4-0.21.0 ---
ha-cluster/data-service/oracle-http-server (ha-cluster) 4.4-0.21.0 ---
ha-cluster/data-service/oracle-pmn-server (ha-cluster) 4.4-0.21.0 ---
ha-cluster/data-service/oracle-traffic-director (ha-cluster) 4.4-0.21.0 ---
ha-cluster/data-service/postgresql (ha-cluster) 4.4-0.21.0 ---
ha-cluster/data-service/samba (ha-cluster) 4.4-0.21.0 ---
ha-cluster/data-service/sap-livecache (ha-cluster) 4.4-0.21.0 ---
ha-cluster/data-service/sapdb (ha-cluster) 4.4-0.21.0 ---
ha-cluster/data-service/sapnetweaver (ha-cluster) 4.4-0.21.0 ---
ha-cluster/data-service/sybase (ha-cluster) 4.4-0.21.0 ---
ha-cluster/data-service/timesten (ha-cluster) 4.4-0.21.0 ---
ha-cluster/data-service/tomcat (ha-cluster) 4.4-0.21.0 ---
ha-cluster/data-service/weblogic (ha-cluster) 4.4-0.21.0 ---
ha-cluster/data-service/websphere-message-queue (ha-cluster) 4.4-0.21.0 ---
ha-cluster/developer/agent-builder (ha-cluster) 4.4-0.21.0 ---
ha-cluster/developer/api (ha-cluster) 4.4-0.21.0 ---
ha-cluster/geo/geo-framework (ha-cluster) 4.4-0.21.0 ---
ha-cluster/geo/manual (ha-cluster) 4.4-0.21.0 ---
ha-cluster/geo/replication/availability-suite (ha-cluster) 4.4-0.1.0 --o
ha-cluster/geo/replication/data-guard (ha-cluster) 4.4-0.21.0 ---
ha-cluster/geo/replication/sbp (ha-cluster) 4.4-0.21.0 ---
ha-cluster/geo/replication/srdf (ha-cluster) 4.4-0.21.0 ---
ha-cluster/geo/replication/truecopy-ur (ha-cluster) 4.4-0.21.0 ---
ha-cluster/geo/replication/zfs-sa (ha-cluster) 4.4-0.21.0 ---
ha-cluster/geo/replication/zfs-snapshot (ha-cluster) 4.4-0.21.0 ---
ha-cluster/group-package/ha-cluster-data-services-full (ha-cluster) 4.4-0.21.0 ---
ha-cluster/group-package/ha-cluster-framework-full (ha-cluster) 4.4-0.21.0 ---
ha-cluster/group-package/ha-cluster-framework-l10n (ha-cluster) 4.4-0.21.0 ---
ha-cluster/group-package/ha-cluster-framework-minimal (ha-cluster) 4.4-0.21.0 ---
ha-cluster/group-package/ha-cluster-framework-scm (ha-cluster) 4.4-0.21.0 ---
ha-cluster/group-package/ha-cluster-framework-slm (ha-cluster) 4.4-0.21.0 ---
ha-cluster/group-package/ha-cluster-full (ha-cluster) 4.4-0.21.0 ---
ha-cluster/group-package/ha-cluster-geo-full (ha-cluster) 4.4-0.21.0 ---
ha-cluster/group-package/ha-cluster-geo-incorporation (ha-cluster) 4.4-0.21.0 ---
ha-cluster/group-package/ha-cluster-incorporation (ha-cluster) 4.4-0.21.0 ---
ha-cluster/group-package/ha-cluster-minimal (ha-cluster) 4.4-0.21.0 ---
ha-cluster/group-package/ha-cluster-quorum-server-full (ha-cluster) 4.4-0.21.0 ---
ha-cluster/group-package/ha-cluster-quorum-server-l10n (ha-cluster) 4.4-0.21.0 ---
ha-cluster/ha-service/derby (ha-cluster) 4.4-0.21.0 ---
ha-cluster/ha-service/gds (ha-cluster) 4.4-0.21.0 ---
ha-cluster/ha-service/gds2 (ha-cluster) 4.4-0.21.0 ---
ha-cluster/ha-service/logical-hostname (ha-cluster) 4.4-0.21.0 ---
ha-cluster/ha-service/smf-proxy (ha-cluster) 4.4-0.21.0 ---
ha-cluster/ha-service/telemetry (ha-cluster) 4.4-0.21.0 ---
ha-cluster/library/cacao (ha-cluster) 4.4-0.21.0 ---
ha-cluster/library/ucmm (ha-cluster) 4.4-0.21.0 ---
ha-cluster/locale (ha-cluster) 4.4-0.21.0 ---
ha-cluster/release/name (ha-cluster) 4.4-0.21.0 ---
ha-cluster/service/management (ha-cluster) 4.4-0.21.0 ---
ha-cluster/service/management/analytics (ha-cluster) 4.4-0.21.0 ---
ha-cluster/service/management/slm (ha-cluster) 4.4-0.21.0 ---
ha-cluster/service/quorum-server (ha-cluster) 4.4-0.21.0 ---
ha-cluster/service/quorum-server/locale (ha-cluster) 4.4-0.21.0 ---
ha-cluster/service/quorum-server/manual (ha-cluster) 4.4-0.21.0 ---
ha-cluster/service/quorum-server/manual/locale (ha-cluster) 4.4-0.21.0 ---
ha-cluster/storage/svm-mediator (ha-cluster) 4.4-0.21.0 ---
ha-cluster/storage/zfssa-client (ha-cluster) 1.0.6-2 ---
ha-cluster/storage/zfssa-gcclient (ha-cluster) 1.1.0-11 ---
ha-cluster/system/cfgchk (ha-cluster) 4.4-0.21.0 ---
ha-cluster/system/core (ha-cluster) 4.4-0.21.0 ---
ha-cluster/system/dsconfig-wizard (ha-cluster) 4.4-0.21.0 ---
ha-cluster/system/dsconfig-wizard/locale (ha-cluster) 4.4-0.21.0 ---
ha-cluster/system/install (ha-cluster) 4.4-0.21.0 ---
ha-cluster/system/management/puppet/oracle-solaris_cluster (ha-cluster) 4.4-0.21.0 ---
ha-cluster/system/manager (ha-cluster) 4.4-0.21.0 ---
ha-cluster/system/manager-glassfish3 (ha-cluster) 4.4-0.1.0 --o
ha-cluster/system/manager-wls (ha-cluster) 4.4-0.21.0 ---
ha-cluster/system/manual (ha-cluster) 4.4-0.21.0 ---
ha-cluster/system/manual/data-services (ha-cluster) 4.4-0.21.0 ---
ha-cluster/system/manual/locale (ha-cluster) 4.4-0.21.0 ---
ha-cluster/system/preinstall (ha-cluster) 4.4-0.21.0 ---

i follow this https://pkg-register.oracle.com/register/product_info/8/

pkg publisher
PUBLISHER TYPE STATUS P LOCATION
solaris origin online F http://pkg.oracle.com/solaris/release/
ha-cluster origin online F https://pkg.oracle.com/ha-cluster/release/

Comments

Gaz in Oz

Why are you using such an old version of mysql?

Why are you reading 5.7 documentation that may not be relevant to your old 5.1 db?

Are you using

. MyISAM

. InnoDB

Why don't you try it for yourself on a small table first and see how long it takes, what actions are carried out to rename it?

Alexandre Almeida
Answer

Hi there,

Actually, it depends on the table's storage engine. Renaming a MyISAM table is quite simple, the files (.frm, .MYI and .MYD) are simple renamed. Now, if your tables are innodb, it's a little bit more complex because data dictionary must be changed also. Starting MySQL 5.1 we got the variable innodb_file_per_table. If this variable is set as 0 your data resides inside shared table space (aka ibdata) and renaming table will cause no pages move. If innodb_file_per_table is set to 1, the your_file_table.ibd and your_file_table.frm will be renamed.

Anyways, renaming table won't copy table and won't cause any panic I/O.

Cheers,

Marked as Answer by 3410558 · Sep 27 2020
1 - 2

Post Details

Added on Mar 2 2021
2 comments
1,062 views