DBA Hub

📋Steps in this guide1/2

How Srvctl Modify Database SPFILE

$ srvctl modify database -d PRIM -spfile +DATA/PRIM/spfile

oracle configurationintermediate
by OracleDba
23 views
1

Overview

- 1.   Make File Alias for Spfile. - 1.   Make File Alias for Spfile. - 1.   Make File Alias for Spfile.

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
ASMCMD> cd +DATA/PRIM/PARAMETERFILE
ASMCMD> ls -l
Type           Redund  Striped  Time             Sys  Name
PARAMETERFILE  UNPROT  COARSE   OCT 30 14:00:00  Y    spfile.271.1055166363
ASMCMD> cd ..
ASMCMD> mkalias PARAMETERFILE/spfile.271.1055166363 spfile
ASMCMD> ls -l spfile
Type           Redund  Striped  Time             Sys  Name
PARAMETERFILE  UNPROT  COARSE   OCT 30 14:00:00  N    spfile => +DATA/PRIM/PARAMETERFILE/spfile.271.1055166363
ASMCMD> exit

[oracle@node1 ~]$ srvctl modify database -d PRIM -spfile +DATA/PRIM/spfile

[oracle@node1 ~]$ srvctl config database -d PRIM
Database unique name: PRIM
Database name: PRIM
Oracle home: /u01/app/oracle/product/19c/db_1
Oracle user: oracle
Spfile: +DATA/PRIM/spfile
Password file: +DATA/PRIM/pwfile
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools:
Disk Groups: DATA
Mount point paths:
Services:
Type: RAC
Start concurrency:
Stop concurrency:
OSDBA group: dba
OSOPER group: oper
Database instances: PRIM1
Configured nodes: node1
CSS critical: no
CPU count: 0
Memory target: 0
Maximum memory: 0
Default network number for database services:
Database is administrator managed

[oracle@node1 ~]$ srvctl stop database -d PRIM
[oracle@node1 ~]$ srvctl start database -d PRIM
[oracle@node1 ~]$ sqlplus / as sysdba
...
SQL> show parameter spfile;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string      +DATA/PRIM/spfile
2

Section 2

Please Note : if you want to remove the alias files, don’t use rm, use rmalias command in ASMCMD to remove the links instead.

Comments (0)

Please to add comments

No comments yet. Be the first to comment!