重置 Oracle Apex 管理员密码
我在此服务器上安装了 2 个 Apex，我想重置第二个 Apex 的密码，我该怎么做？我试过
$ sqlplus sys/123456 作为 sysdba
SQL> @apxxepwd密码
但它只重置第一个顶点，我将如何重置第二个顶点？
tnsnames.ora 文件如下所示
DATABASE1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = the_database_server)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = DATABASE1)
)
)
DATABASE2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = the_database_server)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = DATABASE2)
)
)
如何连接到 Database2？ sqlplus sys 作为 sysdba ？
I have 2 Apexes installed on this server, I would like to reset password for the 2nd Apex, how would I do this? I tried
$ sqlplus sys/123456 as sysdba
SQL> @apxxepwd password
But it only reset the first Apex, how would I reset the 2nd apex?
The tnsnames.ora file looks like this
DATABASE1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = the_database_server)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = DATABASE1)
)
)
DATABASE2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = the_database_server)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = DATABASE2)
)
)
How do I connect to Database2?
sqlplus sys as sysdba ?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
您连接到的默认数据库由 ORACLE_SID 环境变量定义。
但您也可以通过在密码后添加 @... 来指定要连接到的数据库。
但您甚至不需要设置 TNSNAMES.ora。您还可以通过简单地将主机/SID 放在 @ 后面来使用“轻松连接”：
请注意，也可以在 SQLNET.ora 中关闭“轻松连接”（我认为它在 10g 及以上客户端中默认打开）。
The default database you are connecting to is defined by the ORACLE_SID environment variable.
But you can also specify which DB you're going to connect to by adding @... after the password.
But you don't even need to set up the TNSNAMES.ora. You could also use "easy connect" by simply putting host/SID behind the @:
Note that "easy connect" can also be turned off in your SQLNET.ora (it's on by default in 10g clients and above i think).