APEX ADMIN Access From Remote Machine

Oct 18, 2010

I have installed oracle 11g and configured Apex application on it. I am able to open the Admin window from my machine . URL.... and everything works fine. But when I try to open the link from other machine I get "Server not found" error.

I read the posts it says to enable Http for other servers . I dont find the way to do it .

View 2 Replies


ADVERTISEMENT

Application Express :: Restarting APEX After Installation Configuration - Cannot Access Admin Screen?

Jul 20, 2012

I installed and configures APEX in standalone mode about 2 weeks ago and played with it for short time. Now after 2 weeks I came back to start where I left off but APex_admin page would not come up.

I did following tasks as were found on Installed Apex on Oracle 11g. But cannot access admin screen

SQL> SELECT STATUS FROM DBA_REGISTRY
2 WHERE COMP_ID = 'APEX';
STATUS
-----------
VALID
SQL> conn sys as sysdba
Enter password:

[code]...

warning me that XDB requires username password to be sent through insecure manner (Basic authetication without a secure connection

View 1 Replies View Related

Application Express :: Cannot Log Into Apex Admin

Sep 16, 2013

Having an issue with logging into URL....  Just went through the install for APEX 4.2 for

Oracle 11.2.0.1 on Linux 2.6.32-358.el6.x86_64 #1 SMP Fri Feb 22 00:31:26 UTC 2013 x86_64 x86_64 x86_64 GNU/Linux. 

Installed Apex with Embedded PL/SQL Gateway.Explicitly followed all the online instructions step-by-step, installation was success and config for EPG had no issues.  Changed the ADMIN pw as instructed.  Checked that EPG is running on port 8080.  Ran this script to grant connect: 

DECLARE  ACL_PATH VARCHAR2(4000);BEGIN  -- Look for the ACL currently assigned to '*' and give APEX_040200  -- the "connect" privilege if APEX_040200 does not have the privilege yet. SELECT ACL INTO ACL_PATH FROM DBA_NETWORK_ACLS  WHERE HOST = '*' AND LOWER_PORT IS NULL AND UPPER_PORT IS NULL;[code]....

that lets power users to connect to everywhere', 

'APEX_040200', TRUE, 'connect');  DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL('power_users.xml','*');END;/COMMIT;  

When I go to log in it says "Invalid Login Credentials".  I tried changing the admin pw several times but keep getting the same message.

View 1 Replies View Related

Express Edition (XE) :: Connecting To As System Admin On Apex Website?

Sep 5, 2012

I'm trying to connect to the Apex website using SYSTEM or SYS. What is the workspace for system?

I logged into SQL command line and created this user using this line then grant dba to it

CREATE USER USER_HP_FULL IDENTIFIED BY w ACCOUNT UNLOCK DEFAULT TABLESPACE "USERS" TEMPORARY TABLESPACE "TEMP" PROFILE "DEFAULT";

Now, I know the username and password but I don't know the workspace. I want to log into the oracle application express website.

View 2 Replies View Related

Deny Root / Admin Access To DB?

Apr 25, 2012

I am studying a way to block the access from the root(UNIX) or admin(WIN) users to the database.

Are there some way to block the access by the superusers?

View 3 Replies View Related

Forms :: Installing Weblogic On Windows 7 X86 Machine / Restarting Admin-server Hangs

Jul 5, 2011

Im trying to install Weblogic/Forms on a Windows 7 x86 machine. Its for the developers to use.But when I run the config.bat and is creating the domain and installing Forms builder and the other stuff the installation hangs at: step restaring admin server started.

Log:

Stopping Derby Server...
Starting AdminServer
Starting the domain ...
DEBUG : Loading the 32 bit dll here
DEBUG : Loading DLL : D:/oracle/middleware/as_1/install/config/StartUtil.dll
DEBUG : Loaded DLL : D:/oracle/middleware/as_1/install/config/StartUtil.dll

View 1 Replies View Related

RMAN Backup To Remote Machine

Nov 2, 2011

am trying to backup my oracle database using RMAN to a remote machine. both systems are using redhat linux. i have successfully configured NFS on my remote machine and mounted it from my oracle database machine.

i then configure rman channel to disk on mounted linux directory..when i take full backup of database i receive this error

ORA-19504: failed to create file "/mnt/ora_df766174940_s104_s1"
ORA-27054: NFS file system where the file is created or resides is not mounted w
ith correct options
Additional information: 3

How do i mount this with correct options the error msg says OR what do i do to backup to the said directory?

View 5 Replies View Related

Enterprise Manager :: Accessing OEM From A Remote Machine

