ORA-28267: Invalid NameSpace Value - When connected to Oracle 26ai using a dblink
还没有人认领这个 Issue。
评估
调研方向
The report is a Thin-mode connection from Python to a 26ai database that runs select 1 from dual@consultamondb over a link to a 19c server, which fails with ORA-28267 (Invalid NameSpace Value). Start by reproducing with the attached script against a comparable 26ai-to-19c dblink, and check whether the failure is in the driver's authentication or in the server-side link. Done means identifying which side causes ORA-28267 and either fixing the driver path or documenting the required configuration.
由索引模型根据 Issue 内容生成。
描述
- What versions are you using?
oracledb-26.0.1
platform.platform: Windows-11-10.0.26300-SP0
sys.maxsize > 2**32: True
platform.python_version: 3.12.10
oracledb.version: 26.0.1
- Is it an error or a hang or a crash?
Error
The database I am initially connecting to is version 26ai Free; the database link created on it points to an Oracle 19c database, and any query returns the error.
- What error(s) or behavior you are seeing?
PS C:\oracle\PythonTeste> python.exe .\testeOracle.py
Conectado! Versão do banco: 23.26.3.0.0
code = 28267
full_code= ORA-28267
message = ORA-28267: Invalid NameSpace Value
ORA-02063: preceding line from CONSULTAMONDB
Help: https://docs.oracle.com/error-help/db/ora-28267/
- Does your application call init_oracle_client()?
using the python-oracledb Thin mode
- Include a runnable Python script that shows the problem.
import os
import sys
import oracledb
USER = os.getenv("ORA_USER", "meu_usuario")
PASSWORD = os.getenv("ORA_PASSWORD", "minha_senha")
DSN = os.getenv("ORA_DSN", "localhost:1521/XEPDB1") # host:porta/service_name
QUERY = """
select 1 from dual@consultamondb
"""
def main():
try:
with oracledb.connect(user=USER, password=PASSWORD, dsn=DSN) as conn:
print(f"Conectado! Versão do banco: {conn.version}")
with conn.cursor() as cur:
cur.execute(QUERY)
colunas = [c[0] for c in cur.description]
print(" | ".join(colunas))
for linha in cur:
print(" | ".join(str(v) for v in linha))
except oracledb.DatabaseError as e:
error, = e.args
print("code =", error.code)
print("full_code=", error.full_code)
print("message =", error.message)
sys.exit(1)
if name == "main":
main()
- 主要语言
- Python
- 星标
- 455
- 派生
- 119
- PR 合并指标
- 30 天内没有已合并 PR
环境准备
- 没有 Dockerfile 或 Docker Compose 文件
- 有 Pull Request 模板
- 阅读贡献指南
从这里开始
- 先读完整个 Issue，再读项目的贡献指南。
- 在 Issue 下留言说明你要接手 —— 这能避免两个人做同样的事。
- Fork 仓库，在一个分支上完成修改。
- 提交 Pull Request，并在描述里引用这个 Issue 编号。
oracle/python-oracledb 的其他 Issue
-
难度 4/5 3-5 天 新手友好度 42/100
oracle/python-oracledb#619 ·
-
asyncio: DPY-4011 on connect_async() when the listener closes the original socket after a redirect可能已有人在做 @AlexGracas 于 9 天前认领。 未关闭
难度 3/5 1-2 天 新手友好度 35/100
oracle/python-oracledb#616 ·
-
bug
难度 4/5 3-5 天 新手友好度 48/100
oracle/python-oracledb#615 ·
-
Fetch character columns as raw bytes in the database character set into data frames (Thick mode)未关闭enhancement
难度 5/5 一周以上 新手友好度 35/100
oracle/python-oracledb#614 · 1 条评论 ·
-
Client Library or Database
难度 4/5 3-5 天 新手友好度 35/100
oracle/python-oracledb#613 · 3 条评论 ·
查看 oracle/python-oracledb 的全部 Issue
相似的 Issue
-
难度 2/5 1-3 小时 新手友好度 75/100
common-workflow-language/cwl-utils#477 ·
维护者通常 1 天内回复
-
Add dependabot未关闭feat
难度 2/5 1 小时以内 新手友好度 72/100
open-nudge/opentemplate#204 ·
维护者通常 1 天内回复
-
github-stale-ci-pr-closer: KV state is double-wrapped, never persists, and hits the depth-32 limit可能已有人在做 @VascoSch92 今天认领。 未关闭priority:medium ready-for-dev
难度 2/5 1-3 小时 新手友好度 72/100
OpenHands/extensions#781 ·
维护者通常 1 天内回复
-
bug good first issue
难度 2/5 1-3 小时 新手友好度 78/100
维护者通常 1 天内回复
-
curriculum documentation quality
难度 2/5 1-3 小时 新手友好度 78/100
githubnext/gh-aw-workshop#4638 ·
维护者通常 1 天内回复