如何找到主机字符串? [英] How to find host string?

问题描述

我刚刚安装了Oracle-DevSuitehome2，Oracle Database 10g Express Edition和Oracle开发人员套件-DevSuiteHome2. 我不熟悉此Oracle表单，Oracle Reports等.在安装过程中，它要求输入密码.我输入了.它是在SYS和SYSTEM数据库帐户中使用您的密码编写的.安装完成后，我启动了SQL * Plus.我输入SYSTEM作为用户名和密码.

I have just installed Oracle - DevSuitehome2, Oracle Database 10g Express Edition and Oracle Developer Suit - DevSuiteHome2. I am new to this Oracle forms, Oracle Reports, etc. During installation, it asked for the password. I entered it. It was written that use your password in SYS and SYSTEM Database accounts. After installation was completed I started SQL *Plus. I entered SYSTEM as username and my password.

                 ERROR:
                 ORA-12154 :TNS:could not resolve the connect identifier specified

我也尝试使用SYS作为我的用户名，但仍然是相同的错误.我打开cmd并输入:

I also tried SYS as my username but still same error. I opened cmd and typed:

                 C:\>sqlplus /nolog
                 SQL> conn / as sysdba
                 connected.
                 SQL> desc dba_users
                 NAME           NULL?           TYPE
                 ------         ------          --------
                 USERNAME                       VARCHAR2(30)
                 USERID                         NUMBER
                 PASSWORD                       VARCHAR2(30)
                 . 
                 .

                 SQL>select username,password from user_dba;
                 USERNAME                    PASSWORD
                 -----------                 -------------
                 SYS                         XXXXXXXXXX
                 SYSTEM                      XXXXXXXXXX
                 SCOTT                       XXXXXXXXXX
                 HR                          XXXXXXXXXX
                 . 
                 .  

所有密码均以复杂的形式编写，因此为简化起见，我想更改其中的任何密码.所以，我写道:

All passwords were written in complex form so to simplify it I thought to change any one of the password. So, I wrote :

                SQL> alter user HR identified by password;
                user altered.

然后我尝试在打开SQL * Plus时使用它们.那没起效.我现在不知道主机字符串是什么.我可以获取有关用户，密码和主机字符串的完整信息吗?我也尝试搜索tnsnames.ora文件，但找不到.所有文件，文件夹都一团糟.

Then I tried to use these while opening SQL *Plus. It did not work. I don't know what's the host string now. Can I get the complete information about users, passwords and host string ? I tried to search for tnsnames.ora file too but could not find out. All files, folders are all mess.

推荐答案

用户名和密码:

SELECT  USERNAME, PASSWORD
FROM    DBA_USERS;

密码始终是加密的，因此您不会从中得到很多好处

Passwords are always encrypted so you will not get much out of it

主机名:

SELECT sys_context('USERENV', 'HOST') FROM DUAL;

sys_context非常适合许多事情:

sys_context works great for many, many things:

http://psoug.org/reference/sys_context.html

如果您有权访问命令行，则可以使用侦听器状态来获取更多信息.

If you have access to the command line you can use listener status to get some more information.

LSNRCTL> STATUS
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=net)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.0.0 -
Beta
Start Date                15-JAN-2008 12:02:00
Uptime                    0 days 0 hr. 5 min. 29 sec
Trace Level               support
Security                  OFF
SNMP                      OFF
Listener Parameter File   /oracle/network/admin/listener.ora
Listener Log File         /oracle/network/log/listener.log
Listener Trace File       /oracle/network/trace/listener.trc

Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=net)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=sales-server)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=sales-server)(PORT=2484)))

Services Summary...
Service "sales1.us.example.com" has 1 instance(s).
  Instance "sales", status READY, has 1 handler(s) for this service...
Service "sales2.us.example.com" has 1 instance(s).
  Instance "sales", status READY, has 2 handler(s) for this service...
The command completed successfully

来源: http://docs.oracle. com/cd/E11882_01/network.112/e10835/lsnrctl.htm#CIHGHCGJ (Oracle数据库网络服务参考)

Source: http://docs.oracle.com/cd/E11882_01/network.112/e10835/lsnrctl.htm#CIHGHCGJ (Oracle Database Net Services Reference)

这篇关于如何找到主机字符串?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！