SQL & PL/SQL

Hi Sudhir,

obviously you haven't been studying the documentation too closely.

http://docs.oracle.com/cd/E23903_01/doc/doc.41/e21673/otn_install.htm#BABDEAFD

Regards
Andre

Hi Sudhir,


To change the password for the ADMIN account:

1) Change your working directory to the apex directory where you unzipped the installation software.

2) Start SQL*Plus and connect to the database where Oracle Application Express is installed as SYS specifying the SYSDBA role. For example:

On Windows:

SYSTEM_DRIVE:\ sqlplus /nolog
SQL> CONNECT SYS as SYSDBA
Enter password: SYS_password

On UNIX and Linux:

$ sqlplus /nolog
SQL> CONNECT SYS as SYSDBA
Enter password: SYS_password

3) Run apxchpwd.sql. For example:

@apxchpwd

4) When prompted enter a password for the ADMIN account.


Hope this will helps you,

If you want more details about other Information related to installation
then follow the documentation suggested by Andre.

Regards,
Jitendra

Hi Jitendra,

I tried connecting through sydba role. When I enter password I am getting this error TNS: protocol adapater error;

have installed oracle 10g express edition. From there menu sqlplus link i am able to connect to the sysdba role. sysdba role password have provided as "oracle"

Please guide me how to fix this issue.

Thanks
Sudhir

Hi Sudhir,

try this from SQL Prompt.
1 ) SQL> CONN SYS AS SYSDBA
and then your password.
either try this
2) CONN / AS SYSDBA


This is just a guess...try the above..

hope this will solve your issue.

thanks,
jitendra

Hello Sudhir,

Do you have multiple databases on your system? If you have:
<ul>
<li>First of all check the service for the database on which you installed apex is up.</li>
<li>Check if the Listener service for the database is up.</li>
</ul>
Try the following if yours is a Windows OS:

SYSTEM_DRIVE:\ > sqlplus
Username: conn sys@<database-name> as sysdba
Password: <database-password>

For Example:

C:\ > sqlplus
Username: conn sys@mydb as sysdba
Password: ******

OR

Alternatively you can also try following:

SYSTEM_DRIVE:\ > set ORACLE_SID = <database-name>
SYSTEM_DRIVE:\ > sqlplus /nolog
SQL> CONNECT SYS as SYSDBA
Enter password: SYS_password

The rest is documented here:

http://docs.oracle.com/cd/E23903_01/doc/doc.41/e21673/otn_install.htm#BABDEAFD

Also Refer:

http://www.orafaq.com/wiki/ORACLE_SID

In order to get accurate/appropriate response you should include at least following information with your question:
<ul>
<li>Full APEX version</li>
<li>Full Database version</li>
<li>APEX Web server architecture (EPG, OHS or APEX listener)</li>
<li>Browser(s) and version(s) used</li>
<li>Operating system with version</li>
</ul>

Please read the [url https://wikis.oracle.com/display/Forums/Forums+FAQ]FAQ and [url https://forums.oracle.com/forums/ann.jspa?annID=1324]forum instructions for more information on using OTN forums effectively.

Please perform a [url https://forums.oracle.com/forums/search!default.jspa]forum search before posting a question as this will help reduce duplicate threads.

Please update your forum profile with a real handle instead of user6774496.

Hope it helps!
Regards,
Kiran

Hi Kiran,

Thanks for you reply. I tried all the ways as you suggested me to check. I am working in a client place so they actually installed oracle 10g later they uninstalled and installed oracle 10g xpress edition.

If I login from sqlplus where xe is installed. I am able to login. Please suggest me how to reset the admin password because when ever i connect to sysdba it asked for password. If i give the password it shows TNS: Protocol adapater error


Thanks
Sudhir

Hello Sudhir,

>
If i give the password it shows TNS: Protocol adapater error
>

Here you can look for possible remedies:

http://www.dba-oracle.com/t_ora_12560_tns_protocol_adapter_error.htm

>
If I login from sqlplus where xe is installed. I am able to login.
>
Does this mean you are using Oracle Database Client ?

Hope it helps!
Regards,
Kiran