Jan 25, 2011

I am having 3 oracle 10.2.0.5 version standard edition databases running on windows platform on 3 different servers. OEM is configured for all the 3 databases and we are able to access these OEM from their respective servers.

As per my knowledge, I should be able to access the OEMs of all 3 databases from my local machine. But Iam facing problem in accessing the OEMs from my local machine.

what changes need to be done so that I can access the OEMs of all 3 databases from one single local machine rather than checking it by logging into their respective servers.

View 7 Replies View Related

PL/SQL :: Spooling Data From Remote Server To Local Machine

Feb 6, 2013

I need to spool data from a remote server using putty(sqlplus) to a local machine. There are credentials i need to give before accessing the remote databases and i am able to do it..i tired with the below query but the spool file(csv or txt) is not able to create on local machine.

set colsep ,
set pagesize 120
set trimspool on
set headsep off
set linesize 1000
set numw

spool D: estmyfile.csv
select table_name, tablespace_name from all_tables;
spool off

View 2 Replies View Related

Windows :: Copy A File To DB Server From A Remote Machine Using Plsql / Java

Oct 2, 2013

We want to copy a file from a remote machine to the DB server. copy \<IP_ADRESS>SHARED_FOLDERsome_file.sql d:copied_file.sql

I've used Java and a wrapped it into a PL/SQL procedure so I can do :

exec run_os_command(p_command => 'copy \<IP_ADRESS>SHARED_FOLDERsome_file.sql d:copied_file.sql');

The file was not copied.

I have mapped \<IP_ADRESS>SHARED_FOLDER to x: for example and issued : exec run_os_command(p_command => 'copy x:some_file.sql d:copied_file.sql');

The file was not copied.

But when I issued from the OS prompt copy x:some_file.sql d:copied_file.sql then the file is copied.

What can I add to the PL/SQL procedure so it wil work ?

View 19 Replies View Related

Rman Remote Access

Mar 16, 2011

I am unable to access remote (hosted on remote server) database using rman.

When I try to connect using "rman TARGET sys/syspwd@db" I am getting:

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database:
ORA-12520: TNS:listener could not find available handler for requested type of server

I the same time I am able to login using sqlplus (sqlplus sys/syspwd@db as sysdba) without any issue.

What am I doing wrong?

View 1 Replies View Related

Recovery Manager (RMAN) :: Duplicate Database From ASM To Non-ASM File System To Remote Machine

Aug 30, 2012

I have oracle 11.2.0.3.0 in Windows 2008 server R2 64 bit version. I have installed database ASMDB with ASM ... Now i have another one machine , I want to clone my database in that machine with Non ASM file system .. Can any one tell me step by step document to do it ?

Can i keep the database name as ASMDB in another Machine ?

View 9 Replies View Related

Networking And Gateways :: Access Remote Oracle DB / VB-10G?

Jul 30, 2012

I'm using Vb and DB Oracle 10G.

What are the steps for connect oracle DB through internet.

View 10 Replies View Related

Windows :: Connecting Oracle To Remote Access Server?

Mar 2, 2011

Is it possible to connect Oracle to MS Access database sitting on remote server? I need to join the tables in Oracle and MS Access.

View 5 Replies View Related

Forms :: Tracking Remote Desktop Access Using Oracle?

Sep 27, 2013

I have a form developed using Oracle 10g Forms Builder. It is deployed on server. I need to track who is remotely accessing the desktop and running this form. How can we track this. Are there any webutil commands to trace the application used to access the desktop? What is the work around for this?

View 2 Replies View Related

Application Express :: Access For External File In Apex Page?

May 21, 2013

How can I access this "file:///C:/Users/RI/m_1.html" external file within the apex page?

I created a page and button for link but struggling for above.

View 5 Replies View Related

Server Administration :: Unable To Access Remote Database Using DBLink

May 21, 2010

We have created a new db link. But we are not able access the remote database. When we are trying to access any table using db link system is getting hanged.

We would like to know what are the parameters/permissions which affect the db link access either at data base level or at server level.

One observation we made is that that particular db link is not getting dropped when we tried to drop it.

View 2 Replies View Related

Server Administration :: Access To Database Server Machine Login?

Apr 30, 2012

database administration , we are planning to use amazon cloud database , this database does not allow us to login to server machine , unfortunately amazon don't provide ssh to this machine , in general for doing any of adminstration task on the database will there be need to log into the machine ? we can always log in through toad or any other sql client but we cannot do ssh to server..general can this limitation effect administration ?

View 9 Replies View Related

Application Express Listener :: APEX Listener With APEX 3.0 On 11gR2?

