Oracle XE - 安装后无法登录

声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow 原文地址: http://stackoverflow.com/questions/4597201/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me): StackOverFlow

提示:将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间:2020-09-18 22:19:45  来源:igfitidea点击:

Oracle XE - Just can't login after install

linuxoracleoracle10gora-01017

提问by vmassuchetto

That sounds really stupid.

这听起来真的很愚蠢。

On Lubuntu 10.10, I did:

在 Lubuntu 10.10 上,我做了:

echo "deb http://oss.oracle.com/debian unstable main non-free" >> /etc/apt/sources.list
apt-get update ; apt-get install oracle-xe

That brings me Oracle XE 10.2.0.1. And then:

这给我带来了 Oracle XE 10.2.0.1。进而:

/etc/init.d/oracle-xe configure

Everything looks ok, including the password prompt and so. After that, I go to http://127.0.0.1:port/apex, and when I try to login with the username "SYSTEM", and the password I just typed. I get a "Invalid Login Credentials" error.

一切看起来都不错,包括密码提示等等。之后,我转到http://127.0.0.1:port/apex,当我尝试使用用户名“SYSTEM”和刚刚输入的密码登录时。我收到“无效的登录凭据”错误。

I also tried:

我也试过:

sqlplus /nolog
CONNECT
[ .. login and password .. ]
ERROR:
ORA-01017: invalid username/password; logon denied

Setting the environment variables also don't help.

设置环境变量也无济于事。

sh oracle_env.sh

Well.. I just don't know what's happening. I repeated this procedure trying to find peculiar things, but always got the same results. Also tried some other users as "SYS". useless...

嗯..我只是不知道发生了什么。我重复这个过程试图找到奇怪的东西,但总是得到相同的结果。还尝试了一些其他用户作为“SYS”。无用...

Thanks in advance.

提前致谢。

回答by Rajesh K

Guys, I've been breakin my head with the same issue and finally got it logging in.. Here is the key.. http://www.linoob.com/2010/02/setting-up-oracle-xe-10g-in-ubuntu/in case u ve already installed oracle, just remove it and purge and then reinstall with the steps in the given link..

伙计们,我一直被同样的问题困扰,终于登录了.. 这是关键.. http://www.linoob.com/2010/02/setting-up-oracle-xe-10g -in-ubuntu/如果您已经安装了 oracle,只需将其删除并清除,然后按照给定链接中的步骤重新安装。

And don't forget to give a longer passwordthis time.. "minimum 8 chars"as I picked it up from some forum..

这次不要忘记提供更长的密码.. “最少 8 个字符”,因为我是从某个论坛上找到的..

回答by calcacuervo

Exactly the same is happening to me in CentOS 5. With user SYSTEM or SYS, just after install and configure I cannot log in.

我在 CentOS 5 中也发生了完全相同的情况。使用 SYSTEM 或 SYS 用户,在安装和配置后我无法登录。

回答by ctoguy

Yes, make sure the pw is >= 8 characters in length. It won't complain when setting on less than 8, but you won't be able to login ! With >= 8 in length, a successful login !!

是的,确保密码长度 >= 8 个字符。设置小于8就不会报错,但是你将无法登录!长度>=8,登录成功!!

回答by Jestin Joy

Check whether Oracle is running before trying log in

在尝试登录之前检查 Oracle 是否正在运行

/etc/init.d/oracle-xe start(Should be run as root).

/etc/init.d/oracle-xe start(应该以 root 身份运行)。

Then in sql terminal try log in.

然后在sql终端尝试登录。

connect / as sysdba

connect / as sysdba