■請求とコスト管理
https://us-east-1.console.aws.amazon.com/costmanagement/home?region=ap-southeast-2#/home
https://us-east-1.console.aws.amazon.com/billing/home#/
https://us-east-1.console.aws.amazon.com/billing/home?region=ap-southeast-2&#/budgets/overview

■AWS ダッシュボード一覧
●EC2
https://ap-southeast-2.console.aws.amazon.com/ec2/home?region=ap-southeast-2#Home:

●RDS
https://ap-southeast-2.console.aws.amazon.com/rds/home?region=ap-southeast-2#

●IAM
https://us-east-1.console.aws.amazon.com/iam/home?region=ap-southeast-2#/home

●VPC
https://ap-southeast-2.console.aws.amazon.com/vpcconsole/home?region=ap-southeast-2#Home:

・仮想プライベートクラウド
・お使いの VPC
https://ap-southeast-2.console.aws.amazon.com/vpcconsole/home?region=ap-southeast-2#vpcs:
・サブネット
https://ap-southeast-2.console.aws.amazon.com/vpcconsole/home?region=ap-southeast-2#subnets:

・ルートテーブル
https://ap-southeast-2.console.aws.amazon.com/vpcconsole/home?region=ap-southeast-2#RouteTables:
・インターネットゲートウェイ
・Egress-only インターネットゲートウェイ
・DHCP オプションセット
・Elastic IP
・マネージドプレフィックスリスト
・エンドポイント
・エンドポイントサービス
・NAT ゲートウェイ
・ピアリング接続

・セキュリティ
・ネットワーク ACL
・セキュリティグループ
https://ap-southeast-2.console.aws.amazon.com/vpcconsole/home?region=ap-southeast-2#SecurityGroups:

●コンソールのホーム
https://ap-southeast-2.console.aws.amazon.com/console/home?region=ap-southeast-2

●archive
●
●

################################################################################################################■AWS料金の話
【AWS】よく使うAWSサービスの料金について -こんなところでお金がかかるんですと言いたい話-

###############################################################################################################
とらくら エンジニアブログ

AWS 初心者が RDS（データベース）を構築してみました！ Part.2 構築編

●AWS新規アカウント作成
mucche0001@gmail.com

AWS
mucche0001
mucche0001@gmail.com/lEu47s8q!Jae

https://ap-southeast-2.console.aws.amazon.com/console/home?region=ap-southeast-2#

最速１分！？EC2 インスタンス（仮想サーバ）を構築してみました

●EC2
最速１分！？EC2 インスタンス（仮想サーバ）を構築してみました

最速１分！？EC2 インスタンス（仮想サーバ）を構築してみました

ec2-user
mucc555

-アジアパシフィック (シドニー)
ap-southeast-2

【EC2】Amazon Linux 2023にTeratermで接続できない？
https://www.cloudbuilders.jp/articles/3200/
サーバ側の設定で、SSH-RSA署名を有効化する
結局、この事象は鍵交換における署名アルゴリズムの問題で発生するので、サーバ側の設定を変えてあげれば解決します。
具体的には、AWSドキュメントで示されている通り以下の手順を踏めばよいです。

crypto-policies-scriptsをインストールする
sudo dnf install crypto-policies-scripts
ポリシーをレガシーに設定する
sudo update-crypto-policies –set LEGACY
SSH-RSAが有効化されていることを確認する

●EC2にoracleユーザ作成
mkdir /home/oracle
groupadd -r oinstall
useradd -g oinstall -s /bin/bash -d /home/oracle oracle

●Oracle Clientインストール
https://itedge.stars.ne.jp/oracle-cloud-ec2-dbaas/
# curl -o oracle-instantclient19.20-basic-19.20.0.0.0-1.x86_64.rpm https://download.oracle.com/otn_software/linux/instantclient/1920000/oracle-instantclient19.20-basic-19.20.0.0.0-1.x86_64.rpm
# ls
# yum -y localinstall oracle-instantclient19.20-basic-19.20.0.0.0-1.x86_64.rpm

・sqlplus
# curl -o oracle-instantclient19.20-sqlplus-19.20.0.0.0-1.x86_64.rpm https://download.oracle.com/otn_software/linux/instantclient/1920000/oracle-instantclient19.20-sqlplus-19.20.0.0.0-1.x86_64.rpm
# yum -y localinstall oracle-instantclient19.20-sqlplus-19.20.0.0.0-1.x86_64.rpm

sqlplus ‘rdsmaster/oEm47s8q@test-rds-1.c5e2sksia7pd.ap-southeast-2.rds.amazonaws.com:1521/ORCL’

(ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA)

●トラブル対応
https://repost.aws/ja/knowledge-center/rds-oracle-connection-errors

tnsping test-rds-1.c5e2sksia7pd.ap-southeast-2.rds.amazonaws.com

●ロール作成

AWS CLIをインストールしてコマンド操作しよう

TEST-RDS-ADMIN
・AmazonRDSCustomInstanceProfileRolePolicy
・AmazonRDSDataFullAccess
・AmazonRDSFullAccess
・RDSCloudHsmAuthorizationRole

●EC2 ec2-userパスワード設定
https://dev.startialab.blog/linux/a154
ec2-user にはパスワードが設定されていないため、設定を行います。

●EC2インスタンスでAWS CLIのコンフィグを設定
aws configure
ap-southeast-2c
json

確認
aws ec2 describe-vpcs
aws ec2 describe-instances

●AWS CLIを使ってEC2のファイルをS3へアップロードしよう

AWS CLIを使ってEC2のファイルをS3へアップロードしよう

●オプショングループ作成
aws rds create-option-group \
–option-group-name TEST-RDS-ORA-OPTION \
–engine-name oracle-ee \
–major-engine-version 19 \
–option-group-description “Test option group for Oracle Database 19c EE”

aws rds create-option-group \
–option-group-name TEST-RDS-ORA-OPTION-DBOPTION \
–engine-name oracle-ee \
–major-engine-version 19 \
–option-group-description “Test option group for Oracle Database 19c SE”

●パラメータ変更
aws rds modify-db-parameter-group \
–db-parameter-group-name TEST-RDS-ORA-PARAMETER \
–parameters “ParameterName=CPU_COUNT,ParameterValue=1,ApplyMethod=iqmmediate”

●パラメータグループのCSV出力
https://dev.classmethod.jp/articles/rds-parameter-group-export-to-csv/

aws rds describe-db-parameters –db-parameter-group-name TEST-RDS-ORA-PARAMETER \
| jq -r ‘[“名前”,”値”,”許可された値”,”変更可能”,”送信元”,”適用タイプ”,”データ型”,”説明”,”ApplyMethod”,”MinimumEngineVersion”], (.Parameters[] | [.ParameterName,.ParameterValue,.AllowedValues,.IsModifiable,.Source,.ApplyType,.DataType,.Description,.ApplyMethod,.MinimumEngineVersion]) | @csv’ \
| iconv -t sjis \
> parameters.csv

●オプショングループのCSV出力
aws rds describe-option-groups>options.csv
grep -A 1 SQLNET.ENCRYPTION_SERVER options.csv

●オプションの確認
V$OPTION.

“PARAMETER”,”VALUE”,”CON_ID”
“ASM Proxy Instance”,”FALSE”,0
“Active Data Guard”,”FALSE”,0
“Adaptive Execution Plans”,”FALSE”,0
“Advanced Analytics”,”FALSE”,0
“Advanced Compression”,”FALSE”,0
“Advanced Index Compression”,”FALSE”,0
“Advanced replication”,”FALSE”,0
“Application Role”,”FALSE”,0
“Automatic Data Optimization”,”FALSE”,0
“Automatic Storage Management”,”FALSE”,0
“Backup Encryption”,”FALSE”,0
“Basic Compression”,”FALSE”,0
“Bit-mapped indexes”,”FALSE”,0
“Block Change Tracking”,”FALSE”,0
“Block Media Recovery”,”FALSE”,0
“Cache Fusion Lock Accelerator”,”FALSE”,0
“Centrally Managed User”,”FALSE”,0
“Change Data Capture”,”FALSE”,0
“Coalesce Index”,”TRUE”,0
“Connection multiplexing”,”TRUE”,0
“Connection pooling”,”TRUE”,0
“Cross Transportable Backups”,”FALSE”,0
“DICOM”,”TRUE”,0
“Data Mining”,”FALSE”,0
“Data Redaction”,”FALSE”,0
“Database queuing”,”TRUE”,0
“Database resource manager”,”FALSE”,0
“Deferred Segment Creation”,”FALSE”,0
“Duplexed backups”,”FALSE”,0
“Enterprise User Security”,”FALSE”,0
“Exadata Discovery”,”FALSE”,0
“Export transportable tablespaces”,”FALSE”,0
“Fast-Start Fault Recovery”,”FALSE”,0
“File Mapping”,”FALSE”,0
“Fine-grained Auditing”,”FALSE”,0
“Fine-grained access control”,”FALSE”,0
“Flashback Data Archive”,”TRUE”,0
“Flashback Database”,”FALSE”,0
“Flashback Table”,”FALSE”,0
“Global Data Services”,”FALSE”,0
“Heat Map”,”FALSE”,0
“I/O Server”,”FALSE”,0
“In-Memory Aggregation”,”FALSE”,0
“In-Memory Column Store”,”FALSE”,0
“Incremental backup and recovery”,”TRUE”,0
“Instead-of triggers”,”TRUE”,0
“Java”,”TRUE”,0
“Join index”,”FALSE”,0
“Managed Standby”,”FALSE”,0
“Management Database”,”FALSE”,0
“Materialized view rewrite”,”FALSE”,0
“OLAP”,”FALSE”,0
“OLAP Window Functions”,”TRUE”,0
“Objects”,”TRUE”,0
“Online Index Build”,”FALSE”,0
“Online Redefinition”,”FALSE”,0
“Oracle Data Guard”,”FALSE”,0
“Oracle Database Vault”,”FALSE”,0
“Oracle Label Security”,”FALSE”,0
“Parallel backup and recovery”,”FALSE”,0
“Parallel execution”,”FALSE”,0
“Parallel load”,”TRUE”,0
“Partitioning”,”FALSE”,0
“Plan Stability”,”TRUE”,0
“Point-in-time tablespace recovery”,”FALSE”,0
“Privilege Analysis”,”FALSE”,0
“Proxy authentication/authorization”,”TRUE”,0
“Real Application Clusters”,”FALSE”,0
“Real Application Security”,”FALSE”,0
“Real Application Testing”,”FALSE”,0
“Result Cache”,”FALSE”,0
“SQL Plan Management”,”FALSE”,0
“Sample Scan”,”TRUE”,0
“SecureFiles Encryption”,”FALSE”,0
“Server Flash Cache”,”FALSE”,0
“Snapshot time recovery”,”FALSE”,0
“Spatial”,”FALSE”,0
“Streams Capture”,”FALSE”,0
“Table Clustering”,”FALSE”,0
“Transparent Application Failover”,”TRUE”,0
“Transparent Data Encryption”,”FALSE”,0
“Transparent Sensitive Data Protection”,”FALSE”,0
“Trial Recovery”,”FALSE”,0
“Unified Auditing”,”FALSE”,0
“Unused Block Compression”,”FALSE”,0
“XStream”,”TRUE”,0
“Zone Maps”,”FALSE”,0

87 rows selected.

★エラー
An error occurred (InvalidParameterValue) when calling the CreateOptionGroup operation: The parameter OptionGroupName is not a valid identifier. Identifiers must begin with a letter; must contain only ASCII letters, digits, and hyphens; and must not end with a hyphen or contain two consecutive hyphens.