Jun 29, 2012

We have many many APEX applications in APEX 3.0 running on a 10.2.0.4 database that needs desperately to be upgraded. As a test, I've set up a clean 11gR2 database and copied the production APEX database into it via datapump. I set up APEX Listener, as I don't have any OAS sitting around and the EPG doesn't seem to be supported for APEX 3.0... the Listener doesn't say one way or the other.

When trying to log in, I get the login page, but it tries to reference files such as apex_get_3_1.js while I only have files such as htmldb_get.js in my images directory in production. I noticed it is looking for what appears to be 3.1 files instead of 3.0 files... which concerns me.

The APEX listener appears to be more than just a Java PL/SQL gateway.

Is there a minimum version of APEX the APEX Listener supports?

View 2 Replies View Related

Application Express :: ORA-24247 / Network Access Denied By Access Control List

Apr 5, 2013

When I invoke SOAP Web-Service using APEX_WEB_SERVICE.MAKE_REQUEST, then I'm able to get response from web-service. However all German character are replaced by JUNK data. However data is coming fine when I test web-services using SOAP UI.

I tried to invoke web-service using UTL_HTTP. However when I use UTL_HTTP, then I'm getting following error.

ORA-24247: network access denied by access control list

<li> Why German characters are replaced by Junk data while invoking web-service from APEX, while it's working fine from SOAP UI

<li> When I can access web-service successfully using APEX_WEB_SERVICE, then why it's throwing ORA-24247 error when I call using UTL_HTTP?

DB: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
APEX: 4.0.2.00.07
Web-Server: EPG
SELECT * FROM NLS_DATABASE_PARAMETERS;

[code]...

View 4 Replies View Related

ORA-24247 / Network Access Denied By Access Control List (ACL)

Dec 12, 2012

I am having oracle database version 11.2.0.3.0 standard edition, where one of my users requirement is that he wanted to send mails from oracle database but he is getting below error

ORA-24247: network access denied by access control list (ACL)
ORA-06512: at "SYS.UTL_TCP", line 17
ORA-06512: at "SYS.UTL_TCP", line 267
ORA-06512: at "SYS.UTL_SMTP", line 161
ORA-06512: at "SYS.UTL_SMTP", line 197
ORA-06512: at "HF_REPORTING.SEND_MAIL", line 12
ORA-06512: at line 18

is it possible to send mails from oracle database in STANDARD Edition?

View 1 Replies View Related

SQL & PL/SQL :: ORA-24247 / Network Access Denied By Access Control List (ACL)

Nov 15, 2011

While Running the proc,it's raising the below error.

Error report:

ORA-24247: network access denied by access control list (ACL)
ORA-06512: at "SYS.UTL_TCP", line 17
ORA-06512: at "SYS.UTL_TCP", line 246
ORA-06512: at "SYS.UTL_SMTP", line 115
ORA-06512: at "SYS.UTL_SMTP", line 138
ORA-06512: at "LISTER_SHIFT.SOLN_GENERIC_SENDMAIL", line 33
ORA-06512: at line 1

[code]....

View 12 Replies View Related

Database Auto Start With Machine On And Shutdown With Machine Shutdown

Sep 2, 2012

i install oracle 10g on linux on perform the following step but my database is not auto start with the machine

Automatic startup and shutdown oracle on linux Oracle database server provides two scripts to configure automatic database startup and shutdown process.

The scripts are,
$ORACLE_HOME/bin/dbstart
$ORACLE_HOME/bin/dbshut

Now let's look at unix level script. When a unix machine boots it runs scripts beginning with Snnname in /etc/rc3.d.

-Here the number nn indicates the order in which these scripts will be run. The name just indicates the function of the script.

In the same way shutdown scripts are named as Knnname which are run from /etc/rc0.d.

If we want that Oracle is the last program that is automatically started, and it is the first to be shutdown then we will name the startup and shutdown scripts on OS like /etc/rc3.d/S99oracle and /etc/rc0.d/K01oracle respectively.

The database script dbstart and dbora will be called from OS script /etc/rc3.d/S99oracle and /etc/rc0.d/K01oracle respectively.

Note that dbstart and dbshut take each SID, in turn, from the /etc/oratab file and startup or shutdown the database.

Automate Startup/Shutdown of Oracle Database on Linux

Step 01: Be sure that oratab file is correct and complete.

Check for oratab file either in /etc/oratab or in /var/opt/oracle/oratab.

Database entries in the oratab file have the following format:

$ORACLE_SID:$ORACLE_HOME:Y
Here Y indicates that the database can be started up and shutdown using dbstart/dbshut script.

