暂无图片
ogg 如何修改useridalias密码
我来答
分享
chen
2022-12-07
ogg 如何修改useridalias密码

ogg 如何修改useridalias密码

我来答
添加附件
收藏
分享
问题补充
2条回答
默认
最新
张sir

就是数据库密码,进去修改就行吧

暂无图片 评论
暂无图片 有用 0
打赏 0
Mr.Cui

Syntax

ALTER CREDENTIALSTORE {
ADD USER userid |
REPLACE USER userid |
DELETE USER userid }
[PASSWORD password]
[ALIAS alias]
[DOMAIN domain]

ADD USER userid

Adds the specified user and its alias to the credential store. If the ALIAS option is not used, the alias defaults to the user name. A credential can only be entered once unless the ALIAS option is used to specify a different alias for each one. Unless the PASSWORD option is used, the command prompts for the password of the specified user. The user can be an actual user name or a SQL*Net connect string.

REPLACE USER userid

Changes the password of the specified user. If the ALIAS option is not used, the alias defaults to the user name. You cannot change the alias or domain of a user with this option, but you can use the ADD USER option to add a new entry for the user under the desired ALIAS or DOMAIN. Unless the PASSWORD option is used, the command prompts for the new password for the specified user.

DELETE USER userid

Removes the credential for the specified user from the credential store. If the ALIAS option is not used, the alias defaults to the user name.

PASSWORD password

The user’s password. The password is echoed (not obfuscated) when this option is used. If this option is omitted, the command prompts for the password, which is obfuscated as it is typed (recommended as more secure).

ALTER CREDENTIALSTORE ADD USER scott
Password: ********

ALIAS alias

Specifies an alias for the user name. Use this option if you do not want the user name to be in a parameter file or command. If ALIAS is not used, the alias defaults to the USER name, which then must be used in parameter files and commands where a login is required. You can create multiple entries for a user, each with a different alias, by using the ADD USER option with ALIAS.

DOMAIN domain

Saves the credential user under the specified domain name. Enables the same alias to be used by multiple Oracle GoldenGate installations that use the same credential store. The default domain is Oracle GoldenGate. For example, the administrators of system 1 might not want system 2 to have access to the same credentials that are used on system 1. Those credentials can be stored as ALIAS extract, for example, under DOMAIN system1, while a different set of credentials can be stored for ALIAS extract under DOMAIN system2. See ADD CREDENTIALSTORE for information about how to use a shared credential store.

Examples

Example 1

This example adds a user named scott but omits the PASSWORD specification, so the command prompts for Scott’s password.

ALTER CREDENTIALSTORE ADD USER scott
Password: ********

Example 2

This example adds the user scott with his password tiger and specifies an alias for scott that is named scsm2.

ALTER CREDENTIALSTORE ADD USER scott PASSWORD tiger ALIAS scsm2

Example 3

This example adds the user scott under the domain of support.

ALTER CREDENTIALSTORE ADD USER scott ALIAS scsm3 DOMAIN support
Password: ********

Example 4

This example issues two ALTER CREDENTIALSTORE commands, each of which adds a scott entry, but with a different alias.

ALTER CREDENTIALSTORE ADD USER scott ALIAS scsm2
Password: ********
ALTER CREDENTIALSTORE ADD USER scott ALIAS scsm3
Password: ********

Example 5

The following shows how the DELETE USER option works with and without the ALIAS option.

The following command deletes the user1 entry for which the ALIAS is the same as the user name.

ALTER CREDENTIALSTORE DELETE USER user1
Alias: user1
Userid: user1

The following command deletes the entry for user user1 that is associated with the alias alias1.

ALTER CREDENTIALSTORE DELETE USER user1 ALIAS alias1
Alias: alias1
Userid: user1

Example 6

This example uses a SQL*Net connect string as the user value. In this case, the PASSWORD option is omitted. The person issuing the command will be prompted for the password, which is obfuscated.

ALTER CREDENTIALSTORE ADD USER oggext1@ora1 ALIAS ora1

暂无图片 评论
暂无图片 有用 0
打赏 0
Mr.Cui
答主
2022-12-07
https://docs.oracle.com/goldengate/c1221/gg-winux/GWURF/alter-credentialstore.htm#GWURF953
回答交流
Markdown


请输入正文
提交
相关推荐
做OGG,如果一个表每天变更千万级别,是因为一个字段一直在更新,可以在OGG捕获更新的时候过滤这个字段吗?
回答 3
可以在源端捕获时过滤掉TABLEprod.EBSCONTRACCOLSEXCEPT(BUSINESSDESC);当然也可只捕获特定的字段:TABLEprod.SENDMSGCOLS(CONFIGTAG
OGG如何通过目标端复制进程查看源端IP
回答 5
catggserr.log|grepEXTRACT结合netstatano|grepESTABLE|grep:78核查下连接即可。
ogg与源库独立部署,dblogreader参数与源库版本的问题
回答 4
兄弟我也遇到这个情况了 不支持这个参数。可以详细点吗
ogg版本 11.2.1.0.3update获取的列如何获取全部列
回答 2
添加所有列补充日志试试
ogg从SQL server 2008同步到Oracle19c容器。初始化可以用什么好的方法?
回答 1
可以用ogg无初始化模式,将sql的数据初始化到oracle19c数据库,这个需要在目标端创建相应的表结构
ogg哪个版本支持从db2复制数据到db2
回答 4
已采纳
官方的文档显示是支持的https://docs.oracle.com/en/middleware/goldengate/core/21.3/gghdb/usingoraclegoldengatedb2
关于oracle goldengate的问题
回答 1
据了解,OGG并不直接支持SQLServer数据库的DDL复制吧
ogg 复制进程那端的trail文件怎么自动删除?
回答 1
已采纳
在你的mgr管理进程中添加参数PURGEOLDEXTRACTS根据需要保留合理的天数的trail即可。editparamsmgrPURGEOLDEXTRACTS/ogg/dirdat/,usechec
ogg源端和目标端都需要建立检查点吗?
回答 1
已采纳
源端不用,目标端创建即可。
ogg处理mysql 的json类型字段有方案吗?
回答 1
已采纳
我前几天刚试过,19c的ogg不行。要21c的ogg。如果你是mysql到mysql我最后用了mysql自带的多源复制过滤复制解决的。