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

When migrating the database, I encountered a strange problem

Run start mgr in ogg

The interface prompts mgr is running, but check whether mgr is in progress or stopped by using the info all command.

Then go to the dirrpt directory to check the mgr process log and find the ogg error message as follows:

cd dirrpt

cat MGR.rpt

Source Context :

SourceModule : [ggdb.ora.sess]

SourceID : [/scratch/aime1/adestore/views/aime1_adc4150256/oggcore/OpenSys/src/gglib/ggdbora/ocisess.c]

SourceFunction : [oci_try]

SourceLine : [642]

ThreadBacktrace : [14] elements

: [/opt/ggs/libgglog.so(CMessageContext::AddThreadContext()+0x1e) [0x2adda13be06e]]

: [/opt/ggs/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...)+ 0x2cc) [0x2adda13ba44c]]

: [/opt/ggs/libgglog.so(_MSG_ERR_ORACLE_OCI_ERROR_WITH_DESC(CSourceContext*, int, char const*, char const*, CMessageFactory::Messa

geDisposition)+0x41) [0x2adda13a68b7]]

: [./ mgr(OCISESS_context_def::oci_try(int, char const*, ...)+ 0x4e0) [0x4f2070]]

: [./ mgr(OCISESS_context_def::logon(ggs::gglib::ggapp::CLoginName const&, ggs::gglib::ggapp::CDBObjName const&, ggs

::gglib::ggunicode::UString const&, int, bool, int, int, int)+0x86f) [0x4f346f]]

: [./ mgr(DBOCI_init_connection_logon(ggs::gglib::ggapp::CLoginName const&, ggs::gglib::ggapp::CDBObjName const&, ch

ar const*, int, int, int, char*)+0xd6) [0x4d8b26]]

: [./ mgr [0x4ebbf5]]

: [./ mgr(gl_odbc_param(char const*, char const*, char*)+0x4c) [0x4ebf2c]]

: [./ mgr(param_file_args(char*)+0x12d3) [0x4479e3]]

: [./ mgr(init_functions(int, char**)+0x5f0) [0x448030]]

: [./ mgr(main_loop(int, char**)+0x4c) [0x44e13c]]

: [./ mgr(main+0xdc) [0x44e8bc]]

: [/lib64/libc.so.6(__libc_start_main+0xf4) [0x33a801d994]]

: [./ mgr(__gxx_personality_v0+0x14a) [0x43a49a]]

2016-03-16 00:04:47 ERROR OGG-00664 OCI Error beginning session (status = 1034-ORA-01034: ORACLE not available

ORA-27101: shared memory realm does not exist

Linux-x86_64 Error: 2: No such file or directory).

2016-03-16 00:04:47 ERROR OGG-01668 PROCESS ABENDING.

See this error feel strange, Oracle instance is not started when this error will be reported, but my instance has been started, why still report this error?

Search information through the network also did not get a solution, then their own research.

Check ogg user, whether the instance cannot be identified because of ogg user group:

[ggs@qfangsh3 dirrpt]$ id ggs

uid=1008(ggs) gid=1000(oinstall) groups=1000(oinstall),1001(dba),1004(asmdba)

Checking ogg directory permissions found no problems either.

View mgr process configuration

GGSCI (qfangsh3) 2> view params mgr

DYNAMICPORTLIST 7840-7914

PORT 7809

PURGEOLDEXTRACTS /opt/ggs/dirdat/** ***/*, USECHECKPOINTS, MINKEEPFILES 30

AUTORESTART ER *, RETRIES 3, WAITMINUTES 5

USERID ***, PASSWORD *******

PURGEDDLHISTORY MINKEEPDAYS 3, MAXKEEPDAYS 5, FREQUENCYMINUTES 30

PURGEMARKERHISTORY MINKEEPDAYS 3, MAXKEEPDAYS 5, FREQUENCYMINUTES 30

LAGREPORTHOURS 1

LAGINFOMINUTES 30

LAGCRITICALMINUTES 45

It was found that there was no configuration of the database other than the user, and the idea that the ORACLE_HOME variable was configured incorrectly was also defeated.

So if there are no relevant parameters in the configuration file, what does the mgr process of ogg use to determine the oracle instance?

Later, I thought about whether it was through the ORACLE_SID environment variable, so I checked some environment configurations.

The result shows that ORACLE_SID is configured as SID of another node, and the modification is correct and effective.

Enter ogg client again

./ ggsci

start mgr

start *

GGSCI (******) 3> info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING

EXTRACT RUNNING ****** 00:00:09 00:00:05

EXTRACT RUNNING ****** 00:00:00 00:00:02

EXTRACT RUNNING ****** 00:00:00 00:00:00

REPLICAT RUNNING ****** 00:00:00 00:00:06

REPLICAT RUNNING ****** 00:00:00 00:00:03

mgr process starts normally, problem solved

Think about it more, check it more, always solve the problem

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.