If in my database there is two database named arju and arjudup then my oratab file will contain the entry like,
arju:/var/opt/oracle/product/10.2.0/db_1:Y
arjudup:/var/opt/oracle/product/10.2.0/db_1:Y
where /var/opt/oracle/product/10.2.0/db_1 is the $ORACLE_HOME of my database.

Step 02: Create a script to call dbstart and dbshut. In this example I will create one script that will do both startup and shutdown operation. I will name this script as dbora and will be placed in '/etc/init.d'.

a) Login as root.
b) Change directories to /etc/init.d
c) Create a file called dbora and chmod it to 750.

# touch dbora
# chmod 750 dbora
d)Edit the dbora file and make the contents of it like below.

[Code].....

View 1 Replies View Related

Windows :: System Admin Log In Error

Feb 6, 2013

i want to log-in my local machine database as a system administrator , but it is giving an error:

C:Windowssystem32>sqlplus /@myprodb as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Wed Feb 6 19:18:15 2013

Copyright (c) 1982, 2010, Oracle. All rights reserved.

ERROR: ORA-01031: insufficient privileges

Enter user-name:

C:Windowssystem32>sqlplus /@myprodb as sysoper

SQL*Plus: Release 11.2.0.1.0 Production on Wed Feb 6 19:19:28 2013

Copyright (c) 1982, 2010, Oracle. All rights reserved.

ERROR: ORA-01031: insufficient privileges

Enter user-name:

but

C:Windowssystem32>sqlplus sys@myprodb as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Wed Feb 6 19:20:45 2013

Copyright (c) 1982, 2010, Oracle. All rights reserved.

Enter password:

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>

and i have run cmd as administrator

View 20 Replies View Related

Security :: ORA-01932 - ADMIN Option Not Granted For Role

Aug 23, 2011

When i try to grant role to user , i get following error.

SQL>
SQL> GRANT MAINTAIN_TEO TO CEE_WIRELINE;
GRANT MAINTAIN_TEO TO CEE_WIRELINE
*
ERROR at line 1:
ORA-01932: ADMIN option not granted for role 'MAINTAIN_TEO'
SQL>

View 1 Replies View Related

Application Express Listener :: GlassFish Admin Page

Jul 30, 2013

My configuration is GlassFish 4 (the same thing with Glass Fish 3.2) + win7 + Apex Listener 2.2 (the same thing with  Apex Listener 2.1) + Apex 4.2.2 I get blank page when trying to connect to APEX. But after loggin into GlassFish admin page (exactly login with username+password; just open admin page is not enough) in another browser tab I get proper Apex page with all images.

View 1 Replies View Related

Oracle 11g Installation - SYSTEM Admin Password Does Not Work

Aug 13, 2012

I have installed oracle several times in the past. This time I installed 11gr2 first time. I created default database during install and provided an admin password. Only thing I forgot to do was did not unlock the accounts using Password management button.

When I tried to login as SYS the admin password works fine but as SYSTEM admin password does not work. Used to be able to login as SYS, SYTEM with same admin password.

Now in SQLPLUS I unlocked the account but still can not change the password.

View 4 Replies View Related

Application Express :: 2 Schemas - Admin Password Reset

Feb 7, 2013

We have 2 apex schemas

APEX_030000
APEX_040200

Before executing the apxchpwd.sql, found the "alter session command" sets schema to APEX_030000. So we changed that to APEX_040200. Then we executed the sql script. It executed fine.

But now when we try to login to apex, and pressing enter after providing the username/pwd, it raises the following exception

Error Error in PLSQL code raised during plug-in processing.
ORA-06508: PL/SQL: could not find program unit being called

View 1 Replies View Related

NESTED ERROR When Making Admin Server A Windows Service?

May 6, 2013

I created a script to make my admin server a windows service. I successfully made it a service but when it starts it then shuts itself down. i ran a debug and found a error. I dont get what to do. I have tried changing the variables in the script and try it over and over again .....here is my script code and here is the error i got from debug output:

script

SETLOCAL
set DOMAIN_NAME=FRClassicDomain
set USERDOMAIN_HOME=C:/Oracle/Middleware/user_projects/domains/FRClassicDomain
set SERVER_NAME=FRweblogic

[Code]....

View 1 Replies View Related

Express Edition (XE) :: Display A List Of All User And Admin Accounts

Jan 28, 2013

I've installed XE and I want to know what accounts are active. If I log in to SQL*Plus as sys as SYSDBA how can I display a list of all user and admin accounts? I want to know who can log in.

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved