teratail header banner
teratail header banner
質問するログイン新規登録

回答編集履歴

2

追記

2025/07/10 00:01

投稿

kikukiku
kikukiku

スコア539

answer CHANGED
@@ -40,7 +40,7 @@
40
40
   下記を追加
41
41
  ORCLPDB =
42
42
  (DESCRIPTION =
43
- (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
43
+ (ADDRESS = (PROTOCOL = TCP)(HOST = localhost●サーバのIPアドレスを設定する必要あり●)(PORT = 1521))
44
44
  (CONNECT_DATA =
45
45
  (SERVER = DEDICATED)
46
46
  (SERVICE_NAME = orclpdb)

1

追記

2025/07/09 02:29

投稿

kikukiku
kikukiku

スコア539

answer CHANGED
@@ -54,3 +54,9 @@
54
54
   alter pluggable database orclpdb open;
55
55
  ・PDBにローカルユーザへ接続を試す
56
56
   sqlplus user1/user1@ORCLPDB
57
+
58
+ ==追記==
59
+ ・PDB自動起動設定
60
+  sqlplus / as sysdbs
61
+  alter pluggable database orclpdb open;
62
+  alter pluggable database orclpdb save state; <==OPEN中のPDBを自動起動に設定