teratail
回答率
85.30%
質問するログイン新規登録
トップに関する質問SQL*Plusのプロンプトでスクリプトファイルを実行したところ、エラーが出る。

編集履歴

質問編集履歴

4

修正

2020/06/26 03:43

投稿

nao085
nao085

スコア2

title CHANGED
File without changes
body CHANGED
@@ -1,156 +1,124 @@
1
- オラクルブロンズの勉強をしようと思い、下記の記事を参考にmac OS でOracle Databaseを使えるように進めました。
1
+ 下記の記事を参考にmac OS でOracle Databaseを使えるように進めました。
2
2
  [https://qiita.com/shinbones/items/07d474a049c454100363](https://qiita.com/shinbones/items/07d474a049c454100363)
3
-
4
3
  オラクルブロンズ白本付属のサンプル表をOracle Databaseに登録しようとSQL*Plusのプロンプトに@cretab.sqlと入力して、スクリプトファイルを実行したところ下記のエラーが出ました。
5
4
  SQL> @cretab.sql
6
5
  SP2-0734: unknown command beginning "?@ /* ???K..." - rest of line ignored.
7
6
  SP2-0734: unknown command beginning "?@/* SYSTE..." - rest of line ignored.
8
-
9
7
  "Clean Up ..."
10
8
  "??????s???̓G???[?????????܂?????肠??܂???B"
11
-
12
9
  User dropped.
13
-
14
-
15
10
  "ora01" User Creating...
16
-
17
- User created.
11
+ User created
18
-
19
-
20
12
  Grant succeeded.
21
-
22
-
23
13
  Grant succeeded.
24
-
25
-
26
14
  Grant succeeded.
27
-
28
-
29
15
  Grant succeeded.
30
-
31
-
32
16
  "ora01" 's DATA Creating...
33
17
  ERROR:
34
18
  ORA-12545: Connect failed because target host or object does not exist
19
+ Warning: You are no longer connected to ORACLE.
20
+ SP2-0640: Not connectedが以下119行続きます。
35
21
 
36
-
37
- Warning: You are no longer connected to ORACLE.
38
- SP2-0640: Not connected
39
- SP2-0640: Not connected
40
- SP2-0640: Not connected
41
- SP2-0640: Not connected
42
- SP2-0640: Not connected
43
- SP2-0640: Not connected
44
- SP2-0640: Not connected
45
- SP2-0640: Not connected
46
- SP2-0640: Not connected
47
- SP2-0640: Not connected
48
- SP2-0640: Not connected
49
- SP2-0640: Not connected
50
- SP2-0640: Not connected
51
- SP2-0640: Not connected
52
- SP2-0640: Not connected
53
- SP2-0640: Not connected
54
- SP2-0640: Not connected
55
- SP2-0640: Not connected
56
- SP2-0640: Not connected
57
- SP2-0640: Not connected
58
- SP2-0640: Not connected
59
- SP2-0640: Not connected
60
- SP2-0640: Not connected
61
- SP2-0640: Not connected
62
- SP2-0640: Not connected
63
- SP2-0640: Not connected
64
- SP2-0640: Not connected
65
- SP2-0640: Not connected
66
- SP2-0640: Not connected
67
- SP2-0640: Not connected
68
- SP2-0640: Not connected
69
- SP2-0640: Not connected
70
- SP2-0640: Not connected
71
- SP2-0640: Not connected
72
- SP2-0640: Not connected
73
- SP2-0640: Not connected
74
- SP2-0640: Not connected
75
- SP2-0640: Not connected
76
- SP2-0640: Not connected
77
- SP2-0640: Not connected
78
- SP2-0640: Not connected
79
- SP2-0640: Not connected
80
- SP2-0640: Not connected
81
- SP2-0640: Not connected
82
- SP2-0640: Not connected
83
- SP2-0640: Not connected
84
- SP2-0640: Not connected
85
- SP2-0640: Not connected
86
- SP2-0640: Not connected
87
- SP2-0640: Not connected
88
- SP2-0640: Not connected
89
- SP2-0640: Not connected
90
- SP2-0640: Not connected
91
- SP2-0640: Not connected
92
- SP2-0640: Not connected
93
- SP2-0640: Not connected
94
- SP2-0640: Not connected
95
- SP2-0640: Not connected
96
- SP2-0640: Not connected
97
- SP2-0640: Not connected
98
- SP2-0640: Not connected
99
- SP2-0640: Not connected
100
- SP2-0640: Not connected
101
- SP2-0640: Not connected
102
- SP2-0640: Not connected
103
- SP2-0640: Not connected
104
- SP2-0640: Not connected
105
- SP2-0640: Not connected
106
- SP2-0640: Not connected
107
- SP2-0640: Not connected
108
- SP2-0640: Not connected
109
- SP2-0640: Not connected
110
- SP2-0640: Not connected
111
- SP2-0640: Not connected
112
- SP2-0640: Not connected
113
- SP2-0640: Not connected
114
- SP2-0640: Not connected
115
- SP2-0640: Not connected
116
- SP2-0640: Not connected
117
- SP2-0640: Not connected
118
- SP2-0640: Not connected
119
- SP2-0640: Not connected
120
- SP2-0640: Not connected
121
- SP2-0640: Not connected
122
- SP2-0640: Not connected
123
- SP2-0640: Not connected
124
- SP2-0640: Not connected
125
- SP2-0640: Not connected
126
- SP2-0640: Not connected
127
- SP2-0640: Not connected
128
- SP2-0640: Not connected
129
- SP2-0640: Not connected
130
- SP2-0640: Not connected
131
- SP2-0640: Not connected
132
- SP2-0640: Not connected
133
- SP2-0640: Not connected
134
- SP2-0640: Not connected
135
- SP2-0640: Not connected
136
- SP2-0640: Not connected
137
- SP2-0640: Not connected
138
- SP2-0640: Not connected
139
- SP2-0640: Not connected
140
- SP2-0640: Not connected
141
- SP2-0640: Not connected
142
- SP2-0640: Not connected
143
- SP2-0640: Not connected
144
- SP2-0640: Not connected
145
- SP2-0640: Not connected
146
- SP2-0640: Not connected
147
- SP2-0640: Not connected
148
- SP2-0640: Not connected
149
- SP2-0640: Not connected
150
- SP2-0640: Not connected
151
- SP2-0640: Not connected
152
- SP2-0640: Not connected
153
- SP2-0640: Not connected
154
- SP2-0640: Not connected
155
- SP2-0640: Not connected
156
- SP2-0640: Not connected
22
+ ```sql
23
+ SPOOL setup.log
24
+ PROMPT
25
+ PROMPT "Clean Up ..."
26
+ PROMPT "初回実行時はエラーが発生しますが問題ありません。"
27
+ DROP USER ora01 CASCADE;
28
+ PROMPT
29
+ PROMPT "ora01" User Creating...
30
+ CREATE USER ora01
31
+ IDENTIFIED BY oracle;
32
+ GRANT CONNECT,RESOURCE,UNLIMITED TABLESPACE TO ora01;
33
+ GRANT CREATE SYNONYM TO ora01;
34
+ GRANT CREATE ROLE TO ora01;
35
+ GRANT CREATE VIEW TO ora01;
36
+ PROMPT
37
+ PROMPT "ora01" 's DATA Creating...
38
+ CONNECT ora01/oracle
39
+ CREATE TABLE departments
40
+ (deptno NUMBER(2) CONSTRAINT pk_dept PRIMARY KEY,
41
+ dname VARCHAR2(14) ,
42
+ loc VARCHAR2(10) ) ;
43
+ CREATE TABLE employees
44
+ (empno NUMBER(4) CONSTRAINT pk_emp PRIMARY KEY,
45
+ ename VARCHAR2(10),
46
+ yomi VARCHAR2(20),
47
+ job VARCHAR2(8),
48
+ mgr NUMBER(4),
49
+ hiredate DATE,
50
+ sal NUMBER(7),
51
+ comm NUMBER(7),
52
+ deptno NUMBER(2) CONSTRAINT fk_deptno REFERENCES departments(deptno));
53
+ INSERT INTO departments VALUES
54
+ (10,'管理','大手町');
55
+ INSERT INTO departments VALUES
56
+ (20,'研究開発','横浜');
57
+ INSERT INTO departments VALUES
58
+ (30,'営業','品川');
59
+ INSERT INTO departments VALUES
60
+ (40,'財務','東京');
61
+ INSERT INTO employees VALUES
62
+ (1001,'佐藤','sato','社長',NULL,to_date('2001-02-25','yyyy-mm-dd'),500000,NULL,10);
63
+ INSERT INTO employees VALUES
64
+ (1002,'鈴木','suzuki','事務',1013,to_date('2000-03-26','yyyy-mm-dd'),200000,NULL,20);
65
+ INSERT INTO employees VALUES
66
+ (1003,'高橋','takahashi','営業',1007,to_date('2000-05-30 ','yyyy-mm-dd'),300000,30000,30);
67
+ INSERT INTO employees VALUES
68
+ (1004,'田中','tanaka','営業',1007,to_date('2002-06-02','yyyy-mm-dd'),355000,50000,30);
69
+ INSERT INTO employees VALUES
70
+ (1005,'渡辺','watanabe','部長',1001,to_date('2002-07-11','yyyy-mm-dd'),280000,NULL,20);
71
+ CREATE TABLE salgrades
72
+ ( grade CHAR(1) CONSTRAINT pk_grade PRIMARY KEY,
73
+ losal NUMBER(7),
74
+ hisal NUMBER(7));
75
+ INSERT INTO salgrades VALUES ('A',100000,190000);
76
+ INSERT INTO salgrades VALUES ('B',190001,280000);
77
+ INSERT INTO salgrades VALUES ('C',280001,370000);
78
+ INSERT INTO salgrades VALUES ('D',370001,460000);
79
+ INSERT INTO salgrades VALUES ('E',460001,999999);
80
+ CREATE TABLE customers
81
+ (custno NUMBER(5) CONSTRAINT cust_pk PRIMARY KEY,
82
+ cname VARCHAR2(20),
83
+ address VARCHAR2(30),
84
+ phone VARCHAR2(12),
85
+ credit_rating VARCHAR2(6));
86
+ INSERT INTO customers VALUES (1000,'品川商事','東京都港区１－ｘ－ｘ','03-1234-xxxx','優良');
87
+ INSERT INTO customers VALUES (1001,'横浜商店','横浜市磯子区２－ｘ－ｘ','045-753-xxxx','要注意');
88
+ INSERT INTO customers VALUES (1002,'川口や','川口市本町１－ｘ－ｘｘ','048-336-xxxx','要注意');
89
+ INSERT INTO customers VALUES (1003,'○×商店','横浜市鶴見区２－ｘｘ','045-505-xxxx','良');
90
+ INSERT INTO customers VALUES (1004,'川崎ストア','川崎市川崎区１０－ｘｘ','044-567-xxxx','優良');
91
+ CREATE TABLE products
92
+ (PRODNO CHAR(3) CONSTRAINT PROD_PK PRIMARY KEY,
93
+ PNAME VARCHAR2(30),
94
+ PRICE NUMBER(6));
95
+ INSERT INTO products VALUES ('A01','100円ボールペン',100);
96
+ INSERT INTO products VALUES ('A02','芯強シャープペンシル',100);
97
+ INSERT INTO products VALUES ('A03','10色ボールペン',300);
98
+ INSERT INTO products VALUES ('A04','最高級万年筆',1000);
99
+ INSERT INTO products VALUES ('A05','なないろ鉛筆',30);
100
+ REATE TABLE orders
101
+ (ordno NUMBER(8) CONSTRAINT ORD_PK PRIMARY KEY,
102
+ custno NUMBER(5) CONSTRAINT ORD_CUST_FK REFERENCES customers(CUSTNO),
103
+ date_ordered DATE,
104
+ date_shipped DATE,
105
+ salesman_no NUMBER(4) CONSTRAINT ord_emp_fk REFERENCES employees(empno),
106
+ payment_type VARCHAR2(10));
107
+ INSERT INTO orders VALUES (1,1001,'2009-12-20','2009-12-27',1003,'クレジット');
108
+ INSERT INTO orders VALUES (2,1001,'2009-12-21','2009-12-27',1003,'クレジット');
109
+ INSERT INTO orders VALUES (3,1001,'2010-01-10','2010-01-17',1003,'クレジット');
110
+ INSERT INTO orders VALUES (4,1002,'2010-01-11','2010-01-18',1010,'クレジット');
111
+ INSERT INTO orders VALUES (5,1008,'2010-01-15','2010-01-22',1003,'クレジット');
112
+ CREATE TABLE ord_details
113
+ (ordno NUMBER(8) CONSTRAINT ord_det_ord_fk REFERENCES orders(ordno),
114
+ prodno CHAR(3) CONSTRAINT ord_det_prod_fk REFERENCES products(prodno),
115
+ quantity NUMBER(5),
116
+ CONSTRAINT ord_det_pk PRIMARY KEY(ordno,prodno));
117
+ INSERT INTO ord_details VALUES (1,'A02',30);
118
+ INSERT INTO ord_details VALUES (1,'C01',20);
119
+ INSERT INTO ord_details VALUES (2,'B01',5);
120
+ INSERT INTO ord_details VALUES (2,'B06',10);
121
+ INSERT INTO ord_details VALUES (2,'B02',10);
122
+ SPOOL off
123
+ ```
124
+ 文字化けしているのをediterで開きUTF-8からShift JISへエンコードを変更しました。

3

イメージの削除、エラーメッセージの添付

2020/06/26 03:43

投稿

nao085
nao085

スコア2

title CHANGED
File without changes
body CHANGED
@@ -2,6 +2,155 @@
2
2
  [https://qiita.com/shinbones/items/07d474a049c454100363](https://qiita.com/shinbones/items/07d474a049c454100363)
3
3
 
4
4
  オラクルブロンズ白本付属のサンプル表をOracle Databaseに登録しようとSQL*Plusのプロンプトに@cretab.sqlと入力して、スクリプトファイルを実行したところ下記のエラーが出ました。
5
+ SQL> @cretab.sql
5
- ![イメージ説明](9a2db8eb7d197ead7d0106fda4f6fa15.png)
6
+ SP2-0734: unknown command beginning "?@ /* ???K..." - rest of line ignored.
7
+ SP2-0734: unknown command beginning "?@/* SYSTE..." - rest of line ignored.
6
8
 
9
+ "Clean Up ..."
7
- ORACLE_SIDの環境変数が間違っているのだろうかと考え設定してみましたが、解決することはできませんでした。
10
+ "??????s???̓G???[?????????܂?????肠??܂???B"
11
+
12
+ User dropped.
13
+
14
+
15
+ "ora01" User Creating...
16
+
17
+ User created.
18
+
19
+
20
+ Grant succeeded.
21
+
22
+
23
+ Grant succeeded.
24
+
25
+
26
+ Grant succeeded.
27
+
28
+
29
+ Grant succeeded.
30
+
31
+
32
+ "ora01" 's DATA Creating...
33
+ ERROR:
34
+ ORA-12545: Connect failed because target host or object does not exist
35
+
36
+
37
+ Warning: You are no longer connected to ORACLE.
38
+ SP2-0640: Not connected
39
+ SP2-0640: Not connected
40
+ SP2-0640: Not connected
41
+ SP2-0640: Not connected
42
+ SP2-0640: Not connected
43
+ SP2-0640: Not connected
44
+ SP2-0640: Not connected
45
+ SP2-0640: Not connected
46
+ SP2-0640: Not connected
47
+ SP2-0640: Not connected
48
+ SP2-0640: Not connected
49
+ SP2-0640: Not connected
50
+ SP2-0640: Not connected
51
+ SP2-0640: Not connected
52
+ SP2-0640: Not connected
53
+ SP2-0640: Not connected
54
+ SP2-0640: Not connected
55
+ SP2-0640: Not connected
56
+ SP2-0640: Not connected
57
+ SP2-0640: Not connected
58
+ SP2-0640: Not connected
59
+ SP2-0640: Not connected
60
+ SP2-0640: Not connected
61
+ SP2-0640: Not connected
62
+ SP2-0640: Not connected
63
+ SP2-0640: Not connected
64
+ SP2-0640: Not connected
65
+ SP2-0640: Not connected
66
+ SP2-0640: Not connected
67
+ SP2-0640: Not connected
68
+ SP2-0640: Not connected
69
+ SP2-0640: Not connected
70
+ SP2-0640: Not connected
71
+ SP2-0640: Not connected
72
+ SP2-0640: Not connected
73
+ SP2-0640: Not connected
74
+ SP2-0640: Not connected
75
+ SP2-0640: Not connected
76
+ SP2-0640: Not connected
77
+ SP2-0640: Not connected
78
+ SP2-0640: Not connected
79
+ SP2-0640: Not connected
80
+ SP2-0640: Not connected
81
+ SP2-0640: Not connected
82
+ SP2-0640: Not connected
83
+ SP2-0640: Not connected
84
+ SP2-0640: Not connected
85
+ SP2-0640: Not connected
86
+ SP2-0640: Not connected
87
+ SP2-0640: Not connected
88
+ SP2-0640: Not connected
89
+ SP2-0640: Not connected
90
+ SP2-0640: Not connected
91
+ SP2-0640: Not connected
92
+ SP2-0640: Not connected
93
+ SP2-0640: Not connected
94
+ SP2-0640: Not connected
95
+ SP2-0640: Not connected
96
+ SP2-0640: Not connected
97
+ SP2-0640: Not connected
98
+ SP2-0640: Not connected
99
+ SP2-0640: Not connected
100
+ SP2-0640: Not connected
101
+ SP2-0640: Not connected
102
+ SP2-0640: Not connected
103
+ SP2-0640: Not connected
104
+ SP2-0640: Not connected
105
+ SP2-0640: Not connected
106
+ SP2-0640: Not connected
107
+ SP2-0640: Not connected
108
+ SP2-0640: Not connected
109
+ SP2-0640: Not connected
110
+ SP2-0640: Not connected
111
+ SP2-0640: Not connected
112
+ SP2-0640: Not connected
113
+ SP2-0640: Not connected
114
+ SP2-0640: Not connected
115
+ SP2-0640: Not connected
116
+ SP2-0640: Not connected
117
+ SP2-0640: Not connected
118
+ SP2-0640: Not connected
119
+ SP2-0640: Not connected
120
+ SP2-0640: Not connected
121
+ SP2-0640: Not connected
122
+ SP2-0640: Not connected
123
+ SP2-0640: Not connected
124
+ SP2-0640: Not connected
125
+ SP2-0640: Not connected
126
+ SP2-0640: Not connected
127
+ SP2-0640: Not connected
128
+ SP2-0640: Not connected
129
+ SP2-0640: Not connected
130
+ SP2-0640: Not connected
131
+ SP2-0640: Not connected
132
+ SP2-0640: Not connected
133
+ SP2-0640: Not connected
134
+ SP2-0640: Not connected
135
+ SP2-0640: Not connected
136
+ SP2-0640: Not connected
137
+ SP2-0640: Not connected
138
+ SP2-0640: Not connected
139
+ SP2-0640: Not connected
140
+ SP2-0640: Not connected
141
+ SP2-0640: Not connected
142
+ SP2-0640: Not connected
143
+ SP2-0640: Not connected
144
+ SP2-0640: Not connected
145
+ SP2-0640: Not connected
146
+ SP2-0640: Not connected
147
+ SP2-0640: Not connected
148
+ SP2-0640: Not connected
149
+ SP2-0640: Not connected
150
+ SP2-0640: Not connected
151
+ SP2-0640: Not connected
152
+ SP2-0640: Not connected
153
+ SP2-0640: Not connected
154
+ SP2-0640: Not connected
155
+ SP2-0640: Not connected
156
+ SP2-0640: Not connected

2

参考記事リンク化

2020/06/25 11:21

投稿

nao085
nao085

スコア2

title CHANGED
File without changes
body CHANGED
@@ -1,5 +1,5 @@
1
1
  オラクルブロンズの勉強をしようと思い、下記の記事を参考にmac OS でOracle Databaseを使えるように進めました。
2
- https://qiita.com/shinbones/items/07d474a049c454100363
2
+ [https://qiita.com/shinbones/items/07d474a049c454100363](https://qiita.com/shinbones/items/07d474a049c454100363)
3
3
 
4
4
  オラクルブロンズ白本付属のサンプル表をOracle Databaseに登録しようとSQL*Plusのプロンプトに@cretab.sqlと入力して、スクリプトファイルを実行したところ下記のエラーが出ました。
5
5
  ![イメージ説明](9a2db8eb7d197ead7d0106fda4f6fa15.png)

1

画像の挿入

2020/06/25 10:24

投稿

nao085
nao085

スコア2

title CHANGED
File without changes
body CHANGED
@@ -2,7 +2,6 @@
2
2
  https://qiita.com/shinbones/items/07d474a049c454100363
3
3
 
4
4
  オラクルブロンズ白本付属のサンプル表をOracle Databaseに登録しようとSQL*Plusのプロンプトに@cretab.sqlと入力して、スクリプトファイルを実行したところ下記のエラーが出ました。
5
+ ![イメージ説明](9a2db8eb7d197ead7d0106fda4f6fa15.png)
5
6
 
6
- [![Image from Gyazo](https://i.gyazo.com/417af31c5fae97fd6929af3330c517ff.png)](https://gyazo.com/417af31c5fae97fd6929af3330c517ff)
7
-
8
7
  ORACLE_SIDの環境変数が間違っているのだろうかと考え設定してみましたが、解決することはできませんでした。