Shulou(Shulou.com)06/01 Report--

This article mainly introduces the method of solving oracle database ORA-01081: cannot start already-running ORACLE-shut it down first, which is very detailed and has certain reference value. Friends who are interested must read it!

When checking that the background process of the oracle instance does not exist, launch the database and report an error:

ORA-01081: "cannot start already-running ORACLE-shut it down first"

The reason for this is

Orphaned shared memory segments and semaphores did not get cleared properly

From the last instance shutdown.

During the last shutdown of the oracle instance, an isolated shared memory segment and signal were not cleaned up

Solution method

Ipcs can be used to find shared memory segments or signals, and ipcrm can be used to manually clear

Orphaned shared memory segments (orphaned shared memory segment) and semaphores (semaphore)

[root@wl] # ipcs-a

-Shared Memory Segments-

Key shmid owner perms bytes nattch status

0x00000000 688138 oracle 640 4096 0

0x00000000 720907 oracle 640 4096 0

-Semaphore Arrays-

Key semid owner perms nsems

0x000000a7 0 root 600 1

0x00000000 688138 oracle 640 4096 0

0x00000000 720907 oracle 640 4096 0

[root@wl] # ipcs-m

-Shared Memory Segments-

Key shmid owner perms bytes nattch status

0x00000000 688138 oracle 640 4096 0

0x00000000 720907 oracle 640 4096 0

[root@wl] # ipcrm-m 720907

Ipcs: check allocated shared memory

Ipcrm: manually freeing shared memory segments

Get ipc information:

Ipcs [- m |-Q |-s]

-m outputs information about shared memory (shared memory)

-Q outputs information about the information queue (message queue)

-s outputs information about "semaphore" (semaphore)

-a use all printing options. (shorthand for-b,-c,-o,-p, and-t)

Example:

Ipcrm-m shmid number-for shared memory

Ipcrm-s semid number-for semaphores

OR

Shutdown all the instances belonging to the user. Next, run "ipcs-b" to find the remaining IPC

Facilities, owned by the same user, and remove them. However, if you're running multiple production

Instances, this may not be acceptable.

In the case of multiple instances

1. Running

Ipcs-a > / tmp/ipcs_before.out

two。 Use SQL*Plus to connect all instances to make a simple query

Select * from dual

3. Run again

Ipcs-a > / tmp/ipcs_after.out

4. Compare "/ tmp/ipcs_before.out" with "/ tmp/ipcs_after.out" files

Find shared memory segments where LPID has not changed

These are the orphaned shared memory segments you are looking for:

LPID displays the process ID that appends or separates shared memory segments in the final process

Because, by executing the query in each living instance, you will involve the shared memory segments that belong to the respective instance

But the uninvolved shared memory segment will become an isolated one.

5. After identifying the orphaned shared memory segments, you can find

The orphaned semaphores by locating the semaphores with the same

Value of CTIME in "ipcs-a" output as the value of CTIME for the

Orphaned shared memory segments: CTIME shows the time when the

Associated entry was created or changed.

After identifying isolated shared memory segments, isolated shared memory segments can be found by determining signals with the same CTIME value through the output of ipcs-a

As the value of the related orphaned shared memory segment

The above is all the contents of the solution to the oracle database ORA-01081: cannot start already-running ORACLE-shut it down first, thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.